https://bugzilla.wikimedia.org/show_bug.cgi?id=30120
Joss Winn <j...@josswinn.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |j...@josswinn.org
--- Comment #10 from Joss Winn <j...@josswinn.org> 2011-08-18 13:08:38 UTC ---
I have just upgraded to 1.17.0 and am experiencing this, too. I am using MySQL
5.5.15
Running php update.php as root fails to complete with the following message:
Creating iwlinks table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE `iwlinks` (
iwl_from int unsigned NOT NULL default 0,
iwl_prefix varbinary(20) NOT NULL default '',
iwl_title varchar(255) binary NOT NULL default ''
) TYPE=InnoDB
"
from within function "DatabaseBase::sourceFile(
/var/www/html/w/maintenance/archives/patch-iwlinks.sql )".
Database 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 'TYPE=InnoDB' at line 5 (localhost)"
When I run the web update from /mw-config/ it seems to run fine, producing the
following output from the same point:
Creating iwlinks table...ok
Adding iwl_prefix_title_from key to table iwlinks... ok
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...iwl_prefix_from_title key doesn't exist.
...have cl_collation field in categorylinks table.
...categorylinks up-to-date.
...collations up-to-date.
Creating msg_resource table...ok
Creating module_deps table...ok
...ar_page_revid key doesn't exist.
...ar_revid key already set on archive table.
...ll_lang is up-to-date.
Purging caches...done.
Checking site_stats row...done.
However, when I next try to delete a page, for example, mediawiki produces this
error in the browser, suggesting that the update script didn't work properly.
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 "DatabaseBase::delete". Database returned error "1146:
Table 'wikidb.iwlinks' doesn't exist (localhost)".
I then executed the patch SQL directly (maintenance/archive/patch-iwlinks.sql)
and it created the new table and allowed me to delete the page.
I then ran the update.php script again and it produced the following:
Creating msg_resource table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE `msg_resource` (
mr_resource varbinary(255) NOT NULL,
mr_lang varbinary(32) NOT NULL,
mr_blob mediumblob NOT NULL,
mr_timestamp binary(14) NOT NULL
) TYPE=InnoDB
"
from within function "DatabaseBase::sourceFile(
/var/www/html/w/maintenance/archives/patch-msg_resource.sql )".
Database 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 'TYPE=InnoDB' at line 6 (localhost)"
So, I executed the patch-msg_resource.sql script directly and it created two
new tables.
I ran update.php again and the same error happened for:
Creating module_deps table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE `module_deps` (
md_module varbinary(255) NOT NULL,
md_skin varbinary(32) NOT NULL,
md_deps mediumblob NOT NULL
) TYPE=InnoDB
"
from within function "DatabaseBase::sourceFile(
/var/www/html/w/maintenance/archives/patch-module_deps.sql )".
Database 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 'TYPE=InnoDB' at line 5 (localhost)"
So I ran patch-module_deps.sql and it created a new table.
Finally, I ran update.php again and everything went fine :-)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
