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) »
  • DRUPAL 6/CivicSpace 2 upgrade gone wrong
Pages: [1]

Author Topic: DRUPAL 6/CivicSpace 2 upgrade gone wrong  (Read 1196 times)

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
DRUPAL 6/CivicSpace 2 upgrade gone wrong
March 02, 2009, 09:10:44 am
Hi all - I planned (I thought) the upgrade of a client's site to the "next level".  We have been waiting on our ISP to update infrastructure to include MySQL 5/PHP 5 and a couple of weeks ago it finally happened.......we were running DRUPAL 5.x and CiviCRM 1.9.  I read the docs for CiviCRM 2.0 and saw nothing alarming - and we decided to first upgrade DRUPAL then CiviCRM.   A BIG mistake!!!  :'(

I got DRUPAL ugraded and decided not to do the CiviCRM update because the site had been off line all day yesterday (March 1st).  Well, when I reloaded the backup from the DRUPAL 5.x site, I got the biggest surprise that CiviCRM 1.9 ISN'T compatible with DRUPAL 6...........arrrgh!  Ok - I thought, I will just do the upgrade to CiviCRM 2.0.........I thought - but then after doing the work, only to discover that CiviCRM 2.0 is also not compatible with DRUPAL 6.  So I downloaded and installed CiviCRM 2.1.   And that is where I am now -

Upon trying to trigger the update cycle at the url <my site's URL/sites/all/modules/civicrm/install/update.php?reset=1>  I get the following error:

Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'civicrm_domain.version' in 'where clause', 1054

And in my 30th hour of this update, I couldn't think anymore and decided to sleep  for a couple of hours and tackle this again........Isn't the upgrade cycle suppose to correct these things and fix the database?   Can anyone direct me on how to get this upgrade done, hopefully WITHOUT taking the site back to DRUPAL 5 and wiping out 30 hours of work and spending another day on this project leaving a lot of users locked out of the site?
« Last Edit: March 02, 2009, 09:13:24 am by Shadow »

Matt2000

  • I post frequently
  • ***
  • Posts: 288
  • Karma: 27
    • http://www.ninjitsuweb.com
Re: DRUPAL 6/CivicSpace 2 upgrade gone wrong
March 02, 2009, 09:52:29 am
Shadow,

Copy your CiviCRM database into a new, Drupal 5 install. Upgrade to 2.0 there, then copy that database back to your real Drupal installation and do the 2.1 upgrade.

If you already maintain Drupal & CiviCRM in separate databases, this will be easy. If not, you should, so this will be a good opportunity to make the switch.
Drupal/CiviCRM micro-blogging http://twitter.com/matt2000

Ninjitsu Web Development http://www.NinjitsuWeb.com/

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: DRUPAL 6/CivicSpace 2 upgrade gone wrong
March 02, 2009, 10:43:49 am
Hmmm - let me vocalize your idea for a minute. Please bear with me - Only got a couple of hours sleep fooling round with this upgrade....... What you are suggesting is that I create a DRUPAL 5 installations ON A DIFFERENT SERVER and upload the backed up CiviCRM data on that server, upgrade it to 2.0 and then empty the original database on the upgraded DRUPAL 6.0 site and upload the backed up data from the DRUPAL 5 site that I created on the other server and then trigger the 2.1 upgrade on the original server.  Is that correct?  While I don't have a server available, perhaps I can create such a setup in a seperate folder on the site.  Do you think that will work? :-\

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: DRUPAL 6/CivicSpace 2 upgrade gone wrong
March 03, 2009, 10:49:04 am
Arrrgh!!!!!  Now I am having trouble triggering the upgrade.  I create a DRUPAl 5 site in a folder on the main site and successfully installed DRUPAL.   The name of the folder is test.  Then I created an empty MySQL database and imported the 1.9 data and recreated my CiviCRM 1.9 database.  Then I added the files for CiviCRM 2.0 in the sites/all/modules folder.

Following the upgrade instructions for 2.0 which tell me that I can trigger the upgrade by going to

http://<your_drupal_home>/index.php?q=civicrm/upgrade&reset=1

which I read as <my site root/test/index.php?q=civicrm/upgrade&reset=1 and I get a page not found error. 

I also tried <my site root/test/sites/all/modules/index.php?q=civicrm/upgrade&reset=1

<my site root/test/sites/all/modules/civicrm/drupal/install/index.php?q=civicrm/upgrade&reset=1 which also didn't work.  How can I trigger this upgrade script?

I should state that i did reach the install page but was reluctant to trigger it because I did not want the data wiped out (I thought that it (the install script) might delete the data already in the database.  I only want the data upgraded so I can go on to trigger the 2.1 upgrade on my production site, which is already running DRUPAL 6.



« Last Edit: March 03, 2009, 10:52:56 am by Shadow »

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DRUPAL 6/CivicSpace 2 upgrade gone wrong

This forum was archived on 2017-11-26.