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(a)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(a)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