Advertisement:

Author Topic: [BUG] Sources/ManageAttachments.php:568 crashes MySQL-Server  (Read 3560 times)

Offline DracoBlue

  • Newbie
  • *
  • Posts: 6
[BUG] Sources/ManageAttachments.php:568 crashes MySQL-Server
« on: April 06, 2007, 06:19:49 AM »
Hello,

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):
Code: [Select]
( a.attachmentType =3 AND thumb_parent.ID_THUMB = a.ID_ATTACH )mysql 5 doesn't crash when using this instead:
Code: [Select]
( thumb_parent.ID_THUMB = 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.

Kind regards,
  Jan (DracoBlue)
« Last Edit: April 06, 2007, 06:42:46 AM by DracoBlue »
hxxp:dracoblue.net/dev [nonactive] • hxxp:www.newsflut.de [nonactive]  • hxxp:wp.dracoblue.net [nonactive]  • hxxp:gtat.dracoblue.net [nonactive]  • hxxp:crysis.dracoblue.net [nonactive] • hxxp:www.hglondon.net [nonactive] • hxxp:luanet.net [nonactive]

Offline Daniel15

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,222
  • Gender: Male
  • http://dan.cx/
    • daaniel on Facebook
    • Daniel15 on GitHub
    • daniel15 on LinkedIn
    • @Daniel15 on Twitter
    • Daniel15
Re: [BUG] Sources/ManageAttachments.php:568 crashes MySQL-Server
« Reply #1 on: April 06, 2007, 09:26:06 AM »
I tested this on my MySQL installation (5.0.32), and could not replicate it. Have you tried it with the latest MySQL version?

Have you edited the MySQL configuration in any way? If so, are you able to attach the my.cnf file here?
Also, is this on a Linux PC, or a Windows PC?
« Last Edit: April 06, 2007, 09:40:52 AM by Daniel15 »
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

Offline DracoBlue

  • Newbie
  • *
  • Posts: 6
Re: [BUG] Sources/ManageAttachments.php:568 crashes MySQL-Server
« Reply #2 on: April 06, 2007, 02:40:37 PM »
Its a linux machine, suse 10.0. Will try to update the server, and see if that helps.
hxxp:dracoblue.net/dev [nonactive] • hxxp:www.newsflut.de [nonactive]  • hxxp:wp.dracoblue.net [nonactive]  • hxxp:gtat.dracoblue.net [nonactive]  • hxxp:crysis.dracoblue.net [nonactive] • hxxp:www.hglondon.net [nonactive] • hxxp:luanet.net [nonactive]