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) »
  • Best Practices from switching from Joomla to WordPress
Pages: [1] 2

Author Topic: Best Practices from switching from Joomla to WordPress  (Read 6846 times)

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Best Practices from switching from Joomla to WordPress
January 03, 2012, 10:29:26 am
I'm not a big fan of Joomla but have used it reluctantly over the last year in order to use CiviCRM. Now that CiviCRM is going to be available for WordPress, what would be the best way to get my existing data into the WordPress module/plugin for CiviCRM?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
January 04, 2012, 12:24:26 pm
I would suggest you install a fresh copy of CiviCRM in WordPress first.

Now the easiest way is to export data from your Joomla CiviCRM and then import it into the WordPress one, using the regular web interface.

If you have a lot of data, or too many types of data like events and groups and tags etc. to do that, then you could try remove everything from your new WordPress CiviCRM DB (or all CiviCRM tables if it's a shared DB) and then replace that with all the tables from the Joomla CiviCRM (but only the CiviCRM tables of course). Then run

Code: [Select]
UPDATE `civicrm_domain` SET `config_backend`=NULL ;
in MySQL.

The only issue that may be open is the link between contacts and Joomla users. Since your WordPress user list will not match your Joomla one, this needs to be reset, but you can run the contact-user synch tool in CiviCRM to fix that.

This second idea is experimental, but you're encouraged to give it a try and see what happens. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 19, 2012, 05:20:57 pm
I'm getting a foreign key constraint fails issues when trying to import the joomal sql dump into the wordpress sql import. Any ideas.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 20, 2012, 03:17:56 am
Choose to disable foreign key checks when you make your dump from the existing DB.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 23, 2012, 05:10:05 pm
Quote from: Hershel on February 20, 2012, 03:17:56 am
Choose to disable foreign key checks when you make your dump from the existing DB.

After several days and numerous attempts, I just can't figure out how to do this.

1. the export file is 38Mb, so too large for standard MyPHPAdmin import. My host doesn't allow SSH connections. I found bigdump.php and finally got that to run part of the way.
2. Even after checking disable foreign keys on my export from Joomla (by the way only exporting 4.1 Civicrm tables, not any of the Joomla tables), when running bigdump.php to get the database into the empty WordPress CivicCRM 4.1 database, I get down to:

Error at the line 23091: DROP TABLE IF EXISTS `civicrm_address`;
Query: --
--
DROP TABLE IF EXISTS `civicrm_address`
MySQL: Cannot delete or update a parent row: a foreign key constraint fails

This is frustrating. Any ideas would be appreciated.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 24, 2012, 04:58:51 am
Use phpMyAdmin to export ONE small table with click disable foreign key checks. Then you will see the disable foreign key checks code at the top and bottom of the export. Copy and paste that into the top and bottom of your bigdump dump and see if that works.

Beyond that, if you're spending "several days and numerous attempts" to do something which is a 3 minute job via ssh, I would consider switching hosts to one that can provide better service.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 24, 2012, 08:47:02 am
I got the database table in but now the CiviCRM main dashboard and screens don't load correctly. Are there instructions similiar for WordPress as they are in the documentation for Joomla and Drupal.

Enter the following URL in your browser to review and update directory paths and base URLs:
Drupal sites: http://<drupal_site>/index.php?q=civicrm/admin/setting/updateConfigBackend&reset=1
Joomla 1.5 sites: http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1
Joomla 1.6 sites: http://<joomla_site>/administrator/index.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1

I'm assuming I need to get to the URL Directory table somewhere and change the URLs to point to my testserver also?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 25, 2012, 11:18:27 am
Try http://<your_wordpress_home>/wp-admin/admin.php?page=CiviCRM&q=civicrm/ and then whatever else such as

/admin/setting/updateConfigBackend&reset=1

etc.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 05:58:06 am
I tried this: http://<mywebsiteaddress>/wp-admin/admin.php?page=CiviCRM/admin.php?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1 and I just got a page that says:

You do not have sufficient permissions to access this page.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 06:00:44 am
Your URL is incorrect. Try

http://<mywebsiteaddress>/wp-admin/admin.php?page=CiviCRM?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 06:37:13 am
Hershel, thanks even with this link, I'm getting the same message about permissions.

Any ideas? :)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 07:13:41 am
Stupid question, but of course if you go to http://<mywebsiteaddress>/wp-admin/admin.php in the same browser, you are logged as the WP admin, right?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 08:52:10 am
If I go to http://<mywebsiteaddress>/wp-admin/admin.php I get just a blank white page. If I go to: http://<mywebsiteaddress>/wp-admin/ without anything after the slash, I'm in my WordPress Admin Dashboard.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Best Practices from switching from Joomla to WordPress
February 26, 2012, 08:57:10 am
Sounds like you have a problem with your basic WP install. The URL http://<mywebsiteaddress>/wp-admin/admin.php should work. See http://wordpress.org/support/topic/wordpress-site-working-but-wp-adminadminphp-error A bit old, but this URL should work.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

MulderDSM

  • I post occasionally
  • **
  • Posts: 100
  • Karma: 0
  • CiviCRM version: 4.6.0
  • CMS version: Joomla 3.4.1
Re: Best Practices from switching from Joomla to WordPress
February 27, 2012, 01:12:09 pm
Herschel,

I looked at your demo site at: http://wordpress.demo.civicrm.org and the same thing happens. the page name of admin.php does not show up and if you add it, you get a blank white screen.
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Best Practices from switching from Joomla to WordPress

This forum was archived on 2017-11-26.