CiviCRM Community Forums (archive)

I am not sure how this happened or how to fix it.  I get the following message if I try to use anything with CiviCRM -- OR -- if I click on module or block in Drupal admin (or even if I logout).  I am using Drupal 6.10 (and I have changed my domain name to abcde).  Can anyone help me fix this problem short of re-installing?  TIA.


backTrace

/home/abcde/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/abcde/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 969
/home/abcde/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/home/abcde/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
/home/abcde/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php, find, 153
/home/abcde/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 345
/home/abcde/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 183
/home/abcde/public_html/sites/all/modules/civicrm/drupal/civicrm.module, singleton, 245
/home/abcde/public_html/sites/all/modules/civicrm/drupal/civicrm.module, civicrm_initialize, 289
, civicrm_invoke,
/home/abcde/public_html/includes/menu.inc, call_user_func_array, 348
/home/abcde/public_html/index.php, menu_execute_active_handler, 18

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

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './abcde_civicrm/civicrm_domain.frm']
    [type] => DB_Error
    [user_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './abcde_civicrm/civicrm_domain.frm']
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './abcde_civicrm/civicrm_domain.frm']"]
)
[/code]

When I got up this morning, everything was back to normal.  Yesterday, before I went to bed, all of the tables in the civiCRM database were reporting as "in use".  It had been working fine for 3 months before yesterday. 

So, it's working again, but any idea what caused this?  I want to make sure it doesn't happen again when it goes live.

Thanks again for all your help.  I have been impressed with the CiviCRM support.

That would be a first.  :-)  Now I need to get a proximity search of classes of members up and running.  (That's for another thread.)

That's basically what I'm looking for.  We need to allow the public to do a proximity search on accredited members (we have 2 classes of accredited members).  They will all be in the US (NJ, PA, DE and NY).  So, the public user needs to be able to enter a zipcode and the class of accredited member they are looking for along with miles for the proximity.  The results need to be a list of the person, city and distance from the zip entered.  They should then be able to click on the person's name to get contact info, personal bio, etc (essentially, the other info in the contact dataset).

I'm guessing that I will use a custom search to do this, but I have no idea how to customize it to allow the public to select the accreditation type and to customize the output.  Is there a tutorial of some sort to point me in the right direction?

Thanks.

Would it be possible to use Drupal's location module somehow?