Updating attachment issue with Mysql 5.0.18 in SMF 1.1.2

When trying to update (creation works well) a post, which has attachements it often (nearly) happens that my mysql 5.0.18 crashes.

I looked into the statement and saw that it shouldn't be (around line 568):

( a.attachmentType =3 AND thumbparent.IDTHUMB = a.ID_ATTACH )

mysql 5 doesn't crash when using this instead:

( thumbparent.IDTHUMB = a.ID_ATTACH AND a.attachmentType =3 )

Basicly this seems to be an mysql 5.0 issue, but this quickfix helped me to keep my site working with smf attachements.

I posted already a

bugreport on official simplemachines site.

In mysql, open source, smf by
@ 06 Apr 2007, Comments at Reddit & Hackernews

Give something back

Were my blog posts useful to you? If you want to give back, support one of these charities, too!

Report hate in social media Campact e.V. With our technology and your help, we protect the oceans from plastic waste. Gesellschaft fur Freiheitsrechte e. V. The civil eye in the mediterranean

Recent Dev-Articles

Read recently

Recent Files