Page 1 of 1

S9y 0.8alpha9 : post saving or preview sometimes fail

Posted: Fri Dec 31, 2004 9:01 am
by Guest
Hello

Once on two, I get an error when I save a new post.
Sometimes, it is

Erreur

UPDATE serendipity_entries SET id='3', title='Les sujets abordés', timestamp='1104672660', body='[...]', isdraft='false', allow_comments='true', moderate_comments='false', exflag='1', trackbacks='0', comments='0', username='Damien Lecan', last_modified='1104479759', authorid='2' WHERE id='3'

/ Unknown column 'username' in 'field list'

I cut the full text.

Sometimes, when the post preview is refreshed, preview doesn't reflect the new content.

It is hard to give a procedure to follow to reproduce these bugs, but they happen very often for me.

Re: S9y 0.8alpha9 : post saving or preview sometimes fail

Posted: Fri Dec 31, 2004 10:51 am
by garvinhicking
Hi!

That is really wicked, since there really is no "username" attribute in serendipity_entries. I wonder how the column gets in there.

Which event plugins do you have installed? Possibly one of them is creating this error.

Re: S9y 0.8alpha9 : post saving or preview sometimes fail

Posted: Fri Dec 31, 2004 12:47 pm
by lyc1
garvinhicking wrote:Which event plugins do you have installed? Possibly one of them is creating this error.
- Markup: Serendipity
- Markup: Emoticate
- Markup: NL2BR
- Spam Protector
- Fix common XHTML errors
- Extended properties for entries

And of course, the static page
- Page statique (cv-fr-damien-lecan)

Re: S9y 0.8alpha9 : post saving or preview sometimes fail

Posted: Sun Jan 02, 2005 7:36 pm
by garvinhicking
Thanks for the list. Of all the plugins, only the Entryproperties Plugin *may* cause the trouble.

Could you send a SQL dump of your serendipity_entryproperties DB-table? Maybe some keys are in there which trigger the unknown "username" column name. Because otherwise I really can't tell where that one comes from :(

Regards,
Garvin