CiviCRM Community Forums (archive)

Hi all,
I seek a bit of help... I have a Joomla site (1.5.17) that needs to be upgraded along with the install of CiviCRM (3.1.4).  The main part of the data is in the Civi part of the site.  i have tried numerous approaches to get a working upgraded site and none have worked.

jUpdate fails which is hindering the whole process.

Now I want to do a clean install of Joomla (2.5.6) and then do a new install of Civi and would then like to swap out the data tables to be able to then run a Civi updater to get to the latest version.

1. Is this a viable approach?
2. What do I need to do to be able to do the data swap for the civi tables?
3. Is there a better approach I should consider?

I have been working on this for days and desperately need to be up to speed soon.

Thanks for any and all feedback and guidance!

- Roland

hershel:

u've imports a 3.1.x dump into an empty 4.1.x DB schema and its worked fine?

i'd be astonished if that really works since seems like u'll be missing all the meta-data added between 3.1 -> 4.1

and also all the columns that changed names would give an error

lobo

u've imports a 3.1.x dump into an empty 4.1.x DB schema and its worked fine?

No, what I have done to handle major upgrades (like D6 - D7 or major Joomla upgrade) is to make a fresh Drupal/Joomla site with the latest CiviCRM, then nix the CiviCRM DB, import the old one (such as 3.x) and then run the upgrader on that CiviCRM DB.

That works.

What is the best way to accomplish this?

What I would suggest, if you are having trouble dropping the CiviCRM tables, would be to export JUST the Joomla tables (structure and data), then REMOVE the database altogether, recreate it and then:

1. Import the Joomla tables
2. Import your old CiviCRM tables
3. Run the upgrade tool

Just visit civicrm/upgrade?reset=1 to upgrade.

UPDATE
When I try to manage events, for example, I go from the dashboard to this page:

https://www.SITE.org/new2/administrator/index2.php?option=com_civicrm&task=civicrm/event/manage&reset=1&

I then get the "permission" error cited above.  But if I simply remove the "2" of index2.php the page loads and shows the proper info!!

https://www.SITE.org/new2/administrator/index.php?option=com_civicrm&task=civicrm/event/manage&reset=1&

Does this help anyone narrow down what I need to do to fix this problem? 

Thanks!

Good idea - I tried that too!  It runs but just takes me back to the Civi dashboard and still shows that I am running version 3.1.4 in the footer.

Is that supposed to install the latest version of Civi and update tables, and pages, etc.?

I am back! After what seemed like a brief success I am back to square one.  I am following your idea to a T but hit error after error.  Previously I installed the newer Joomla with the older Civi 3.1.4 along with my good data I am trying to save. From there I ran the upgrader which you recently commented on indicating I need to load the newer Civi files then dump the civi tables and load the old civi tables and run the upgrade script.

Now when I do that I get an "Initialization Error" and a bunch of code indicating there is no such field and unknown column 'locale_custom_strings' in 'field list'.

Although I do not know what to do at this point it makes sense to me that there is a discrepancy in tables since I am sure the database structure is different from version 3.1.4 to 4.1.5.

I am not sure how you managed success with this approach since it is eluding me at every attempt.

Thanks for your attention Hershel.  Did you use this method to upgrade from version 3 to version 4? Or is it only for going from one "dot" version to another? (ie 4.1.1 to 4.1.5)

- Roland