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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • moving Joomla site with Akeeba causes database errors
Pages: [1]

Author Topic: moving Joomla site with Akeeba causes database errors  (Read 2947 times)

minbori

  • I post occasionally
  • **
  • Posts: 53
  • Karma: 2
  • CiviCRM version: 4.0.8
  • CMS version: Joomla 2.5.24
  • MySQL version: 5.5.37
  • PHP version: 5.3.29
moving Joomla site with Akeeba causes database errors
June 27, 2011, 02:52:05 am
Greetings, I'm rying for the first time to use Akeeba to move/copy a Joomla site with a configured CiviCRM, using http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location as my guide.  When I get to Step 6 of that document (access URL http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1) I get database errors.  I think my trouble might be in the Akeeba backup settings, can someone review the below procedure and see if I'm missing something?

My setup:
Joomla: 1.5.23
CiviCRM: 3.0.0 (YES, I realize this is an old version. Ironically, I'm trying to create a test environment where I can test the 3.4 upgrade before doing it on the live site!)
Akeeba: 3.3.a3

1. Run an Akeeba backup with settings to exclude the data from the database tables listed in the Confluence document(civicrm_domain, civicrm_acl_cache, civicrm_acl_contact_cache, civicrm_cache, civicrm_group_contact_cache), as well as the files/folders in the /media/template_c directory. (I've tried backups with settings for both "ignoring" the db tables completely, and simply "excluding" the data. See errors below.)

2. Used Akeeba Kickstart and Installer to unpack and set up the site on the test server.

3. Updated the following files with the correct database and file paths for the test server:
/administrator/components/com_civicrm/civicrm.settings.php
/administrator/components/com_civicrm/civicrm/civicrm.config.php
/components/com_civicrm/civicrm.settings.php

4. run this against the database (from lobo's post http://forum.civicrm.org/index.php/topic,6076.msg26765.html#msg26765)
update civicrm_domain set config_backend = null;
truncate civicrm_menu;

5. Try to access http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1

Resulting errors from this step:
-- if I use an Akeeba backup set up to completely ignore the tables described in the "Moving+an+Existing+Installation..." document, I get "TABLE DOES NOT EXIST" errors (of course).
-- if I use an Akeeba backup set up to include the table structures, but ignore the data, I get "DB Error: constraint violation..." on a statement "INSERT INTO civicrm_menu"

Thoughts?  Can Akeeba still be used to move CiviCRM, or do I need to do something like this: http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+the+database+using+phpMyAdmin

Thanks!

davesage

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 3
  • CiviCRM version: 3.4 & 4.1
  • CMS version: Joomla 1.5 & 2.5
  • MySQL version: 5.1
  • PHP version: 5.3
Re: moving Joomla site with Akeeba causes database errors
June 27, 2011, 03:58:46 am
Hi,

I use Akeeba on Joomla to move things.

I can see you are using the first alpha release of akeeba 3.3 - can I suggest you use their current stable release 3.2.7 - this might have better results. They're also now on beta of 3.3 so you could try that as they have fixed bugs since the alpha release.

Let me know how it goes.

I'll give what you are doing a try on my setup with 3.2.7 and then if you receive more errors I can compare what happens with me.

I know I have moved a 3.3 in the last couple of months with Akeeba 3.2.? and all went okay.

Sorry not to be more help.

Dave

minbori

  • I post occasionally
  • **
  • Posts: 53
  • Karma: 2
  • CiviCRM version: 4.0.8
  • CMS version: Joomla 2.5.24
  • MySQL version: 5.5.37
  • PHP version: 5.3.29
Re: moving Joomla site with Akeeba causes database errors
June 27, 2011, 05:44:37 am
Hi Dave, thanks for the reply.  I'll try reverting to Akeeba 3.2.7 -- I didn't even notice 3.3 wasn't stable yet! -- try again, and let you know how it goes.  ::)

nicholas@akeebabackup.com

  • I’m new here
  • *
  • Posts: 1
  • Karma: 1
  • CiviCRM version: -
  • CMS version: Joomla! 1.5/1.6/1.7
  • MySQL version: 5.0/5.1
  • PHP version: 5.3
Re: moving Joomla site with Akeeba causes database errors
June 29, 2011, 07:34:54 am
Hi all,

I am Akeeba Backup's lead developer, so I thought I should answer this :) No matter if you use 3.2.7 (stable) or 3.3.b1 (beta), the issue will remain unless you do something during restoration. During the Restore DB step, please check the "Suppress foreign keys while restoring" option while restoring your database. This will ignore the foreign key checks.

That said, if CiviCRM is using other table contraints, then it's not possible to restore its tables unless you manually dump them and restore them, making sure that you disable all constraints (using ALTER TABLE commands) while you are restoring data. Akeeba Backup can not handle that, as it is not possible to automatically deduct the required ALTER TABLE commands (and their proper sequence) for disabling/enabling foreign key checks.

minbori

  • I post occasionally
  • **
  • Posts: 53
  • Karma: 2
  • CiviCRM version: 4.0.8
  • CMS version: Joomla 2.5.24
  • MySQL version: 5.5.37
  • PHP version: 5.3.29
Re: moving Joomla site with Akeeba causes database errors
July 12, 2011, 08:02:18 am
Thanks for the info nikosdion! Sorry for the delay in my response...real life put some other professional priorities ahead of this problem.  I'm going to try this now and will post the results.

minbori

  • I post occasionally
  • **
  • Posts: 53
  • Karma: 2
  • CiviCRM version: 4.0.8
  • CMS version: Joomla 2.5.24
  • MySQL version: 5.5.37
  • PHP version: 5.3.29
Re: moving Joomla site with Akeeba causes database errors
July 25, 2011, 03:10:34 am
No good, same problem.  I guess at this point the best course of action is to follow http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+the+database+using+phpMyAdmin:

1. Duplicate the live site using Akeeba backup, extract to the test server

2. uninstall the CiviCRM in the test site I've created, and REinstall the 3.0.0 version

3. Export and reimport just the civicrm database tables, using the procedure in the confluence document for moving the database:  manually remove the constraints before data import, then rebuild the constraints afterwards.

Unless someone has a better idea? *hopeful face*

davesage

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 3
  • CiviCRM version: 3.4 & 4.1
  • CMS version: Joomla 1.5 & 2.5
  • MySQL version: 5.1
  • PHP version: 5.3
Re: moving Joomla site with Akeeba causes database errors
July 25, 2011, 03:28:56 am
Hi Again,

Maybe my setup is different to yours but I moved a website to create a dev version in a subdirectory only the other day with akeeba and it worked fine, I just restored a full backup then changed the config files and did the stuff in the admin section and it worked.

Confused as to why mine is ok when yours is throwing errors, I have only got custom data created directly in civi so I'm presuming all the FK constraints are only normal ones.

humm

Dave

minbori

  • I post occasionally
  • **
  • Posts: 53
  • Karma: 2
  • CiviCRM version: 4.0.8
  • CMS version: Joomla 2.5.24
  • MySQL version: 5.5.37
  • PHP version: 5.3.29
Re: moving Joomla site with Akeeba causes database errors
July 29, 2011, 06:23:41 am
Thanks for the reply, and the commiseration Dave :-)  This is the stupid saga that never ends.  ;)

Believe it or not, I was finally able to recreate a working CiviCRM on a test environment following the extremely ponderous procedure I outlined in my last post. However, then the CiviCRM upgrade bombed out on...guess what....a database error.  I'm trying the same procedure once more to see if I can reproduce that database error, and if so, time for a new post about the upgrade fail :-p

Your post has given me another idea tho.  I've been moving my site to another test server, whose settings I *think* are the same as the live -- but you never know.  I might try recreating my site inside a subdirectory of the live server, using a new database on the live db machine.  Maybe there's some environment difference I'm not noticing.

Until I figure all this out though, I'm still NOT upgrading the live site!  ;D

davesage

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 3
  • CiviCRM version: 3.4 & 4.1
  • CMS version: Joomla 1.5 & 2.5
  • MySQL version: 5.1
  • PHP version: 5.3
Re: moving Joomla site with Akeeba causes database errors
August 05, 2011, 08:34:29 am
Sorry to hear about the continued issues!

I recently setup XAMPP on a windows laptop and used akeeba to move my site, all went ok (apart from a few settings that were quirky in windows - see other posts - lol)

There were no database issues at all in terms of the move.

What hosting are you using for your live site?

Hope you have more success soon.

Cheers,

Dave
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • moving Joomla site with Akeeba causes database errors

This forum was archived on 2017-11-26.