Last modified: 2012-12-31 16:50:37 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T31038, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 29038 - regression code in command-line updating : no prefix in the database table 'user'
regression code in command-line updating : no prefix in the database table 'u...
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.20.x
PC Linux
: Normal critical (vote)
: ---
Assigned To: Nobody - You can work on this!
aklapper-moreinfo
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-05-18 16:41 UTC by Bertrand GRONDIN
Modified: 2012-12-31 16:50 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bertrand GRONDIN 2011-05-18 16:41:36 UTC
when launching the following command-line
php maintenance/update.php

the userDupe.inc file does not include the database table prefix.

In my LocalSettings.php I've included : 
$wgDBprefix= "gdn";

But the script stopped with the following messages : 


MediaWiki 1.19alpha Updater

Going to run database updates for grondin-gdn
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards
...hitcounter table already exists.
...have rc_type field in recentchanges table.
...user table does not exist, skipping new field patch
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...PRIMARY key already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...user table does not exist, skipping new field patch
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...user table does not exist, skipping new field patch
...have ar_text_id field in archive table.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
A database query syntax error has occurred.
The last attempted database query was:
"SHOW INDEX FROM `grondin`.`user`"
from within function "UserDupes::hasUniqueIndex".
Database returned error "1146: Table 'grondin.user' doesn't exist (localhost)"


the programme ought to read the table 'grondin.gnduser'

… and the wiki is down.
Comment 1 Bertrand GRONDIN 2011-05-18 16:49:53 UTC
I tested it at the r88369.
Comment 2 Chad H. 2011-05-19 17:25:24 UTC
Weird, its using indexInfo() which uses tableName(), it should be respecting the prefix...
Comment 3 Bertrand GRONDIN 2011-05-20 04:33:31 UTC
No, it omitted the prefix of the data base.
Comment 4 Alexandre Emsenhuber [IAlex] 2012-03-19 16:49:28 UTC
If the updater used 'grondin.user', this mean that you have set a shared database using $wgSharedDB (by default the user table is in $wgSharedTables). Please check this and if this is the case set $wgSharedPrefix accordingly.
Comment 5 Max Semenik 2012-07-27 15:52:53 UTC
Bertrand, can you respond to this:
> If the updater used 'grondin.user', this mean that you have set a shared
> database using $wgSharedDB (by default the user table is in $wgSharedTables).
> Please check this and if this is the case set $wgSharedPrefix accordingly.
Comment 6 Andre Klapper 2012-11-06 18:22:27 UTC
Bertrand, could you please answer comment 4?
Comment 7 Andre Klapper 2012-12-31 16:50:37 UTC
Unfortunately closing this report as no further information has been provided.

Bertrand: Please feel free to reopen this report if you can provide the information asked for. Thanks!

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links