Closed (fixed)
Project:
Token authentication
Version:
6.x-1.0-rc1
Component:
User interface
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
7 Jun 2008 at 21:52 UTC
Updated:
24 Aug 2008 at 11:43 UTC
Forgive me if I'm wrong regarding the title...but when I reset the token, I get the following error.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "lemming_tokenauth_tokens" does not exist in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 138.
* user warning: query: UPDATE lemming_tokenauth_tokens SET token = 'jYbLATqHTU' WHERE uid = 1 in /home/zotsf/lemming_html/modules/tokenauth/tokenauth.module on line 133.
Comments
Comment #1
zotsf commentedAgain, switching this to support request.
Comment #2
moshe weitzman commentedseems like you are missing a table. not sure how that happenned. uninstall and then install again.
Comment #3
zotsf commentedHmmm... still not working. Here are the steps I took:
disabled tokenauth
uninstalled tokenauth
removed tokenauth dir from modules
unpacked tar file
reloaded module listing
checked and enabled tokenauth
I have the same issue still.
Have I missed some steps here?
Here is the error that shows up when I check and enable reinstall of tokenauth:
* warning: Invalid argument supplied for foreach() in /home/zotsf/lemming_html/includes/common.inc on line 3164.
* warning: Invalid argument supplied for foreach() in /home/zotsf/lemming_html/includes/common.inc on line 3085.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "lemming_tokenauth_tokens" does not exist in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 138.
* user warning: query: INSERT INTO lemming_tokenauth_tokens (uid, token) SELECT u.uid, 'ijTQv4UgtN' FROM lemming_users u LEFT JOIN lemming_tokenauth_tokens tt ON u.uid=tt.uid WHERE u.uid > 0 AND tt.token IS NULL in /home/zotsf/lemming_html/modules/tokenauth/tokenauth.install on line 37.
Comment #4
moshe weitzman commentedDoes lemming_tokenauth_tokens exist in your postgres DB? This query uses a subquery which is pretty unusual. Might be a smoking gun.
Comment #5
zotsf commentedlemming_tokenauth_tokens does not exist. here is what is there...
public | lemming_access | table | zotsf
public | lemming_access_aid_seq | sequence | zotsf
public | lemming_actions | table | zotsf
public | lemming_actions_aid | table | zotsf
public | lemming_actions_aid_aid_seq | sequence | zotsf
public | lemming_authmap | table | zotsf
public | lemming_authmap_aid_seq | sequence | zotsf
public | lemming_batch | table | zotsf
public | lemming_batch_bid_seq | sequence | zotsf
public | lemming_blocks | table | zotsf
public | lemming_blocks_bid_seq | sequence | zotsf
public | lemming_blocks_roles | table | zotsf
public | lemming_boxes | table | zotsf
public | lemming_boxes_bid_seq | sequence | zotsf
public | lemming_cache | table | zotsf
public | lemming_cache_block | table | zotsf
public | lemming_cache_filter | table | zotsf
public | lemming_cache_form | table | zotsf
public | lemming_cache_menu | table | zotsf
public | lemming_cache_page | table | zotsf
public | lemming_cache_update | table | zotsf
public | lemming_comments | table | zotsf
public | lemming_comments_cid_seq | sequence | zotsf
public | lemming_files | table | zotsf
public | lemming_files_fid_seq | sequence | zotsf
public | lemming_filter_formats | table | zotsf
public | lemming_filter_formats_format_seq | sequence | zotsf
public | lemming_filters | table | zotsf
public | lemming_filters_fid_seq | sequence | zotsf
public | lemming_flood | table | zotsf
public | lemming_flood_fid_seq | sequence | zotsf
public | lemming_history | table | zotsf
public | lemming_ljxp | table | zotsf
public | lemming_ljxp_node | table | zotsf
public | lemming_menu_custom | table | zotsf
public | lemming_menu_links | table | zotsf
public | lemming_menu_links_mlid_seq | sequence | zotsf
public | lemming_menu_router | table | zotsf
public | lemming_node | table | zotsf
public | lemming_node_access | table | zotsf
public | lemming_node_comment_statistics | table | zotsf
public | lemming_node_counter | table | zotsf
public | lemming_node_nid_seq | sequence | zotsf
public | lemming_node_revisions | table | zotsf
public | lemming_node_revisions_vid_seq | sequence | zotsf
public | lemming_node_type | table | zotsf
public | lemming_permission | table | zotsf
public | lemming_permission_pid_seq | sequence | zotsf
public | lemming_role | table | zotsf
public | lemming_role_rid_seq | sequence | zotsf
public | lemming_sessions | table | zotsf
public | lemming_system | table | zotsf
public | lemming_term_data | table | zotsf
public | lemming_term_data_tid_seq | sequence | zotsf
public | lemming_term_hierarchy | table | zotsf
public | lemming_term_node | table | zotsf
public | lemming_term_relation | table | zotsf
public | lemming_term_relation_trid_seq | sequence | zotsf
public | lemming_term_synonym | table | zotsf
public | lemming_term_synonym_tsid_seq | sequence | zotsf
public | lemming_trigger_assignments | table | zotsf
public | lemming_upload | table | zotsf
public | lemming_url_alias | table | zotsf
public | lemming_url_alias_pid_seq | sequence | zotsf
public | lemming_users | table | zotsf
public | lemming_users_roles | table | zotsf
public | lemming_users_uid_seq | sequence | zotsf
public | lemming_variable | table | zotsf
public | lemming_vocabulary | table | zotsf
public | lemming_vocabulary_node_types | table | zotsf
public | lemming_vocabulary_vid_seq | sequence | zotsf
public | lemming_watchdog | table | zotsf
public | lemming_watchdog_wid_seq | sequence | zotsf
Comment #6
moshe weitzman commentedcould you please uninstall and install the module within drupal.
Comment #7
zotsf commentedThere is no GUI option to uninstall the module. I can disable it and remove the module (directories) it via the command line and I've already taken this step with no results.
What could I do at this point?
Comment #8
moshe weitzman commentedfixed a bug
Comment #9
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.