Forum:MySQL error (images)

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 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 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 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 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:

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)