Migrated site and all listings won't display

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
January 26, 2015 at 6:24 pm #28867

Alice Foeller
Full Member

Post count: 17

Compare siteinsight.com/dublincan (the development site)
to http://www.dublincan.org (the live site)

The listings are not showing up, although the items are still in the dashboard.

Under Places, the Place Information was not showing up but it is on the old site. I created a backup and updated the addon. After the addon was updated it gave me an error message:

WordPress database error: [Table ‘dublincan.wp_geodir_gd_place_detail’ doesn’t exist]
UPDATE geodir_post_review gdr JOIN wp_geodir_gd_place_detail d ON gdr.post_id=d.post_id SET gdr.post_latitude = d.post_latitude, gdr.post_longitude = d.post_longitude, gdr.post_city = d.post_city, gdr.post_region=d.post_region, gdr.post_country=d.post_country WHERE gdr.post_latitude IS NULL OR gdr.post_city IS NULL

January 26, 2015 at 6:51 pm #28872

Paolo
Site Admin

Post count: 31206

Hi Alice,
did you convert the tables for multisite compatibility? It was a mandatory step after updating to 1.3+?

You can run the tool in GD Tools.

Let us know,

p.s. if you have addons you should sync your account with your themetailors.com account. Now you appear as a free user.

February 3, 2015 at 11:56 pm #29853

Alice Foeller
Full Member

Post count: 17

Yes, I ran that, and I ran Sync GD Categories, too.

February 3, 2015 at 11:57 pm #29855

Alice Foeller
Full Member

Post count: 17

Also, I can see all my entries in “Places” on the backend, but when I click “View” I get a 404 error.

February 4, 2015 at 12:46 am #29858

Alice Foeller
Full Member

Post count: 17

Also, all of the custom fields and maps and all of that are missing on the new site, compared to the old site.

February 4, 2015 at 2:26 pm #29940

Paolo
Site Admin

Post count: 31206

We would need a link and wp admin credentials to check.

Thanks

February 4, 2015 at 8:23 pm #30012

Alice Foeller
Full Member

Post count: 17

This reply has been marked as private.

February 5, 2015 at 7:47 pm #30143

Simone
Expired Member

Post count: 3515

Hello Alice, on your live website you have GD v.1.3.5 but in your development site you have v1.2.7 which is very different in the structure. Please update (both) and once you update the one on the dev site, be sure to run the GD tools, thanks.

February 6, 2015 at 1:11 am #30157

Alice Foeller
Full Member

Post count: 17

OK, if I update on the dev site, it won’t screw up any of my custom fields or anything, right?

February 6, 2015 at 1:46 am #30160

Alice Foeller
Full Member

Post count: 17

OK, I ran the update on the dev site and then ran Tools and everything is good.
What is the most efficient way to move the GeoDirectory stuff to the live site again? Can I just copy a folder?
I have updated on both sites and run Tools, and on the live site I’m still not seeing my listings.

February 6, 2015 at 9:27 am #30170

Guust
Moderator

Post count: 29970

http://codex.wordpress.org/Moving_WordPress

February 6, 2015 at 4:31 pm #30198

Paolo
Site Admin

Post count: 31206

My guess is that you moved the database of the development site before running the convertion tools and some custom tables are missing.

Now that the staging site is updated and working as expected, simply do a new database backup of the staging site and import it in the development site using a tool like this: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ to search & replace the domain without breaking serialized strings.

Let us know,

Thx
Author

Posts