CiviCRM Community Forums (archive)

I had to move my data from one database to another following the need for a clean install of Joomla.  I followed these instructions
http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location

expect that rather than sqldump I added the tables to the new database in phpmyadmin before installing civicrm.  I then installed the exact same version I had and did the fix database.  All went well and all the data is there except that when I try to access a contact record, I get a table does not exist error.

I am not a civicrm or mysql expert and do not have a firm grasp on how all the foreign key constraints work or what I did wrong on this data migration and would greatly appreciated any help in making my data accessible again.

When I try to enable debugging within civi  I get the same table does not exist error.  When I enable Joomla debugging, I get this:


CiviCRM|a:10:{s:4:\"ufID\";s:2:\"42\";s:6:\"userID\";s:1:\"1\";s:8:\"ufUniqID\";s:0:\"\";s:16:\"CRM_Utils_Recent\";a:2:{i:0;a:11:{s:5:\"title\";s:13:\"Matthew Brown\";s:3:\"url\";s:88:\"/administrator/?option=com_civicrm&task=civicrm/contact/view&reset=1&cid=356\";s:2:\"id\";s:3:\"356\";s:4:\"type\";s:10:\"Individual\";s:10:\"contact_id\";s:3:\"356\";s:11:\"contactName\";s:13:\"Matthew Brown\";s:7:\"subtype\";s:9:\"
Student
\";s:9:\"isDeleted\";b:0;s:9:\"image_url\";N;s:8:\"edit_url\";s:105:\"/administrator/?option=com_civicrm&task=civicrm/contact/add&reset=1&action=update&cid=356\";s:10:\"delete_url\";s:108:\"/administrator/?option=com_civicrm&task=civicrm/contact/view/delete&reset=1&delete=1&cid=356\";}i:1;a:11:{s:5:\"title\";s:10:\"Super User\";s:3:\"url\";s:86:\"/administrator/?option=com_civicrm&task=civicrm/contact/view&reset=1&cid=1\";s:2:\"id\";s:1:\"1\";s:4:\"type\";s:10:\"Individual\";s:10:\"contact_id\";s:1:\"1\";s:11:\"contactName\";s:10:\"Super User\";s:7:\"subtype\";N;s:9:\"isDeleted\";b:0;s:9:\"image_url\";N;s:8:\"edit_url\";s:103:\"/administrator/?option=com_civicrm&task=civicrm/contact/add&reset=1&action=update&cid=1\";s:10:\"delete_url\";N;}}s:20:\"defaultWysiwygEditor\";s:1:\"2\";s:12:\"qfPrivateKey\";s:64:\"f9dc40d2ab8a9fa3a537ed46ed6ea81363b8b7d821fa3cc3b1bc78649f453105\";s:11:\"qfSessionID\";s:32:\"6e952f450b56e0567e438bffc92f2503\";s:29:\"CRM_Contact_Page_View_Summary\";a:5:{s:3:\"cid\";s:3:\"356\";s:7:\"context\";s:6:\"search\";s:6:\"action\";i:16;s:11:\"contactType\";s:10:\"Individual\";s:14:\"contactSubtype\";s:9:\"
Student
\";}s:7:\"view.id\";s:3:\"356\";s:11:\"userContext\";a:1:{i:0;s:88:\"/administrator/?option=com_civicrm&task=civicrm/contact/view&reset=1&cid=356\";}}' , `time` = '1348589003'