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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • post implementation error
Pages: [1]

Author Topic: post implementation error  (Read 2861 times)

stephenrockwell

  • Guest
post implementation error
May 20, 2008, 08:40:21 am
After successful implementation for a number of months i all of a sudden received this error message.   any insights?  is a civicrm error or problem with hosting?

drupal 5.7/civicrm 2.0



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
            )

       
Code: [Select]
=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './mcscivicrm/civicrm_domain.frm']
    [type] => DB_Error
    [user_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './mcscivicrm/civicrm_domain.frm']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './mcscivicrm/civicrm_domain.frm']"]
)
« Last Edit: May 20, 2008, 08:46:39 am by stephenrockwell »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: post implementation error
May 20, 2008, 11:46:41 am

the error below indicates your mysql db is corrupted. you'll need to check the mysql docs and figure out what the recovery commands are / restore from a backup

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

stephenrockwell

  • Guest
Re: post implementation error
May 20, 2008, 12:21:45 pm
any idea how that happens?

i don't that there's been anything done to spur database corruption. 

civicrm was minimally active.

if i restore is this just going to happen again?


Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: post implementation error
May 21, 2008, 03:18:06 am
Quote from: stephenrockwell on May 20, 2008, 08:40:21 am
Code: [Select]
[nativecode=1033 ** Incorrect information in file: './mcscivicrm/civicrm_domain.frm']

To my eyes this suggest either a problem with the filesystem (e.g., after a hard reboot) or MySQL, not with CiviCRM (or any other database client).
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
CiviCRM fatal crash
July 27, 2008, 04:28:03 pm
I got the exact same error - I suspect this may relate to a CiviEvent I had posted, running to an event calendar in Drupal - there were no subsequent events. The event happened this morning - I have a hunch that's when things went haywire. I've disabled CiviCRM for now - any ideas how to get it out of freak out mode? Below is the entire message - very disturbing to have this take the whole site down...thanks!

Code: [Select]
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] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './alicebor_civicrm/civicrm_domain.frm']
    [type] => DB_Error
    [user_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './alicebor_civicrm/civicrm_domain.frm']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
[/code]
« Last Edit: July 27, 2008, 04:35:17 pm by bcobin »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: post implementation error
July 27, 2008, 05:02:00 pm

The easiest thing to do might to to recover the domain table from backup.

alternatively you can check the mysql docs and figure out the necessary commands to recover/restore a table. if you do so, please update this forum post with the relevant mysql links for other folks who run into this issue

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: post implementation error
July 28, 2008, 09:29:01 am
The hosting company needed to do a restore - looks like the db got hosed. PhpMyAdmin reported all tables "in use" on the CiviCRM db when I tried to look at it.

The restore looks OK and everything seems to be back to normal.

My suspicion is this may have something to do once a CiviEvent transpires with no other CiviEvent scheduled. Nasty.

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: post implementation error
July 28, 2008, 07:02:00 pm
I still strongly believe that this message means that it’s a MySQL error about its filesystem backend being broken – so it’s not something CiviCRM could fix (or should be able to cause in the first place). You might find this Google search shed some light on possible causes of this error.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • post implementation error

This forum was archived on 2017-11-26.