CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • 183 tables in my Civi database -- is this normal?
Pages: [1]

Author Topic: 183 tables in my Civi database -- is this normal?  (Read 881 times)

jimmyjam

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
183 tables in my Civi database -- is this normal?
October 05, 2010, 08:25:41 pm
Hi,

I have separate databases for Drupal and CiviCRM. My CiviCRM database has 183 tables, many of which have the same names as Drupal tables.

See below for a link to my Civi database schema. Does it look normal to you? If I screwed something up, is there a way to repair it?

http://dl.dropbox.com/u/2554871/nchs_civicrm_schema.sql

Thanks,
James

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: 183 tables in my Civi database -- is this normal?
October 05, 2010, 11:28:35 pm
It looks like you have the Drupal tables and the CiviCRM tables in one database. Is this a production site or are you testing?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

jimmyjam

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
Re: 183 tables in my Civi database -- is this normal?
October 06, 2010, 10:06:21 am
Unfortunately, this is a production site. Is there a safe way to strip out the tables that shouldn't be there? Is there any harm in leaving the extra Drupal tables in my Civi database?

I am also getting a bunch of errors in my Drupal log, and am not sure if it's related to the extra Drupal tables. The error messages refer to modules I installed when attempting to integrate CiviEvent with the Drupal calendar.

Code: [Select]
Table 'nchs_civicrm.backup_migrate_schedules' doesn't exist query: UPDATE backup_migrate_schedules SET last_run = 1286156640 WHERE schedule_id = '7348d141b666c5d92d7360b326f9e104' in /home/nchs/public_html/sites/all/modules/backup_migrate/includes/schedules.inc on line 364.

Table 'nchs_civicrm.feedapi_stat' doesn't exist query: DELETE FROM feedapi_stat WHERE timestamp < 1283737439 in /home/nchs/public_html/sites/all/modules/feedapi/feedapi.module on line 689.

Table 'nchs_civicrm.search_index' doesn't exist query: SELECT SUM(score) FROM search_index WHERE word = '402am' in /home/nchs/public_html/modules/search/search.module on line 285.

Table 'nchs_civicrm.search_total' doesn't exist query: UPDATE search_total SET count = 0.301029995664 WHERE word = '402am' in /home/nchs/public_html/modules/search/search.module on line 288.

Table 'nchs_civicrm.search_total' doesn'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/nchs/public_html/modules/search/search.module on line 296.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: 183 tables in my Civi database -- is this normal?
October 06, 2010, 10:20:59 am
I am not sure what happened, and I do not think there is a safe way from where you are now. This would possibly only make it worse. In principle there is no harm in CiviCRM and Drupal being in the same database, but are you sure which Drupal tables your site is now using? Did you always have this mixup of tables or is it after an action you did? If the latter, you could perhaps restore a backup and try again?
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

jimmyjam

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
Re: 183 tables in my Civi database -- is this normal?
October 06, 2010, 11:42:16 am
Thanks for your help, Erik. I appreciate it.

James
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • 183 tables in my Civi database -- is this normal?

This forum was archived on 2017-11-26.