Author Topic: Multiple CiviCRM PHP table errors (Read 1964 times)

f4f · March 24, 2010, 05:29:37 am

We are seeing many PHP errors in the CiviCRM/Drupal logs, they seem to stop CRON from running correctly, so mailing aren't being sent out.

This is one of the errors, relating to missing tables (the rest at the end of this post)

Code: [Select]

Table &#039;civicrm.search_total&#039; doesn&#039;t exist query: SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL in /home/user/domain.org/cms/modules/search/search.module on line 296.

Is it a simple case of adding these missing tables to the database?

We are running CiviCRM 3.1.3 (upgraded from v2.14).

Any ideas?

Thanks!

The other common errors:

Code: [Select]

Table &#039;civicrm.accesslog&#039; doesn&#039;t exist query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&#039;Run cron&#039;, &#039;admin/reports/status/run-cron&#039;, &#039;http://domain.org/admin/reports/dblog&#039;, &#039;78.147.191.87&#039;, 1, &#039;phgri0j299pud2eoucpdo07q02&#039;, 23836, 1269364317) in /home/user/domain.org/cms/modules/statistics/statistics.module on line 64.

Code: [Select]

Table &#039;civicrm.cache&#039; doesn&#039;t exist query: DELETE FROM cache WHERE cid = &#039;variables&#039; in /home/user/domain.org/cms/includes/cache.inc on line 179.

Code: [Select]

Table &#039;civicrm.variable&#039; doesn&#039;t exist query: DELETE FROM variable WHERE name = &#039;cron_semaphore&#039; in /home/user/domain.org/cms/includes/bootstrap.inc on line 544.

Code: [Select]

Table &#039;civicrm.node&#039; doesn&#039;t exist query: SELECT n.* FROM node n LEFT JOIN xmlsitemap_node xn ON xn.nid = n.nid WHERE xn.nid IS NULL AND n.status = 1 LIMIT 0, 100 in /home/user/domain.org/cms/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 71.

Code: [Select]

Table &#039;civicrm.url_alias&#039; doesn&#039;t exist query: SELECT dst FROM url_alias WHERE src = &#039;admin/content/backup_migrate/destination/list/deletefile/6200d95b9eaa87c58fd4b85a66f852eb/user-CIVICRM-2010-03-23T10-11-46.mysql.gz&#039; AND language IN(&#039;en&#039;, &#039;&#039;) ORDER BY language DESC, pid DESC in /home/user/domain.org/cms/includes/path.inc on line 69.

emilyf · March 24, 2010, 08:46:01 am

all of the tables in those errors are drupal-specific (not civicrm). yet from the looks of it, the database suggests it's only for civicrm (the db is called 'civicrm'). is your drupal install in another database? check your civicrm.settings.php file and make sure your drupal db is the correct one.

f4f · March 24, 2010, 09:43:07 am

Thanks for the quick reply!

Civicrm and Drupal have separate databases on the same hostname.

CiviCRM uses a db called: civicrm
Drupak uses a db called: drupal

I checked the civicrm.settings.php file, it seems to point to the correct location:
CIVICRM_UF_DSN = drupal
CIVICRM_DSN = civicrm

The settings.php file has no reference to the civicrm database either.

You think this is a Drupal error?

emilyf · March 24, 2010, 03:02:02 pm

somewhere a setting is wrong because it's trying to access tables like 'civicrm.node' which is a drupal table.

this will either be in the civicrm.settings.php file, the drupal settings.php file (are you trying to cnnect to drupal views and you have lines in there as well?). clear your caches, empty out templates_c, and verify your directories and resource urls in civi. but really it should be in one of those settings files somewhere that it's entered wrong.

f4f · March 24, 2010, 03:11:04 pm

Thanks for the pointers Emily.

I'll take a look at those and see if it eliminates some of the errors... will update here shortly.

ehowland · March 27, 2010, 09:11:47 pm

I think this is a backup_migrate module error, since I am seeing something just like that in the drupal log files when I use backup_migrate. Are you, in fact, using backup_migrate? If so see node http://drupal.org/node/679632

CiviCRM Community Forums (archive)

News:

Author Topic: Multiple CiviCRM PHP table errors (Read 1964 times)

f4f

Multiple CiviCRM PHP table errors

emilyf

Re: Multiple CiviCRM PHP table errors

f4f

Re: Multiple CiviCRM PHP table errors

emilyf

Re: Multiple CiviCRM PHP table errors

f4f

Re: Multiple CiviCRM PHP table errors

ehowland

Re: Multiple CiviCRM PHP table errors