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) »
  • NEW Upgrade Errors - Advice Needed
Pages: [1]

Author Topic: NEW Upgrade Errors - Advice Needed  (Read 704 times)

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
NEW Upgrade Errors - Advice Needed
April 15, 2012, 08:53:31 am
I am now getting this reponse from CiviCRM 4.1.1 upgrade on Drupal 6.25:

Initialization Error

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => simpleHandler
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *,  config_backend, locales, locale_custom_strings 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'locale_custom_strings' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT *,  config_backend, locales, locale_custom_strings 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'locale_custom_strings' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT *,  config_backend, locales, locale_custom_strings 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'locale_custom_strings' in 'field list']"]
)
backTrace

/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/CRM/Core/BAO/ConfigSetting.php, find, 203
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 406
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 209
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module, singleton, 272
/var/www/vhosts/domain.com/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module, civicrm_initialize, 329
, civicrm_invoke,
/var/www/vhosts/domain.com/httpdocs/includes/menu.inc, call_user_func_array, 350
/var/www/vhosts/domain.com/httpdocs/index.php, menu_execute_active_handler, 17

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Re: NEW Upgrade Errors - Advice Needed
April 16, 2012, 03:26:04 am
Based on a similar problem/post from a 3.x upgrade to which Lobo suggested a column add, I tried adding a column "locale_custom_strings"after "locales" to "civicrm_domain", to which I received "Fatal DB error, exiting, seems like your schema does not have civicrm_setting table"

After dropping the column, the error message went back to the original "initialization error".

Is this the database upgrade issue I imagine it to be, or something else entirely?
« Last Edit: April 16, 2012, 04:03:24 am by jobewan »

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Re: NEW Upgrade Errors - Advice Needed
April 16, 2012, 06:10:48 am
The issue seems to be with the upgrade script itself and its interaction with php.ini (the one in the /etc server directory).  ALL of it seems to be a result of interacting with a Plesk-based cloud server vs. a Cpanel-based shared website.  If that's true, then this is going to become a prevalent issue, given the pressure to 'go cloud' being exerted in the marketplace.  Again, assuming that the above assumption is correct.

The only immediate solution seems to be to construct a working upgraded site elsewhere on a Cpanl-based website and manually push that install into the cloud environment.

Does anyone have a proper pre/during/post installation script for Civi that actually runs -all- the necessary bases?  I saw something go by in my various searches, but have no idea of the relative 'goodness' of any such effort at this time.
« Last Edit: April 16, 2012, 07:04:59 am by jobewan »

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Re: NEW Upgrade Errors - Advice Needed
April 17, 2012, 08:37:31 am
Well, the latest is that the CiviCRM module is causing a segmentation error.  It appears that some or all relief has been had by following the information here:

http://wiki.civicrm.org/confluence/display/CRMDOC31/Moving+an+Existing+Installation+to+a+New+Server+or+Location


Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • NEW Upgrade Errors - Advice Needed

This forum was archived on 2017-11-26.