Author Topic: MySQL Error (Read 1526 times)

suzuki16 · September 13, 2007, 05:44:42 pm

My CiviCRM 1.8 installation on my Drupal 5.1 system has been working fine for about two weeks. All of a sudden today I get this error message when trying to access the civiCRM module. My database is now corrupt. Any help would be greatly appreciated.

Code: [Select]

CiviCRM Home

    * user warning: MySQL server has gone away query: SELECT * FROM system WHERE type = 'theme' in /usr/local/htdocs.playground/drupal/includes/database.mysql.inc on line 172.
    * user warning: MySQL server has gone away query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /usr/local/htdocs.playground/drupal/includes/database.mysql.inc on line 172.

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Database Error Code: Lost connection to MySQL server during query, 2013

    Return to CiviCRM menu.

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT count(*) FROM civicrm_meeting 
                  WHERE ( civicrm_meeting.target_entity_table = 'civicrm_contact'  AND target_entity_id = 102 OR source_contact_id = 102  )
                  AND status != 'Completed' [nativecode=2013 ** Lost connection to MySQL server during query]
    [type] => DB_Error
    [user_info] => SELECT count(*) FROM civicrm_meeting 
                  WHERE ( civicrm_meeting.target_entity_table = 'civicrm_contact'  AND target_entity_id = 102 OR source_contact_id = 102  )
                  AND status != 'Completed' [nativecode=2013 ** Lost connection to MySQL server during query]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count(*) FROM civicrm_meeting 
                  WHERE ( civicrm_meeting.target_entity_table = 'civicrm_contact'  AND target_entity_id = 102 OR source_contact_id = 102  )
                  AND status != 'Completed' [nativecode=2013 ** Lost connection to MySQL server during query]"]

[/code]

Donald Lobo · September 13, 2007, 09:58:41 pm

you might want to check the mysql website and documentation on how to recover from a corrupt database. I'm not sure if that is responsible for the "MySQL server has gone away query" message.

lobo

suzuki16 · September 14, 2007, 08:03:59 am

Thanks. I'm going to look into that. My buddy is taking a look and he said there is definetely at least one table that is causing a problem. From the error message to me it looks as though the error occurred while someone was trying to schedule a meeting.

CiviCRM Community Forums (archive)

News:

Author Topic: MySQL Error (Read 1526 times)

suzuki16

MySQL Error

Donald Lobo

Re: MySQL Error

suzuki16

Re: MySQL Error