CiviCRM Community Forums (archive)

Hi,
    I'm suddenly getting this error from today morning with my civicrm 2.1.4 on joomla 1.5 after a lot of development on our website. The rest of my joomla site works but not the CiviCRM part. It gives me the following error. Any way i can reconstruct all the tables which are missing or corrupted? This is really critical to my NPO's operations. It may not be an error from CiviCRM part but any ideas how I can resolve it or get going?

backTrace

/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 153
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 345
/home/xxxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 183
/home/xxxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php, singleton, 25
/home/xxxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 37
/home/xxxxx/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/home/xxxxx/public_html/libraries/joomla/application/component/helper.php, require_once, 162
/home/xxxxx/public_html/administrator/includes/application.php, renderComponent, 130
/home/xxxxx/public_html/administrator/index.php, dispatch, 67

Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1146 ** Table 'xxxxx_xxxxx.civicrm_domain' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1146 ** Table 'xxxxx_xxxxx.civicrm_domain' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1146 ** Table 'xxxxx_xxxxx.civicrm_domain' doesn't exist]"]
)


Thank you for the response. I really appreciate it. It seems that a restoration done on one of the database servers (after a hard disk crash) is indeed the culprit. They could restore from a previous point but we are experiencing few issues related to queries. Some of the functionality on the civievent is broken due to this. Even reinstalling the whole of crm is one of the options that is being considered. So for the events i'm looking of ways to back up the events and restore them back without punching them back again.

I would like to know if we can configure venues just like profiles or price sets so that we can select venues instead of retyping them for the same venue?

Thanks again.
Vivek.

Wonderful!

Similarly is there a way that we can import ical events from outside? In our company's case it will be for restoration of data but I guess it can also be used for other situations. For example, the event is currently unregistered event just on the calendar and later on it is decided that the event needs registration and so it is transferred to civievent as an ical file.

Thanks
Vivek

Thanks. will consider that.