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) »
  • Upgrade dumps all Data
Pages: [1]

Author Topic: Upgrade dumps all Data  (Read 2466 times)

cma01

  • I’m new here
  • *
  • Posts: 26
  • Karma: 2
    • Legacy Marketing Services
Upgrade dumps all Data
June 08, 2007, 01:41:39 pm
I've been trying to upgrade CiviCRM on Joomla for the past two days and I'm about ready to call it quits.

The site is running Joomla 1.0.12, I had CiviCRM 1.6.8310 and I'm trying to upgrade to 1.7.9682.

The only way I've been able to install CiviCRM is by editing the XML file and doing an install from directory.

I was fighting with some permissions and ownerships, but I finally got it to install and, I thought, work when I realized that all my contacts and custom data were gone.

I restored the database prior to the installation and went through it all again, step by step.  I kept checking the database.  When I uninstall the component, the records are there.  I made sure everything was updated in the database and as soon as I installed the component from the directory, the contacts and custom data were wiped again.

If I could find the file/table where the options and suboptions from the XML file are stored I would just do it manually.
web design kingwood  | Joomla development

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrade dumps all Data
June 08, 2007, 04:56:29 pm


1. Make sure u've followed the instructions here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+on+Joomla%21

specifically step 4 which comments out the database install

2. Joomla does not have an upgrade system built in. It only has an install system, hence you have to tweak the code to ensure that you db does not get wiped out etc.

3. If you have a better idea on how to potentially handle upgrades a code contribution would be very much appreciated

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

cma01

  • I’m new here
  • *
  • Posts: 26
  • Karma: 2
    • Legacy Marketing Services
Re: Upgrade dumps all Data
June 09, 2007, 09:25:39 am
I had forgotten to uncomment the return line.

I was doing it over and over and didn't do that first step when I unpacked it again.

The start of my problems was the permissions/ownership issue.  I can't even tell you what worked in the end I tried so many combinations.

The joomla installer can change files unpacked by the file manager in the Control Panel for the site, but not through the Xplorer component.  But you can't delete the folders created by the Joomla installer except through Xplorer.  This is on a shared server though, so maybe other people wouldn't have that problem.

I also had to loosen up the permissions on several of the files to get the installation to work without an error.
web design kingwood  | Joomla development

phel0049

  • Guest
Re: Upgrade dumps all Data
November 24, 2007, 09:14:41 pm
Hi, I am having the same issue. Upgrading from 1.8.11536 to 1.9.11960.   I have Joomla 1.0.13 and php5

I went to the link provided for the first poster, and that is the page I've been doing step by step for my entire installation.  I don't see anything on the page that says anything referring "comments out the database install".  I followed all of the instructions on the page (except I have to do a manual install with Powweb), including editing the configure file, but all my records are gone when I open up CiviCRM. 

I backed everything up, so is there a way I can reload the records easily? (Importing the records through the CiviCRM interface to begin with had a lot of errors and bugs so it took me over a month, so I really don't want to do it that way again)  I guess not just the records, but all of the custom fields and profiles and everything.  I backed everything up to my harddrive before the update, so I think I'm ok - I just need to figure out how to restore.

Any guidance is appreciated.  Also any suggestion as to why I lost the data to begin with would be helpful for future reference.

Thanks


Marilyn Phelps

PS - I'm replying to this thread, but I thought it should be in the Upgrading CiviCRM section - I can't move it the whole thing, so I'm going to try to post it there, too.

Quote from: cma01 on June 08, 2007, 01:41:39 pm
I've been trying to upgrade CiviCRM on Joomla for the past two days and I'm about ready to call it quits.

The site is running Joomla 1.0.12, I had CiviCRM 1.6.8310 and I'm trying to upgrade to 1.7.9682.

The only way I've been able to install CiviCRM is by editing the XML file and doing an install from directory.

I was fighting with some permissions and ownerships, but I finally got it to install and, I thought, work when I realized that all my contacts and custom data were gone.

I restored the database prior to the installation and went through it all again, step by step.  I kept checking the database.  When I uninstall the component, the records are there.  I made sure everything was updated in the database and as soon as I installed the component from the directory, the contacts and custom data were wiped again.

If I could find the file/table where the options and suboptions from the XML file are stored I would just do it manually.

Quote from: Donald Lobo on June 08, 2007, 04:56:29 pm


1. Make sure u've followed the instructions here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+on+Joomla%21

specifically step 4 which comments out the database install

2. Joomla does not have an upgrade system built in. It only has an install system, hence you have to tweak the code to ensure that you db does not get wiped out etc.

3. If you have a better idea on how to potentially handle upgrades a code contribution would be very much appreciated

lobo


Quote from: cma01 on June 09, 2007, 09:25:39 am
I had forgotten to uncomment the return line.

I was doing it over and over and didn't do that first step when I unpacked it again.

The start of my problems was the permissions/ownership issue.  I can't even tell you what worked in the end I tried so many combinations.

The joomla installer can change files unpacked by the file manager in the Control Panel for the site, but not through the Xplorer component.  But you can't delete the folders created by the Joomla installer except through Xplorer.  This is on a shared server though, so maybe other people wouldn't have that problem.

I also had to loosen up the permissions on several of the files to get the installation to work without an error.




« Last Edit: November 24, 2007, 09:20:02 pm by phel0049 »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Upgrade dumps all Data
November 27, 2007, 10:37:50 am
In the current upgrade documentation, the information about the file which must be edited to prevent data loss starts here:

Quote
6. Edit the file HOME/com_civicrm/configure.php and make the following change on line 10.

Note that in this documentation, HOME is a placeholder for your actual home directory on your server.

Hope that helps.
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade dumps all Data

This forum was archived on 2017-11-26.