Rebuilding wp_geodir_gd_places_detail

Thanks for responding Alex,

As mentioned, there is no backup of the database tables, just the data that goes in the tables.

Therefore, I need to rebuild the table or start again by recreating the table. The table doesn’t recreate (even with default settings) when I uninstall and install the geodirectory plugin.

There also seems to be dependencies with wp_pages as well as the custom tables where these pages still work independently even without geodir_places_detail being present and so the plugin itself doesn’t seem to realise there’s an issue. So I’m a little stuck until I can reinstall / rebuild.

Thanks for your help gents, I know it was a silly thing to do.

Thanks Naveen,

Your points about backups are understood and we ‘did’ have them until they were deleted by a 3rd party without my knowledge… hence the massive error with all of this. I have put in steps to ensure this doesn’t happen again.

Step 2: where must I put this code to run it?

Thanks,
Peter

Hi Naveen,
Ran the code – it said it executed and geodir_places_detail was created. I then imported data and it went in to wp_posts but not in to geodir_places_detail.

The result is that my WP admin site shows 1,054 records in the gs_places section but zero in the Dashboard and the website seems to have stopped working when previously it was just showing ‘No Records’ in the map area.

Thanks,
Peter