Forums: Index Help desk MySQL error (images)
Fandom's forums are a place for the community to help other members.
To contact staff directly or to report bugs, please use Special:Contact.

This discussion has been copy to Inside wikia forum, please refer to there --Cizagna (Talk) 19:40, 2 June 2007 (UTC)

First i was going to report this at Bugs.wikia.com but i dont want to create another user account for a wikia site and this is why.

When accessing at dofus.wikia w:c:Dofus:Image:Wabbit's Paw.PNG

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "". MySQL returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Paw.PNG'' at line 1 (216.224.121.137)".

When accessing at dofus.wikia w:c:Dofus:Image:Wabbit's Paw.png

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "". MySQL returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Paw.png'' at line 1 (216.224.121.137)".

When accessing at dofus.wikia w:c:Dofus:Image:Wabbits Paw.png the image does not load on the image page but if you click on the image link you can see the page.

And now as a little extra. Semantic Mediawiki does not apear on the Special:Version page and is not activated even thought the tech told Sannse it was wiki wide maybe we are doing something wrong =/ --Cizagna (Talk) 19:21, 1 June 2007 (UTC)

When accessing at dofus.wikia w:c:Dofus:Image:Klime's Small Boots.png

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "". MySQL returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Small Boots.png'' at line 1 (216.224.121.137)".

--Cizagna (Talk) 03:15, 2 June 2007 (UTC)

It seems a wikia wide problem parsing the (') character in image URLs (also in inside). --Ciencia Al Poder (talk) -@WikiDex 10:04, 2 June 2007 (UTC)

We've seen the same problem on the RuneScape sub-wiki too

In particular, it's images with a single quote (') or a percent (%) in the name.

The images with a % seem to fail to find the image. Those with the ' seem to report the bad SQL error:

Database error

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "". MySQL returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's warspear.png'' at line 1 (216.224.121.137)".

Given that both ' and % are special characters to SQL, it's as if the code is no longer properly escaping the characters in the SQL calls. This seems to only be a problem with images, not with normal pages.

--Amaurice (Talk) 16:25, 5 June 2007 (UTC)

Seems to be fixed now :-) --Amaurice (Talk) 17:19, 5 June 2007 (UTC)

Community content is available under CC-BY-SA unless otherwise noted.