Installation Error - Unknown column 'M' in 'field list'

eemanuelson -- on Aug. 9 2005

Error at 'Creation of basic items in the database' step

Installation has been easy so far, but I've reinstalled three times only to get this far with the same error,

'INSERT INTO `yacs`.`yacs_users` SET id='M',email='M', active='M', avatar_url='M', aim_address='M', capability='M', create_name='M', create_id='M', create_address='M', create_date='M', description='M', edit_name='M', edit_id='M', edit_address='M', edit_action='M', edit_date='M', from_where='M', full_name='M', handle='M', icq_address='M', interests='M', introduction='M', irc_address='M', jabber_address='M', login_date='M', msn_address='M', nick_name='M', options='M', password='M', pgp_key='M', post_date='M', posts=M, signature='M', skype_address='M', web_address='M', with_newsletters='N', yahoo_address='M' 1054: Unknown column 'M' in 'field list''

Any help please?

Page bottom

Bernard from nearby-an-airport Associate, 6807 posts	on Aug. 9 2005 I supposed you are using the very last release of YACS, and will attempt to reproduce the problem on my development system. Don't know where this M comes from... Mother? Mood? It will be killed anyway...
Eemanuelson 2 posts	inspired from Bernard on Aug. 9 2005 Bernard: Yes, I downloaded the latest release of YACS. The letter M changes with each installation...I've seen C, M, and X. Not sure what the letter comes from the nickname I've tried creating is "Administrator". Hope this helps.
Bernard from nearby-an-airport Associate, 6807 posts	inspired from eemanuelson on Aug. 22 2005 Eemanuelson: Unfortunately for you I have been able to install a brand new YACS server yesterday from scratch on a Linux box, with absolutely no problem. Therefore I have not been able to reproduce your issue up to now. Have you checked that your server is handling session data correctly? Visit control/test.php from your server and reload the page several time to see if the counter increments correctly. This may seem quite far away from your issue, but it is the only thing that comes to my mind at the moment, sorry...
Ceeboo 1 post	on Oct. 12 2005 I just wanna report that i got the same error. test.php was succesful, counter is working correctly. For server details: http://tsm.daspace.net/infophp.php I hope you're able to fix this soon. Thank you.
Vampyre 14 posts	inspired from ceeboo on Jan. 30 2006 I want to report the very same problem on my website : the installation is always starting back to the creation of database, while it has been populated, exception made of the user tables. I have the very same problem with the very same mistake (the only difference is that I have the 'Y' in field list. I have downloaded the very last version, available today on the servers. Thanks for letting me know what to do. Je souhaite reporter le même type de problème sur mon site internet : l'installation reprend toujours à la création de base de données, bien que celle-ci a été créée et possède du contenu, à l'exception de la table utilisateur. Même problème donc, avec les mêmes erreurs (la seule différence est que chez moi, il s'agit de la lettre Y dans le champ. J'ai téléchargé la dernière version (disponible ce jour sur votre serveur. Merci de m'informer sur la marche à suivre pour installer le serveur YACS.
Vampyre 14 posts	inspired from Vampyre on Jan. 30 2006 I just discovered the problem, and solved it... Here is what to do : This is my error : INSERT INTO `gueur_yacs`.`yacs_users` SET id='Y',email='Y', active='Y', avatar_url='Y', aim_address='Y', capability='Y', create_name='Y', create_id='Y', create_address='Y', create_date='Y', description='Y', edit_name='Y', edit_id='Y', edit_address='Y', edit_action='Y', edit_date='Y', from_where='Y', full_name='Y', handle='Y', icq_address='Y', interests='Y', introduction='Y', irc_address='Y', jabber_address='Y', msn_address='Y', nick_name='Y', options='Y', password='Y', pgp_key='Y', post_date='Y', posts=Y, signature='Y', skype_address='Y', web_address='Y', with_newsletters='Y', yahoo_address='Y' 1054: Champ 'Y' inconnu dans field list If, after having set up everything, we make a sql injection directly into phpmyadmin for example, with the very same (copy and paste) code modified like shown here below, everything is working back correctly : INSERT INTO `gueur_yacs`.`yacs_users` SET id='Y',email='Y', active='Y', avatar_url='Y', aim_address='Y', capability='Y', create_name='Y', create_id='Y', create_address='Y', create_date='Y', description='Y', edit_name='Y', edit_id='Y', edit_address='Y', edit_action='Y', edit_date='Y', from_where='Y', full_name='Y', handle='Y', icq_address='Y', interests='Y', introduction='Y', irc_address='Y', jabber_address='Y', msn_address='Y', nick_name='Y', options='Y', password='Y', pgp_key='Y', post_date='Y', posts='Y', signature='Y', skype_address='Y', web_address='Y', with_newsletters='Y', yahoo_address='Y' it just work fine !
Bernard from nearby-an-airport Associate, 6807 posts	on Jan. 30 2006 Vampyre: From a formal standpoint, the initial SQL query says "posts=Y", because posts is supposed to be of integer type. This would be correct with posts=123, but of course Y is not an acceptable value for a number. phpMyAdmin adds quotes around the Y letter, making it a correct statement. Anyway, what is not clear to me is why YACS builds such a strange statement during the setup phase. Can you confirm that the problem arises only on a pre-populated database, except for the user table? If yes, I will create a specific test environment for these conditions. Thank you very much for the bug reporting, and for the follow-up. Merci et à bientôt
Vampyre 14 posts	inspired from Bernard on Jan. 30 2006 Bernard : This is what I've done... Host : Celeonet phpinfo : phpinfo.celeonet.fr I create an empty database. I upload the files onto my ftp I load the install script. I fill all the infos. I have no error reported, until I come with the first user Info. Then, it always tell me the error code mentioned here above. The user name is Vampyre (it seems to modify those letters). If you want to see it by your own eyes, it can be done also : I upload all the files onto my webspace, I create the database (empty), and I send you on private all the details to make the installation as I've done it. Maybe it will be a little bit more luck to see the problem without having to recreate the very same environment... Tell me if you come up with something... Thanks for your quick answer, Yours, Vampyre
Bernard from nearby-an-airport Associate, 6807 posts	inspired from Vampyre on Jan. 30 2006 Vampyre: Could we have some private Skype or Yahoo! session together tonight on this topic? Thank you for your kind offer
Vampyre 14 posts	inspired from Bernard on Jan. 30 2006 Bernard : Hi again, I'll try to connect via Skype tonight, or tomorrow anytime during the day (maybe more tomorrow than tonight as I have finished work a little bit late, and I want to spend some time with my wife and daughter ) I don't Skype, but I'll try to figure out how it will work... I have MSN account, but Skype sounds good to me For the moment, I have some problems with my host (some delay while FTPing)... It will be solved in about an hour. I'll FTP the latest files when I come back home, and it should be ready for testing purposes as soon as it is done... If it is OK for you, I'll be available by tomorrow morning anytime (day off tomorrow) for you to test it via Skype... Thanks again for the very quick answers, Vampyre
Vampyre 14 posts	inspired from Vampyre on Jan. 30 2006 Vampyre : Hi again Bernard, Thanks for your quick answers... I just downloaded Skype, and will be available from tomorrow anytime (I just won't be home from 2:30 pm to 3:30 pm, the time for me to go and catch my daughter at school). here is my Skype ID : VampyreBe Or if you prefer, I can send you all the datas you need to check yourself about this problem... by email of course All the files are uploading now, the problem with my hoster has been solved, the database has been created, but not populated yet, and everything is ready for a fresh install... Just need you Thanks again for your precious help Bernard, Vampyre
Bernard from nearby-an-airport Associate, 6807 posts	inspired from Vampyre on Jan. 30 2006 Vampyre: Ok, let's go for tomorrow. However, I use Skype only at home on evening. Therefore, could you please send me details of your installation by e-mail? (Click on my user profile to find it)
Vampyre 14 posts	inspired from Bernard on Jan. 31 2006 Bernard : Ok, i send you all the details by mail right away
Vampyre 14 posts	inspired from Vampyre on Jan. 31 2006 Vampyre : Email has been sent
Vampyre 14 posts	inspired from Vampyre on Jan. 31 2006 Comme je l'ai signalé par email, le problème a disparu de lui-même... C'est à n'y rien comprendre ! Probablement un problème temporaire chez mon hébergeur ? Merci en tous cas pour ta patience ! Vampyre
Mesange 1 post	on Feb. 11 2006 I am an administrator of Celeonet. The problem is there only when the version of mysql is 4.1.x. There is no problem if this version is 4.0.x The request executed by the command line gives this error : mysql> INSERT INTO `ourceleo4_yacs`.`yacs_users` SET id='Y',email='Y', active='Y', avatar_url='Y', aim_address='Y', capability='Y', create_name='Y', create_id='Y', create_address='Y', create_date='Y', description='Y', edit_name='Y', edit_id='Y', edit_address='Y', edit_action='Y', edit_date='Y', from_where='Y', full_name='Y', handle='Y', icq_address='Y', interests='Y', introduction='Y', irc_address='Y', jabber_address='Y', msn_address='Y', nick_name='Y', options='Y', password='Y', pgp_key='Y', post_date='Y', posts=Y, signature='Y', skype_address='Y', web_address='Y', with_newsletters='Y', yahoo_address='Y'; ERROR 1054 (42S22): Champ 'Y' inconnu dans field list If the request has post ='Y' and not post = Y, this works. Mysql 4.1 is more strict on the syntax of requests.

16 comments

Rate this page
Posted by Eemanuelson on Aug. 9 2005, edited by Mesange on Aug. 9 2005, (popular)