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 »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • WP Migration: All is Great Except Groups Are Missing
Pages: [1]

Author Topic: WP Migration: All is Great Except Groups Are Missing  (Read 1046 times)

theengineroom

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: WordPress
  • MySQL version: 5.5.25
  • PHP version: 5.3.14
WP Migration: All is Great Except Groups Are Missing
February 18, 2013, 04:53:03 am
I recently migrated a CiviCRM instance from Drupal to WP. Everything went smoothly with the installation process and the MySQL migration, but the new WP instance doesn't seem to be recognizing groups from the DB. When I go to groups, there are none listed and Civi asks me to add new ones.

To fix it, I reimported the MySQL database and checked to make sure that the group data was included in what I exported. All seems fine on the database end. Anyone have a similar issue or have an idea on how to reestablish a connection between our MySQL information on groups and the WP interface?

Any help appreciated - we put a lot of work into building groups in our Drupal Civi and wouldn't want to redo it! :)

Thanks,
Alix

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: WP Migration: All is Great Except Groups Are Missing
February 18, 2013, 10:05:24 am

a few questions:

1. Can you check your database and see if there are any entries in civicrm_group

2. Do any groups show up on basic / advanced search

3. Can you check your directory and url settings in the admin screen and ensure that the paths are right. The paths are different for WP and Drupal

Most likely this is a javascript / ajax issue

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

theengineroom

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: WordPress
  • MySQL version: 5.5.25
  • PHP version: 5.3.14
Re: WP Migration: All is Great Except Groups Are Missing
February 18, 2013, 11:09:52 am
Thanks for the speedy reply!

1. Can you check your database and see if there are any entries in civicrm_group

Yes, they are there

2. Do any groups show up on basic / advanced search

No they don't. When I search for a group in basic search I get:
"Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page."

But all of the groups that we created in Drupal are in the drop-down menu in the Advanced Search. Puzzling.

3. Can you check your directory and url settings in the admin screen and ensure that the paths are right. The paths are different for WP and Drupal
They appear correctly. Though in Directories I have no urls for Custom Templates, Custom PHP Path Directory, or CiviCRM Extensions Directory.

 

theengineroom

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: WordPress
  • MySQL version: 5.5.25
  • PHP version: 5.3.14
Re: WP Migration: All is Great Except Groups Are Missing
February 18, 2013, 11:20:10 am
I just rooted around the MySQL database to figure out if there was any information that drew the connection between the contact_ids and the group_ids and the only thing close I could find was the civicrm_group_contact table. This is full of Nulls and doesn't include information on contact_ids. Could this be the problem? If not, where should I look in the DB to see if the data that connects groups to contacts?

Thanks so much for your help on this!

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: WP Migration: All is Great Except Groups Are Missing
February 19, 2013, 08:44:49 am

yeah, thats the right table and shows the contacts for each group. that table should not have nulls for group_id / contact_id. You might want to check in your older DB and see what the table values were

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

theengineroom

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: WordPress
  • MySQL version: 5.5.25
  • PHP version: 5.3.14
Re: WP Migration: All is Great Except Groups Are Missing
February 20, 2013, 07:25:47 am
Hi Donald.

So I am back to square one. The Nulls in the group_contact table are in the location_id and email_id fields. The contact_id fields are populated and match with the correct group_ids. I have rechecked in Drupal and groups are working there when I connect it to the mysql db I am using in WP.

Is there a particular setting that deals with linking the WP installation to the proper table for information about which contacts are in which groups? It seems that that is what is missing for group functionality to... you know...function :)

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: WP Migration: All is Great Except Groups Are Missing
February 20, 2013, 08:32:39 am

hey alix:

can you email me a copy of your database. If it does have sensitive information, you can apply the script bin/encryptDB.php (be careful and do it ONLY on a copy, its a one way encryption) and email me the encrypted copy to lobo at civicrm dot org

thnx

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • WP Migration: All is Great Except Groups Are Missing

This forum was archived on 2017-11-26.