**Author:** `rxtx206`
**Description:**
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.
--------------------------
**Version**: REL1_22-branch
**Severity**: blocker
**OS**: Linux
**Platform**: PC