Here is what I have done: 1. Restore database from 1.3 2. Update to 1.4 3. Attempted update to 1.5, see output below
# php upgrade1_5.php 2006-04-07 11:59:08: Checking cur table for unique title index and applying if necessary wikidb: cur table has the old non-unique index and may have duplicate entries. A database error has occurred Query: LOCK TABLES `cur` WRITE, `old` WRITE Function: Error: 1044 Access denied for user: 'wikiuser@localhost' to database 'wikidb' (localhost)
Backtrace: GlobalFunctions.php line 450 calls wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php line 347 calls databasemysql::reportqueryerror() cleanupDupes.inc line 32 calls databasemysql::query() cleanupDupes.inc line 126 calls fixdupes() FiveUpgrade.inc line 334 calls checkdupes() FiveUpgrade.inc line 49 calls fiveupgrade::upgradepage() upgrade1_5.php line 22 calls fiveupgrade::upgrade()
so then I granted the wiki user lock_tables_priv and ran the command again and got this:
# php upgrade1_5.php 2006-04-07 12:06:45: Checking cur table for unique title index and applying if necessary wikidb: cur table has the old non-unique index and may have duplicate entries. A database error has occurred Query: LOCK TABLES `cur` WRITE, `old` WRITE Function: Error: 1044 Access denied for user: 'wikiuser@localhost' to database 'wikidb' (localhost)
Backtrace: GlobalFunctions.php line 450 calls wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php line 347 calls databasemysql::reportqueryerror() cleanupDupes.inc line 32 calls databasemysql::query() cleanupDupes.inc line 126 calls fixdupes() FiveUpgrade.inc line 334 calls checkdupes() FiveUpgrade.inc line 49 calls fiveupgrade::upgradepage() upgrade1_5.php line 22 calls fiveupgrade::upgrade()
I have no url, wiki is behind corporate fire wall.
On Apr 6, 2006, at 3:22 PM, Rob Church wrote:
On 06/04/06, Thomas Cherry jceaser@mac.com wrote:
Well, the table is not empty but it does not have any of my pages in it. I ran the update many times both through the browser and the command line. No errors. I can send the results if you want.
Restore the database from a backup (back to a clean state) and re-run the updater from the command line, then pastebin the output and send us the URL.
Rob Church _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-- Facts are meaningless. You could use facts to prove anything that's even remotely true. - Homer Simpson