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) »
  • Upgrading CiviCRM 2.2 to 3.4.8
Pages: [1]

Author Topic: Upgrading CiviCRM 2.2 to 3.4.8  (Read 1361 times)

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Upgrading CiviCRM 2.2 to 3.4.8
June 18, 2013, 01:25:07 pm
Hi,

I am having trouble upgrading CiviCRM on Joomla 1.5.26 from 2.2 to 3.4.8.

I found a thread that gave similar errors to the errors I was receiving:

DB Error: no such field

Database Error Code: Unknown column 'civicrm_uf_match.domain_id' in 'where clause', 1054

from this link:

http://forum.civicrm.org/index.php/topic,9191.msg39707.html#msg39707

The question I had was what file is he referring to edit:which he (Deepak) says to do "(around line 183)". I didn't see anywhere where it referred to a file.
« Last Edit: June 18, 2013, 01:31:34 pm by rmckee »

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 19, 2013, 08:52:01 am
The lines were input into the file 'civicrm/CRM/Core/BAO/UFMatch.php'.

I still have an initialization error for this after inputting the lines into the file, and cannot reset the website. I have also tried logging out of the administrator portal and back in.

I have went through steps 1-3 from the upgrade wiki upgrade website Upgrade+Joomla+Sites+to+3.4, and have successfully installed 3.4.8. However, step 4 is not working when trying to refresh the website, 'administrator/index.php?option=com_civicrm&task=civicrm/upgrade&reset=1'.

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 19, 2013, 08:52:32 am
Trying to access the civicrm gives me an initialization error:

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

/home/domain/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2424
/home/domain/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
/home/domain/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 209
/home/domain/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 397
/home/domain/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 202
/home/domain/public_html/administrator/components/com_civicrm/admin.civicrm.php, singleton, 48
/home/domain/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 59
/home/domain/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/domain/public_html/libraries/joomla/application/component/helper.php, require_once, 162
/home/domain/public_html/administrator/includes/application.php, renderComponent, 136
/home/domain/public_html/administrator/index.php, dispatch, 67

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 24, 2013, 05:54:10 am
I am still having issues with this. Is there anyone that could give me a hand on this error?

kreynen

  • I post occasionally
  • **
  • Posts: 105
  • Karma: 8
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 25, 2013, 05:32:58 am
It looks like some of the database schema changes in the upgrade weren't applied correctly or at all.  Did you get errors during your upgrade?

If possible, I would revert to a backup and run the upgrade again.  If not, I'd create a new, clean install and compare the table structure of the problematic tables.  The error is pretty straight forward.  The query doesn't work because the locale_custom_strings does not exist.  Why it doesn't exist is what you need to figure out or work around.

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 25, 2013, 06:27:18 am
It actually said that the upgrade was successful, which made me think that it should have worked to refresh.

I appreciate the input. I will try the install fresh and see what I can come up with when comparing tables structure.

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Upgrading CiviCRM 2.2 to 3.4.8
June 27, 2013, 07:09:25 am
I don't believe you can make a jump directly from 2.2 to 3.4. The ability to upgrade through multiple major versions wasn't implemented until sometime in the 3.x series.

I recommend rolling back to v2.2, then installing v3.0 and upgrading to that release. If it goes smoothly, make a backup of the db, then try upgrading from there to v3.4.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

rmckee

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: Upgrading 2.2 to 3.4.8
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.5.31-cll
  • PHP version: 5.4.16
Re: Upgrading CiviCRM 2.2 to 3.4.8 [FIXED]
June 28, 2013, 06:10:47 am
Thank you. This was the fix. The version was at 2.2.3, I upgraded direct to 3.4.8. I downgraded back to the version of 2.2.9 and the site was functioning again!

This was broken since we took over hosting for this website, so I appreciate it. This is my first experience with civicrm.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading CiviCRM 2.2 to 3.4.8

This forum was archived on 2017-11-26.