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 !
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
