mysql-error: Unknown column 'realname'!?

Found a bug? Tell us!!
Post Reply
stm999999999
Regular
Posts: 1531
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

mysql-error: Unknown column 'realname'!?

Post by stm999999999 »

saving a new entry on an 1.3alpa1 I got suddenly this:

Code: Select all

Fehler: 
UPDATE serendipity_bauen_entries SET id='43', title='xxx', timestamp='1186661223', body=' xxx', isdraft='true', allow_comments='true', moderate_comments='false', exflag='1', trackbacks='0', comments='0', realname='xxx', authorid='1'  WHERE id='43'
/ Unknown column 'realname' in 'field list'
what the heck is this realname there? There is no field in s9y_entries and I did not found any change for this in the last time.

Saving a second time worked perfect! :?:
Ciao, Stephan
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: mysql-error: Unknown column 'realname'!?

Post by garvinhicking »

Hi!

Maybe caused by an event plugin?

It works here for me - I tried: Creating a new entry, saving it, saving it again. Editing an existing entry, saving it, saving it again.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
stm999999999
Regular
Posts: 1531
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Post by stm999999999 »

as I said: After the first occuring of this error, all further savings (for this and other entries) work perfectly.

But, quantum fluctuations could not realy be the reason for the error - somewhere in the code there must be this realname-code, or? :?:
Ciao, Stephan
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

serendipity_upertEntry listens to all array keys of the $eventData entry array. So any code or plugin could have (accidantely) added the array key 'realname' to the entry. If you add $entry['blabla'] the updertEntry function would try to updat ethe nonexisting 'blabla' column.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply