Last modified: 2014-10-21 16:33:27 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 T67658, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 65658 - Database tables not created on Postgres: ERROR: relation "oathauth_users" does not exist
Database tables not created on Postgres: ERROR: relation "oathauth_users" doe...
Status: PATCH_TO_REVIEW
Product: MediaWiki extensions
Classification: Unclassified
OATHAuth (Other open bugs)
REL1_22-branch
PC Linux
: Normal blocker (vote)
: ---
Assigned To: Ryan Lane
:
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2014-05-22 23:37 UTC by Rhiannon Portwood
Modified: 2014-10-21 16:33 UTC (History)
1 user (show)

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


Attachments

Description Rhiannon Portwood 2014-05-22 23:37:54 UTC
I’m encountering a very interesting issue with the stable v1.22 OATHAuth extension.  Please help!  I am stuck!  It appears that the required tables that should be in place to function are not present.

My specs are as follows:
•	CentOS release 6.5 (Final), Kernel 2.6.32-431.17.1.el6.x86_64
•	PHP 5.3.3
•	Apache/2.2.15
•	psql (PostgreSQL) 9.3.4
•	Hypervisor Virtual Infrastructure Platform 6.22
•	Snapshot: b541656

According to the documentation you do support Postgresql (which is fantastic btw.)

Steps to replicate:
1.	http://www.mediawiki.org/wiki/Extension:OATHAuth
2.	Select Download.
3.	Select Stable version 1.22
4.	Migrate downloaded tar.gz to wiki server.
5.	Move wikimedia-mediawiki-extensions-OATHAuth-b541656 to OATHAuth
6.	Change permissions to apache:apache, 755.
7.      run: php /maintenance/update.php
8.	Browse to Special Pages to verify working.
9.	Sadness ensues at database error.
10.	Spend next 2 days researching.

I have an image below and the actual text of the error at the bottom of the email.  It appears that the tables are not being created.

Database details seem solid, however, not sure why it would not create. 

Are there custom steps to take?  Do you have a README for your github stuff?
-------------------------------------------------------------------------
Full Err:

A database query error has occurred. This may indicate a bug in the software.
•	Query:
SELECT id,secret,secret_reset,scratch_tokens,scratch_tokens_reset,is_validated FROM "oathauth_users" WHERE id = '1' LIMIT 1
•	Function: OATHUser::newFromUser
•	Error: 42P01 ERROR: relation "oathauth_users" does not exist LINE 1: ...ch_tokens,scratch_tokens_reset,is_validated FROM "oathauth_... ^
Backtrace:
#0 /var/www/html/includes/db/DatabasePostgres.php(482): DatabaseBase->reportQueryError('ERROR: relatio...', '42P01', 'SELECT id,secr...', 'OATHUser::newFr...', false)
#1 /var/www/html/includes/db/Database.php(1039): DatabasePostgres->reportQueryError('ERROR: relatio...', '42P01', 'SELECT id,secr...', 'OATHUser::newFr...', false)
#2 /var/www/html/includes/db/Database.php(1496): DatabaseBase->query('SELECT id,secr...', 'OATHUser::newFr...')
#3 /var/www/html/includes/db/Database.php(1585): DatabaseBase->select('oathauth_users', Array, Array, 'OATHUser::newFr...', Array, Array)
#4 /var/www/html/extensions/OATHAuth/OATHUser.php(170): DatabaseBase->selectRow('oathauth_users', Array, Array, 'OATHUser::newFr...')
#5 /var/www/html/extensions/OATHAuth/special/SpecialOATH.php(17): OATHUser::newFromUser(Object(User))
#6 /var/www/html/includes/SpecialPageFactory.php(337): SpecialOATH->__construct()
#7 /var/www/html/includes/SpecialPageFactory.php(365): SpecialPageFactory::getPage('OATH')
#8 /var/www/html/includes/specials/SpecialSpecialpages.php(54): SpecialPageFactory::getUsablePages(Object(User))
#9 /var/www/html/includes/specials/SpecialSpecialpages.php(42): SpecialSpecialpages->getPageGroups()
#10 /var/www/html/includes/SpecialPage.php(631): SpecialSpecialpages->execute(NULL)
#11 /var/www/html/includes/SpecialPageFactory.php(488): SpecialPage->run(NULL)
#12 /var/www/html/includes/Wiki.php(298): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#13 /var/www/html/includes/Wiki.php(602): MediaWiki->performRequest()
#14 /var/www/html/includes/Wiki.php(467): MediaWiki->main()
#15 /var/www/html/index.php(49): MediaWiki->run()
#16 {main}

I look forward to your reply.
Comment 1 Tyler Romeo 2014-05-27 18:08:23 UTC
The reason for this is because this extension does not have support for anything other than MySQL.
Comment 2 Gerrit Notification Bot 2014-05-27 19:49:11 UTC
Change 135618 had a related patch set uploaded by Parent5446:
Add non-MySQL database support

https://gerrit.wikimedia.org/r/135618
Comment 3 Rhiannon Portwood 2014-05-27 20:20:30 UTC
Fantastic!  Thank you!
Comment 4 Andre Klapper 2014-06-30 13:38:22 UTC
Tyler's patch has one -1 in Gerrit because Jeff had issues with merging.

Rhiannon: Did you have a chance to test Tyler's patch?
Comment 5 Andre Klapper 2014-10-21 16:33:27 UTC
Rhiannon: Did you have a chance to test Tyler's patch?

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


Navigation
Links