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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7
Pages: [1]

Author Topic: No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7  (Read 994 times)

philip

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Joomla
  • MySQL version: 5
  • PHP version: 5
No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7
November 29, 2012, 04:48:02 am
I am trying to upgrade Joomla 1.7 CiviCRM 4.0.8 to Civicrm 4.2.6 and I get the following error dump on database upgrade:

DB Error: no such table

Any insight or help will be appreciated.
Apache version    2.2.23
PHP version    5.3.18
MySQL version    5.1.65-cll
Architecture    x86_64
Operating system    linux

philip

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Joomla
  • MySQL version: 5
  • PHP version: 5
Re: No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7
November 29, 2012, 04:49:19 am
Quote
backTrace

#0 administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "SELECT * \n FROM

civicrm_setting \n \n WHERE (  civicrm_setting.group_name  =...")
#4 administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "SELECT * \n FROM civicrm_setting \n \n WHERE (

 civicrm_setting.group_name  =...")
#5 administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "SELECT * \n FROM civicrm_setting \n \n

WHERE (  civicrm_setting.group_name  =...", "DB_Error", TRUE)
#6 administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table

'shaphil_site.civicrm_setting' doesn't exist")
#7 administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT * \n FROM civicrm_setting \n \n WHERE ( 

civicrm_setting.group_name  =...")
#9 administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT * \n FROM civicrm_setting \n \n WHERE ( 

civicrm_setting.group_name  =...")
#10 administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(441): DB_DataObject->_query("SELECT * \n FROM civicrm_setting \n \n WHERE ( 

civicrm_setting.group_name  =...")
#11 administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php(171): DB_DataObject->find()
#12 administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php(2067): CRM_Core_BAO_Setting::getItem("Multi Site Preferences",

"uniq_email_per_site")
#13 administrator/components/com_civicrm/civicrm/CRM/Core/BAO/UFMatch.php(245): CRM_Contact_BAO_Contact::matchContactOnEmail("",

"Individual")
#14 administrator/components/com_civicrm/civicrm/CRM/Core/BAO/UFMatch.php(122): CRM_Core_BAO_UFMatch::synchronizeUFMatch(Object(JUser), "44",

"", "Joomla", NULL, "Individual", TRUE)
#15 administrator/components/com_civicrm/admin.civicrm.php(73): CRM_Core_BAO_UFMatch::synchronize(Object(JUser), FALSE, "Joomla", "Individual", TRUE)
#16 administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#17 libraries/joomla/application/component/helper.php(156): require_once("administrator/components/com_civicrm/admin.civicrm.php")
#18 administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#19 administrator/index.php(47): JAdministrator->dispatch()
#20 {main}

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7
November 30, 2012, 03:15:17 am
Can you try to upgrade to 4.1 first?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • No such table "civicrm_setting" error on upgrade 4.0.8 to 4.2.6 Joomla 1.7

This forum was archived on 2017-11-26.