S9y 0.8alpha9 : post saving or preview sometimes fail

Found a bug? Tell us!!
Post Reply
Guest

S9y 0.8alpha9 : post saving or preview sometimes fail

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

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

Post 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.
# 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/
lyc1
Posts: 3
Joined: Thu Dec 30, 2004 11:31 pm
Location: Nantes, France

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

Post 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)
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

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

Post 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
# 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