CiviCRM Community Forums (archive)

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

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.

 

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

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