When I enable the module in a 7.14 core with a sqlsrv database (sql server 2005) i get the following error, and the module appears to be installed, but there aren't new sections in user page/settings page...
- Warning: htmlspecialchars(): Invalid multibyte sequence in argument in check_plain() (line 1572 of C:\docs\includes\bootstrap.inc).
- PDOException: in tokenauth_enable() (line 53 of C:\docs\sites\all\modules\tokenauth\tokenauth.install).
At that line I found:
...
// Clean up orphaned tokens from users removed while module disabled
db_query("DELETE tt.* FROM {tokenauth_tokens} tt WHERE NOT EXISTS (SELECT * FROM {users} u WHERE u.uid=tt.uid)");
...
Comments
Comment #1
gregglesThere should be a more detailed message than just PDOException. If you modify that query to remove the {} and try to run it manually in sql query analyzer do you get an error?
It seems like a pretty complex query. I wonder if it could be constructed more like to gain more cross-database compliance.
DELETE FROM {tokenauth_tokens} tt WHERE uid NOT IN (SELECT uid FROM {users} u) subtable_users;
Also, tagging in the hopes it gets more eyes on it.
Comment #2
liam morlandTagging