Lost lots of custom fields and images and tables dissapeared!

This topic contains 27 replies, has 3 voices, and was last updated by  Kiran 5 years, 2 months ago.

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

Open Support Ticket
  • Author
    Posts
  • February 11, 2019 at 10:20 pm #468340

    awakeningearth
    Expired Member
    Post count: 48

    Hi

    Not sure whats happening here but Ive had myself a bit of a panick! my last backup is from a couple of weeks ago and for some reason Ive had a look and tables have disapeared from MYSQL for geodirectory only and all I am left with is.
    aearth_geodir_comments_reviews
    aearth_geodir_rating_category
    aearth_geodir_rating_style
    Very strange, all I did was delete a member who did not as far as I know create any custom fields, it was me the admin who made them all, then I created a new sub site …yet somehow they have all disapeared and all im left with is the listings with only a title and content, no custom fields on the listing or listing images.

    Damn!

    February 11, 2019 at 10:26 pm #468344

    awakeningearth
    Expired Member
    Post count: 48

    Just noticed also that there is no map when I try to add a new community, so very strange as far as I can tell the rest of my site is ok its just geodirectory lost its tables!

    February 11, 2019 at 10:32 pm #468347

    Alex Rollin
    Moderator
    Post count: 27815

    Whoah!
    Are the plugins still installed?

    February 11, 2019 at 10:57 pm #468353

    awakeningearth
    Expired Member
    Post count: 48

    Yep all installed and activated!

    February 11, 2019 at 10:58 pm #468354

    awakeningearth
    Expired Member
    Post count: 48

    now kicking myself for having not backed up often enough! how do database tables just disapear when ive been nowhere near them ? lol

    February 12, 2019 at 9:17 am #468393

    awakeningearth
    Expired Member
    Post count: 48

    Ok, I had hoped this issue was just my hosting being wierd but that information in the tables are not there, I guess my only option is to go back to my old backup sql file and import in sections the data ?

    Thanks
    Riki

    February 12, 2019 at 10:27 am #468420

    Kiran
    Moderator
    Post count: 7069

    Hello Riki,

    GeoDirectory plugins database tables are deleted during plugin uninstall when “Uninstall data” ticked under Uninstall settings. There is no other way to delete database tables from GeoDirectory plugin.

    Please provide site link and admin, FTP credentials so i can check there. Also provide phpMyAdmin database access so i can check database structure & data as well.

    Kiran

    February 12, 2019 at 11:21 am #468436

    awakeningearth
    Expired Member
    Post count: 48
    This reply has been marked as private.
    February 12, 2019 at 11:49 am #468445

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    February 12, 2019 at 12:02 pm #468455

    awakeningearth
    Expired Member
    Post count: 48
    This reply has been marked as private.
    February 12, 2019 at 12:07 pm #468457

    awakeningearth
    Expired Member
    Post count: 48

    Very strange because geo-directory was definetly NOT uninstalled, the changes I had made before this happened were create a sub site, delete sub site as it did not install right due to the fact I had not enabled HTTPS on that sub sites domain, delete a user who may have been an admin (not sure) and atributed all her content to another user. the main admin account which I created all my custom fields and geo-directory content in over the last month was untouched.

    February 12, 2019 at 12:17 pm #468459

    Kiran
    Moderator
    Post count: 7069

    Hello,

    This is very strange!
    Did you took backup before deleting a site or deleting a a user? If you have then try to restore it.

    Let us know.

    Thanks,
    Kiran

    February 12, 2019 at 12:22 pm #468463

    awakeningearth
    Expired Member
    Post count: 48

    No I did not and I know that was stupid! lol but I have one in last couple of weeks 🙂
    Yes it is strange, I can only guess that there was an issue when I created that sub site as its a multisite network.
    Nevermind, we must move on I will recreate my database but do you know how is best to do it ?

    I can either delete all tables and restore all geodir tables from the sql file, or I can empty the tables for custom fields etc and manualy add that data back into the pre existing tables.

    The only diference about my backup is that its from an older Beta version and I am now on the current version!

    February 12, 2019 at 12:51 pm #468478

    Alex Rollin
    Moderator
    Post count: 27815

    You shouldn’t have any issues with older tables and a newer version of GDV2, as long as it is GDV2. If the tables are GDV1 then the converter will need to be run again.

    Our support goes as far as “It sounds like restoring from a backup is a good option” but how you restore is going to have to be up to you.

    February 12, 2019 at 2:47 pm #468510

    awakeningearth
    Expired Member
    Post count: 48

    Yes I thought so much, ok well I will recover my backup file in sections I recon and see how it works.

    Thanks for your help people!

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 28 total)

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

Open Support Ticket