Skip to main content Help Control Panel

YACS CMS : Open source !

Community «   Discussion forum «   Installation support «   Installation Error - Unknown column 'M' in 'field list' «  

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

<< Previous Next >>

Comment inspired from Vampyre

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 !

by Vampyre on Jan. 30 2006