Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-11450

Can't access Civvicrm: DB Error: no such table

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Incomplete
    • Affects Version/s: 4.2.2
    • Fix Version/s: None
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      I installed and enabled a drupal module autologout using drush and a few minutes after that my system stopped working with this error message DB Error: no such table.

      • The module has been disabled and removed but not a solution to the problem
      • I can't even login to the drupal site anymore, once i go the login, enter my login details and submit i immediately get the error message DB Error: no such table.
      • my civi log file has the error message as shown below:

      [info] $Fatal Error Details = Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -18
      [message] => DB Error: no such table
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , page_type ) VALUES ( 1 , 'civicrm/upgrade' , 'Upgrade Civi$
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , page_type ) VALUES ( 1 , 'civicrm/upgrade' , 'Upgrade CiviC$
      [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_menu (domain_id , path , title , access_callback , $
      )

      [info] $backTrace = #0 /var/www/widerangle/sites/all/modules/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
      #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
      #2 /var/www/widerangle/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #3 /var/www/widerangle/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "INSERT INTO civicrm_menu (domain_id , path , title , access_call$
      #4 /var/www/widerangle/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access...")
      #5 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access...", "DB$
      #6 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'civicrm.log_civicrm_menu' doesn't exist")
      #7 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
      #8 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access...")
      #9 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access...")
      #10 /var/www/widerangle/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access...")
      #11 /var/www/widerangle/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
      #12 /var/www/widerangle/sites/all/modules/civicrm/CRM/Core/Menu.php(268): CRM_Core_DAO->save()
      #13 /var/www/widerangle/sites/all/modules/civicrm/CRM/Core/Invoke.php(381): CRM_Core_Menu::store()
      #14 /var/www/widerangle/sites/all/modules/civicrm/drupal/civicrm.module(1233): CRM_Core_Invoke::rebuildMenuAndCaches(TRUE)
      #15 [internal function](): civicrm_modules_enabled((Array:1))
      #16 /var/www/widerangle/includes/module.inc(819): call_user_func_array("civicrm_modules_enabled", (Array:1))
      #17 /var/www/widerangle/includes/module.inc(470): module_invoke_all("modules_enabled", (Array:1))
      #18 /usr/share/drush/commands/core/drupal/environment_7.inc(87): module_enable((Array:1), FALSE)
      #19 /usr/share/drush/commands/pm/pm.drush.inc(687): drush_module_enable((Array:1))
      #20 [internal function](): drush_pm_enable("autologout")
      #21 /usr/share/drush/includes/command.inc(120): call_user_func_array("drush_pm_enable", (Array:1))
      #22 /usr/share/drush/includes/command.inc(58): drush_invoke_args("pm-enable", (Array:1))
      #23 [internal function](): drush_invoke("pm-enable", "autologout")
      #24 /usr/share/drush/includes/command.inc(721): call_user_func_array("drush_invoke", (Array:2))
      #25 [internal function](): drush_command("autologout")
      #26 /usr/share/drush/includes/command.inc(204): call_user_func_array("drush_command", (Array:1))
      #27 /usr/share/drush/drush.php(101): drush_dispatch((Array:23))
      #28 /usr/share/drush/drush.php(41): drush_main()
      #29

      {main}
      • ANY HELP on how to resolve this issue?
        thanks

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              kennedy.ambang Kennedy Ambang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: