Page 1 of 1

mysql-error: Unknown column 'realname'!?

Posted: Thu Aug 09, 2007 2:29 pm
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! :?:

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

Posted: Thu Aug 09, 2007 2:35 pm
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

Posted: Thu Aug 09, 2007 6:09 pm
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? :?:

Posted: Thu Aug 09, 2007 6:24 pm
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