CiviCRM Community Forums (archive)

Hello,

I'm attempting to upgrade a 2.2.9 installation to 3.3.3.  I've followed the upgrade docs CRMDOC33/Upgrade+Drupal+Sites+to+3.3 successfully until Step 8 "Run the upgrade script".

At this time I get the message:

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details

I click on the "Error Details" link but nothing happens. 

If I look in the log file found here: default/files/civicrm/templates_c/en_US/ConfigAndLog/CiviCRM.5893095e80281def716f059f0f743948.log

The log tells me, in part:
host$ grep nativecode= *log | sort -u

      AND (civicrm_event.start_date >= 20110126 OR civicrm_event.end_date >= 20110126) ORDER BY   civicrm_event.start_date ASC [nativecode=1054 ** Unknown column 'is_template' in 'where clause']
      AND (civicrm_event.start_date >= 20110126 OR civicrm_event.end_date >= 20110126) ORDER BY   civicrm_event.start_date ASC [nativecode=1054 ** Unknown column 'is_template' in 'where clause']"]
      AND (civicrm_event.start_date >= 20110127 OR civicrm_event.end_date >= 20110127) ORDER BY   civicrm_event.start_date ASC [nativecode=1054 ** Unknown column 'is_template' in 'where clause']
      AND (civicrm_event.start_date >= 20110127 OR civicrm_event.end_date >= 20110127) ORDER BY   civicrm_event.start_date ASC [nativecode=1054 ** Unknown column 'is_template' in 'where clause']"]
 ORDER BY c.id [nativecode=1146 ** Table 'civicrm_prod.civicrm_contact_type' doesn't exist]
 ORDER BY c.id [nativecode=1146 ** Table 'civicrm_prod.civicrm_contact_type' doesn't exist]"]
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]

So it looks like my schema (2.2.9) is outta sync with what I'm upgrading to (3.3.3).  Of course, one would think the upgrade script would be updating the schema for me.

Thanks for your help.

Thank you for the information.  I followed the steps precisely as described in your link.  Unfortunately, I continue to get the DB Error: no such field error when I attempt to run the upgrade URI

I've attached the view source error as a text file as I was having difficulty posting all that PHP/SQL dump.

What next? 

Very strange indeed.  I restored everything and tried again.  This time I turned mysql query logging on.  The browser (safari) returns:
 
Safari can’t open the page “http://www.mydomain.com/members/?q=civicrm/upgrade&reset=1” because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again.

I don't see any ALTER statements in the mysql general query log (attached).  Is it possible to run the upgrade scripts from a command line interface instead of the upgrade URI?  I'm very comfortable in MySQL and Unix CLI.

Thanks for your help so far.

Sorry for the delay...

I did find this in my apache error log:   [notice] child pid 1341 exit signal Illegal instruction (4)
I've been running 2.2.9 for over a year and half on this config with no issues.  I do meet the minimum PHP/MySQL/Drupal6 version requirements.

I'm testing in a VirtualBox VM that was created from backups of the actual server.  So this instance is the same as my production instance, with the exception of a different IP address.  I've testing the operation of CiviCRM in this VM quite extensively and it behaves normally, before I attempt the upgrade.

Since it's looking like a PHP error, I'm going to focus on that.  Will update this thread with my findings.  Thanks for your help and ideas so far!

I had the same problem going from 2.2.9 to 3.4.3
rolled back to 2.2.9 and upgraded to 3.0.4 - all worked purr fectly

then upgraded from 3.0.4 to 3.4.3  --> no errors, all seems good

Just as further info for anyone that has to do this.

I had to upgrade from 2.2.9 > 3.0.4 > 3.4.8 > 4.1.6


I tried 2.2.9 to 3.1, 3.2, 3.4, 4.1, 4.0 and all failed, so definitely go 3.0.4 as mentioned previously on this page.

I also tried to go from 3.0.4 to 4.1.6 and that also did not work.