[12:19:07] question about use of {{NAMESPACE:namespacename}} per https://www.mediawiki.org/wiki/Help:Magic_words#Namespaces [12:19:40] {{NAMESPACE:MediaWiki}} no longer returns a value for the ns [12:20:19] oh wait [12:20:24] not to worry [17:49:31] Is there any sort of technical issue from installing the latest version of mediawiki on a somewhat ancient repo copy of php5.5? For whatever reason I can't get the php7 package to install >< [17:55:44] stupid question. My bad. [18:04:09] Ulfr: yes, it'll error out telling you need to use a newer version :) [18:05:01] legoktm: Yup. Noticed the error message and immediately facepalmed. Sort of annoyed that the trusty php7 ppa is borked though [18:06:06] why are you still using trusty :o [18:06:13] I think 1.27 is the last 5.5 compatible version [18:06:47] Trust me, I'd much rather be using something newer. Sadly there's no authorized server images for anything more recent. :< [18:07:48] Looks like I might have to though, if the ppa won't even talk to my decrepit servers [19:21:21] I am in the throws of migrating a MediaWiki 1.17.0 with shared database to a new server with 1.29.3 (yes, I know this isn't the latest, but MySQL and PHP upgrades are needed for higher) [19:22:09] I thought I had successfully ran update.php, until I tried to log in. Then the shared database issues. I've worked through a couple, but now I'm stuck if anyone is feeling generous. [19:25:41] Query: SHOW INDEX FROM `wiki_shared`.`wiki_npd`.`wiki_user` Function: UserDupes::hasUniqueIndex 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 '.`wiki_user`' at line 1 (127.0.0.1) [19:26:26] Why 1.29.3? [19:27:06] Can you identify what wiki_shared and wiki_npd are? [19:27:17] cause it lookes like it's trying to do SHOW INDEX FROM database.table.table [19:27:19] seems like problem with mysql version and mediawiki version [19:27:37] if it says syntax [19:28:48] uh, shareddatabase.wikidatabase.table [19:29:08] wiki_npd is the main database for one of two wikis running on the old server (just trying to get the first running on the new one) [19:29:26] wiki_shared is the shared database between the two ... common user login info [19:30:53] MediaWiki 1.29.3 because of PHP version (5, but not 7) and MySQL 5.0.3 (https://www.mediawiki.org/wiki/Compatibility) [19:31:57] I don't think it's a syntax error from mysql version [19:32:40] mysql version is 5.5.62 [19:32:50] you just said 5.0.3 ;) [19:33:11] I did. I copied that from the chart on the link I posted [19:33:13] sorry :) [19:34:21] https://github.com/wikimedia/mediawiki/blob/REL1_29/maintenance/userDupes.inc#L61 [19:34:23] That code hasn't changed... [19:34:34] I'm guessing MW is doing something odd with shared table handling underneath though [19:36:01] Right before the error I posted was: [9c67afbad62952b4ecafeeac] [no req] Wikimedia\Rdbms\DBQueryError from line 1075 of /u01/tekki/export/wikitools/mw/1.29.3/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? [19:36:23] Which isn't all that helpful while running update.php to upgrade. [19:37:04] I am running update.php from the command line, with --doshared [19:37:36] Been messing with $wgDBmwschema and $wgDBuser (didn't have either before) [19:42:35] wgDBuser defaults to wikiuser [19:43:09] I think there were some issues with wgDBmwschema recently though... [19:43:13] (like pg only) [19:43:23] And maybe then something between $wgSharedSchema and $wgDBmwschema [19:43:54] Ok, wgDBuser was set right after all, I got panicky [19:44:12] for reference, you can look at includes/DefaultSettings.php to see the "defaults" [19:45:39] After I undid my panic change to $wgDBuser, I got back to my last error: [150a30ea3811b8066b6de1b4] [no req] Wikimedia\Rdbms\DBQueryError from line 1075 of /u01/tekki/export/wikitools/mw/1.29.3/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SHOW INDEX FROM `wiki_shared`.`wiki_npd`.`wiki_user` Function: UserDup [19:45:53] What is wgDBmwschema set to? [19:46:07] 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 '.`wiki_user`' at line 1 (127.0.0.1) [19:47:20] $wgDBmwschema = $wgDBname; [19:47:29] Set a couple lines after $wgDBname [19:47:52] And $wgSharedSchema ? [19:49:12] $wgSharedSchema not set. There is $wgSharedDB set to wiki_shared [19:52:14] I just set $wgSharedSchema to true, retried update.php: Creating user_properties table ...[854aed28fb24f62c8787443c] [no req] Wikimedia\Rdbms\DBQueryError from line 1075 of /u01/tekki/export/wikitools/mw/1.29.3/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: CREATE TABLE `wiki_shared`.`wiki_user_properties`( u [19:53:11] That looks more sensible [19:53:15] Query: CREATE TABLE `wiki_shared`.`wiki_user_properties`( up_user int not null, up_property varbinary(32) not null, up_value blob ) ENGINE=InnoDB Function: Wikimedia\Rdbms\Database::sourceFile( /u01/tekki/export/wikitools/mw/1.29.3/maintenance/archives/patch-user_properties.sql ) Error: 1050 Table 'wiki_user_properties' already exists (127.0.0.1) [19:53:16] Should it have the wiki_ prefix on tables? [19:54:12] The mysql show databases; shows 7 databases including wiki_npd and wiki_shared [19:54:38] and the tables in wiki_shared? [19:56:27] wiki_user and wiki_user_properties [19:57:08] so why is it trying to create a table that exists already? :) [19:57:30] I do not know, that is what I am hoping you can tell me. [19:58:38] why are you using 1.29 btw? [19:58:48] That patch/table is from 1.16... [19:59:12] Which means it's failing because it doesn't exist [19:59:33] It kinda sounds like it's checking a different db to the one it's executing against [19:59:42] The existing server (that I have been trying to get my IT department to provide an upgrade for for 5 years now) is running 1.17.0 [20:01:01] Finally got IT to provide a new server, it has MySQL 5.5.6 and PHP 5.6 [20:01:41] I figured it would be easier to move to a slightly obsolete version of MediaWiki than to get them to upgrade those services [20:02:14] 1.29.3 was the latest version according to https://www.mediawiki.org/wiki/Compatibility that would work with this. [20:03:39] Ah, that mysql bump we did :/ [20:04:44] sorry, I was mostly checking you hadn't chose the version arbitarily, because sometimes people do [20:05:11] I seem to recall there being some work on the shared table stuff in the last few releases, but can't remember offhand what/where [20:05:29] No worries, I am trying not to ask stupid questions [20:11:55] mysql> show columns from wiki_user_properties; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | up_user | int(11) | NO | PRI | NULL | | | up_property | varbinary(32) | NO | PRI | NULL | | | up_value | blob | YES | | NULL | | +--------- [20:12:20] Ugly sorry ... wiki_user_properties has up_user, up_property, up_value [20:13:40] wiki_user has user_id, user_name, user_real_name, user_password, user_newpassword, user_email, user_options, user_touched, user_token, user_email*3, user_registration, user_newpass_time, user_editcount [20:13:59] yeah, it's trying to create the table incorrectly [20:17:58] Trying the dpaste thing ... https://dpaste.de/BR2k [20:18:22] Error: 1050 Table 'wiki_user_properties' already exists (127.0.0.1) [20:18:27] Yeah, the question is why it's trying to do that [20:18:56] I am willing to try commenting out some lines, see if it can get past that. [20:19:10] That's been the story of getting this far. [20:19:12] Might be worth a try till you can get PHP/mysql upgraded and to a newer MW version [20:19:21] If it's still broken on a supported version, it's a reportable bug [20:21:57] The first place I looked was DatabaseUpdater.php, that looks good (and why isn't it finding the existing table?) https://dpaste.de/UYkS [20:22:49] I'm guessing it's not respecting the shared tables parts [20:23:37] Seems a lot like https://phabricator.wikimedia.org/T158154 [20:23:51] julie_: Are you using --doshared? [20:24:43] I am doing --doshared, I don't have a $wgSharedTables [20:27:09] Didn't have $wgSharedPrefix nor $wgDBprefix [20:34:00] What I just did ... commented out everything in maintenance/archives/patch-user_properties.sql [20:34:12] update.php looked like it ran successfully (again) [20:34:54] When I try to log in (I do get that far), https://dpaste.de/AYcN [20:35:37] Perhaps I can add a column to that table called user_password_expires? [20:44:52] From patch-user_user_password_expire.sql, I stole: mysql> ALTER TABLE wiki_user -> ADD COLUMN user_password_expires varbinary(14) DEFAULT NULL; [20:46:05] Looked like it worked, I am now onto a new exciting (?) problem if the gob of custom extensions someone left me. [20:46:17] So, good news, I think I am past this database thang [20:47:07] Are you able to get mysql (and php) upgraded? [20:47:24] Cause I'd be interested to know if things are stilll able broken on supported (and long term) releases [20:47:32] Yes :) I commented out yet one more of those #$#&% extensions I inherited the maintenance of, and I have my MainPage mostly up. Still some skin thing, but progress. [20:47:42] Thanks @Reedy. [20:47:56] Did you upgrade all your skins and extensions? (where they come from us) [20:49:53] I did upgrade the skins, had to, 1.29.3 comes with no skins [20:51:52] So, now as my logged in self, I see the body of our main page (using MonoBook), but don't have top toolbar, tabs, logo, left toolbar, bottom stuff [20:53:56] Errors show am missing load.php ... might be able to fix that quick [20:56:06] Linked load.php (don't even ask about the rats nest of symbolic links) and now I get the left toolbar stuff underneath the body [20:56:11] Progress [20:56:53] :) [20:56:59] We don't tend to add too many new entry points [20:57:02] But occasionally we do [21:06:41] Thanks again, I will have to retire for today [21:43:04] helllo