user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 339.

I get this warning when I click on the bulk processing tab.

Comments

AntiNSA’s picture

AntiNSA commented
Priority: Normal » Critical

Unable to bulk process :(

febbraro’s picture

febbraro commented

You need to run the update hooks. It is a new table that will get created for you, but you need to execute either update.php or drush updatedb

AntiNSA’s picture

AntiNSA commented

I have ran update.php several times..

febbraro’s picture

febbraro commented

Were you running a dev version of this module b/w the 3.4 and 3.5 release? If so, you may have missed the update for it.

If you missed it, a possible way to fix it (be sure to make backups and test it first) is in the system table set the schema_version for the calais module to 6300 (it will likely be 6301) and then run update.php again, that will rerun calais_update_6301.

AntiNSA’s picture

AntiNSA commented

I tried this with 6302 andI still get these errors:

user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 345.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = '' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'cloudformation_feed_capture_base' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'cloudformation_item' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_class_group' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_group_task' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_oc_feed_item' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_open_courseware_captur' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_strategy_codex_links' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evocampus_teacher_strategy_book' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evoed_news_feed_capture' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evoed_news_feed_item' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evoed_news_sitewide_base' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evofusion_sitewide_base' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evogroup_announcement' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evogroup_event' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line 302.
user warning: Table 'cyberfan.calais_node_queue' doesn't exist query: SELECT COUNT(*) FROM calais_node_queue WHERE type = 'evogroup_member_blog' in /home/cyberfan/htdocs/sites/all/modules/opencalais/calais.admin.inc on line

any ideas?

febbraro’s picture

febbraro commented

do you have calais_update_6302 in calais.install? Are you sure it ran? That update hook installs the table it says you are missing, so you need to get that table created.

AntiNSA’s picture

AntiNSA commented

user warning: Table 'calais_term_uri' already exists query: CREATE TABLE calais_term_uri ( `uid` INT unsigned NOT NULL auto_increment, `tid` INT unsigned NOT NULL, `service` VARCHAR(255) NOT NULL, `uri` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (uid), INDEX service (service) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/cyberfan/htdocs/includes/database.inc on line 555.

is the error I get when trying to update to 6302

febbraro’s picture

febbraro commented

Ahh, the joys of dev releases.

Can you drop the calais_term_uri UI table then run 6302 again?

elusivemind’s picture

elusivemind commented
Issue summary: View changes
Status: Active » Fixed

I cannot reproduce this issue but it may have long since been addressed. I am going to close it as fixed. Be sure you are not using dev versions on production systems as you may need to uninstall and reinstall it during the course of development.

Status: Fixed » Closed (fixed)

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