CiviCRM Community Forums (archive)

Hi I am trying to upgrade from 4.0.7 to 4.1 in preparation for upgrading to 4.2 and then to 4.4. Fun times.

I have been around and around trying to figure out what the hold up is, but I can't seem to solve the "missing civicrm_settings table" error. I assume the upgrader is supposed to create the table, as I haven't seen any instructions otherwise. Should I just backup and delete the whole database and let Civicrm start from scratch?

I've been banging my head against this for 3 days now, so any useful advice at this point would be MAGICAL.

Here is the code dump:

Initialization Error

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => simpleHandler
        )

   

Code: [Select]

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'ecosocie_crm.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'ecosocie_crm.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'ecosocie_crm.civicrm_setting' doesn't exist]"]
)
backTrace

/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428
/home/ecosocie/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1614
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 166
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 897
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php, executeQuery, 433
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/BAO/ConfigSetting.php, retrieveDirectoryAndURLPreferences, 334
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 406
/home/ecosocie/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 209
/home/ecosocie/public_html/sites/all/modules/civicrm/drupal/civicrm.module, singleton, 320
/home/ecosocie/public_html/sites/all/modules/civicrm/drupal/civicrm.module, civicrm_initialize, 386
, civicrm_invoke,
/home/ecosocie/public_html/includes/menu.inc, call_user_func_array, 517
/home/ecosocie/public_html/index.php, menu_execute_active_handler, 21[/quote]

Yeah, I gathered the need for incremental upgrades when I tried to go right from 3.4 to 4.4 - thank you forums! I have now made it to 4.0.8. From other forum posts it seems like the settings_table was a 4.1 thing so it makes sense I am having trouble with that step, especially if as you suggest I am having permissions problems with my user login vis-a-vis the database.

Sorry for the noobie follow up, but how do I tell what database user CiviCRM is using? I assume phpmyadmin is the place to change permissions for that user, right?

thanks for the tip! FIrst thing that has made sense so far!