I just installed casetracker and when i go to admin/settings/casetracker i get to following errors:



    * user warning: Table 'drupal.casetracker_case_states' doesn't exist query: SELECT csid, case_state_name, case_state_realm FROM casetracker_case_states in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
    * warning: Invalid argument supplied for foreach() in C:\www\webapps\drupal\sites\all\modules\casetracker\casetracker.module on line 482.
    * user warning: Table 'drupal.casetracker_case_states' doesn't exist query: SELECT csid, case_state_name, case_state_realm FROM casetracker_case_states in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
    * warning: Invalid argument supplied for foreach() in C:\www\webapps\drupal\sites\all\modules\casetracker\casetracker.module on line 482.
    * user warning: Table 'drupal.casetracker_case_states' doesn't exist query: SELECT csid, case_state_name, case_state_realm FROM casetracker_case_states in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
    * warning: Invalid argument supplied for foreach() in C:\www\webapps\drupal\sites\all\modules\casetracker\casetracker.module on line 482.

Not sure what i did wrong or what I need to do, but any help would be appreciated.

Comments

zero2one’s picture

zero2one commented

Are you sure that there is nothing wrong with you're database?
The error messages you posted here are indicating that there is a table (casetracker_case_states) missing...
user warning: Table 'drupal.casetracker_case_states' doesn't exist

STyL3’s picture

STyL3 commented

do you have to create the table manually for the module? if not, then i don't know why it wouldn't have been created.

zero2one’s picture

zero2one commented

Did a lot of test installs, the table is always created automaticly.

By examining you're error messages I can only conclude the table isn't there in your installation...

Can you check it (can you provide a list of all casetracker-tables that are there? They all start with casetracker

STyL3’s picture

STyL3 commented

i just looked...sorry for the delay. I don't have a single casetracker table in my db. very very odd. any easy fix to this?

zero2one’s picture

zero2one commented

Uninstall the casetracker module (the data can't be in the database...)
And reinstall it...

STyL3’s picture

STyL3 commented

I actually did this and nothing changed. I then removed the casetracker module and ran the update script and installed it again. still no luck. However, I have since reinstalled drupal all together and everything seems to be working properly. Not sure what the issue was or why it happened, but a reinstall did the trick.

zero2one’s picture

zero2one commented
Status: Active » Closed (fixed)

1 tip on reinstalling a module (and recreating the tables):

Drupal keeps track of what modules and themes are installed in the system table.
For themes it keeps track of what database scheme it has last installed/updated.

If you uninstall you're mode and remove the tables in the database, you can remove the line indicating the module you removed.
If you reinstall the module afterwards it will perform a full install inclusive the tables.

Warning: you should perform this on own risk ;-)