Page MenuHomePhabricator

Extension:OAuthAuthentication -- Creating oauthauth_user table failed when running update.php
Closed, ResolvedPublic

Description

The project is wrong, but there is no MediaWiki-extensions-OAuthAuthentication

Installing latest git HEAD OAuthAuthentication 0.1.0 (447959c) 20:43, 5 May 2015 on MediaWiki 1.24.2 (8fc8611) (https://tools.wmflabs.org/commonsarchive/wiki/Special:Version):

Creating oauthauth_user table ...[68581be1] [no req] Exception from line 3882 of /data/project/commonsarchive/public_html/w/includes/db/Database.php: Could not open "/data/project/commonsarchive/public_html/w/extensions/OAuthAuthentication/utils../store/oauthauth.sql".

Backtrace:
#0 /data/project/commonsarchive/public_html/w/includes/installer/DatabaseUpdater.php(654): DatabaseBase->sourceFile(string)
#1 /data/project/commonsarchive/public_html/w/includes/installer/DatabaseUpdater.php(677): DatabaseUpdater->applyPatch(string, boolean, string)
#2 [internal function]: DatabaseUpdater->addTable(string, string, boolean)
#3 /data/project/commonsarchive/public_html/w/includes/installer/DatabaseUpdater.php(442): call_user_func_array(array, array)
#4 /data/project/commonsarchive/public_html/w/includes/installer/DatabaseUpdater.php(407): DatabaseUpdater->runUpdates(array, boolean)
#5 /data/project/commonsarchive/public_html/w/maintenance/update.php(163): DatabaseUpdater->doUpdates(array)
#6 /data/project/commonsarchive/public_html/w/maintenance/doMaintenance.php(101): UpdateMediaWiki->execute()
#7 /data/project/commonsarchive/public_html/w/maintenance/update.php(206): require_once(string)
#8 {main}

Event Timeline

zhuyifei1999 raised the priority of this task from to Needs Triage.
zhuyifei1999 updated the task description. (Show Details)

After the temporary hack of adding a / to Hooks.php L48:

Creating oauthauth_user table ...A database query error has occurred.
Query: CREATE TABLE oauthauth_user (
oaau_rid int(10) unsigned NOT NULL,
oaau_uid int(10) unsigned NOT NULL PRIMARY KEY,
oaau_username varchar(255) binary not null,
oaau_access_token varchar(127) binary not null default '',
oaau_access_secret varchar(127) binary not null default '',
oaau_identify_timestamp binary(14) not null default '',
) ENGINE=InnoDB, DEFAULT CHARSET=binary

Function: DatabaseBase::sourceFile( /data/project/commonsarchive/public_html/w/extensions/OAuthAuthentication/utils/../store/oauthauth.sql )
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB, DEFAULT CHARSET=binary' at line 8 (tools-db)

Change 211093 had a related patch set uploaded (by Gerrit Patch Uploader):
Install: Fixes for oauthauth_user table creation:

https://gerrit.wikimedia.org/r/211093

Change 211093 merged by jenkins-bot:
Install: Fixes for oauthauth_user table creation:

https://gerrit.wikimedia.org/r/211093

zhuyifei1999 claimed this task.