Last modified: 2010-05-15 15:38:48 UTC
When deleting an image, I get the following error: Databasefejl Fra Wikipedia, den frie encyklopædi Der er sket en syntaksfejl i en databaseforespørgsel. Den sidst forsøgte databaseforespørgsel var: DELETE `text` FROM `text`, `revision` WHERE old_id=rev_id AND (rev_page = 1009) fra funktionen "Article::doDeleteArticle". MySQL returnerede fejlen "1064: You have an error in your SQL syntax near 'text` FROM `text`, `revision` WHERE old_id=rev_id AND (rev_page = 1009)' at line 1 (localhost)". The error backtrace is: Using reader #0: localhost Article::doDeleteArticle SQL ERROR: You have an error in your SQL syntax near 'text` FROM `text`, `revisi on` WHERE old_id=rev_id AND (rev_page = 1009)' at line 1 (localhost) Skin::makeLink: 'Project:General_disclaimer' 'Disclaimers' '' '' '' '' Skin::makeLink: 'Wikipedia:Om' 'Om Wikipedia' '' '' '' '' ** no caching ** WARNING: Abrupt exit in /home/wegge/playwiki/includes/GlobalFunctions.php at line 457 WARNING: Abrupt exit in /home/wegge/playwiki/includes/OutputPage.php at line 622 WARNING: Abrupt exit in /home/wegge/playwiki/includes/Database.php at line 361 WARNING: Abrupt exit in /home/wegge/playwiki/includes/Database.php at line 310 WARNING: Abrupt exit in /home/wegge/playwiki/includes/Database.php at line 1116 WARNING: Abrupt exit in /home/wegge/playwiki/includes/Article.php at line 1748 WARNING: Abrupt exit in /home/wegge/playwiki/includes/ImagePage.php at line 360 WARNING: Abrupt exit in /home/wegge/playwiki/includes/ImagePage.php at line 272 WARNING: Abrupt exit in /home/wegge/playwiki/index.php at line 179
Which MySQL version are you using?
(In reply to comment #1) > Which MySQL version are you using? MySQL 3.23.58 PHP 4.3.11, in case that might be an issue.
The SQL statement that fails works with MySQL >4. Not with MySQL 3. Do we still support MySQL 3 in MediaWiki 1.5?
The joined delete query is no longer used, so this should be fixed.
