I upgraded to 6.x-1.5 today and after the upgrade the RSS feeds used with the tokens started no longer working.

Navigating to my account / token page also showed no token.

I tried disabling the module, and re-enabling it and see this error on re-enabling it:

user warning: Unknown column 'users.uid' in 'where clause' query: DELETE FROM teamipxtokenauth_tokens WHERE NOT EXISTS (SELECT * FROM teamipxusers WHERE users.uid=tokenauth_tokens.uid) in /home/teamipx/public_html/sites/all/modules/tokenauth/tokenauth.install on line 56.

Have also tried uninstalling / reinstalling the module, no change. There is still a button to reset the token on my user, but doing it still shows a page with no token on it.

Any help would be appreciated.

CommentFileSizeAuthor
#1 tokenauth-922294-1.patch854 bytesgapple

Comments

gapple’s picture

Title: Unable to see tokens after upgrade » 'Unkown column' error when module enabled
Issue tags: +database
StatusFileSize
new854 bytes

Not seeing tokens is probably related to #900802: I can't find the token

It looks like the second issue of the unknown column error is due to the query not using table aliases and failing when the database uses a table prefix. Attached is a quick patch that should fix that.

gapple’s picture

Status: Active » Needs review

Forgot status change

Grayside’s picture

Status: Needs review » Fixed

@gapple Thank you! Unfortunately that seems to have a syntax error related to http://bugs.mysql.com/bug.php?id=12811

Applied with minor tweaks to account for that.

http://drupal.org/cvs?commit=428218

Status: Fixed » Closed (fixed)
Issue tags: -database

Automatically closed -- issue fixed for 2 weeks with no activity.