Topic on Extension talk:TwitterLogin

...twitter_user table does not exist

1
Payo (talkcontribs)

I am on a new install of the latest version of Mediawiki 1.20.5.

Having installed the TwitterLogin extension and run /var/www/mediawiki/maintenance/ update.php the main page now shows the following error message:

A database error has occurred. Did you forget to run maintenance/update.php after upgrading?
See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT tl_twitter_id FROM `pqtwitter_user` WHERE tl_user_id = '3' 
Function: SpecialTwitterLogin::_isCreatedFromTwitter
Error: 1146 Table 'peqi.pqtwitter_user' doesn't exist (localhost)

Commenting the extension in LocalSettings.php puts the main page back as it should me.

Looking back at the log generated by update.php, I see:

Creating twitter_user table ...done.
...twitter_user table does not exist, skipping modify field patch.
...twitter_user table does not exist, skipping modify field patch.
...site_stats is populated...done.
Purging caches...done.

However, doing mysql> SHOW tables; includes twitter_user at the end of the list. It looks ok:

mysql> describe twitter_user;
+---------------+------------------+------+-----+---------+-------+
| Field         | Type             | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+
| tl_user_id    | int(10) unsigned | NO   | PRI | NULL    |       |
| tl_twitter_id | varchar(255)     | NO   | UNI | NULL    |       |
+---------------+------------------+------+-----+---------+-------+

Not sure what to try next. Any suggestions?

Reply to "...twitter_user table does not exist"