DB Tables Dropped Out of Nowhere

  • Resolved Jason Ryan

    (@viablethought)


    6 years, 9 months ago

    Hello –

    Somewhere along the way, the two DB tables associated with this plugin have gone missing!

    ip2nation
    ip2nationCountries

    I have tried uninstalling the plugin and reinstalling thinking I could have them reinitiated that way but no luck. I have no idea how this even happened as nothing had changed with the DB for quite some time. I do have an old DB that has the 2 tables in it, can I dump them from the old DB and reimport them into the one being used with the site or is there something else that can be done to get this working again?

    Thanks in advance.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Paul

    (@paultgoodchild)

    Best thing is to use a tool like phpMyAdmin and re-import the SQL again. You’ll find the SQL files to import within the plugin folder under ‘inc’

    Thread Starter Jason Ryan

    (@viablethought)

    Paul –

    Thanks for the quick response! Luckily I had a previous DB still in phpMyAdmin that had the two tables and I dumped it from there and imported them into the DB currently being used and I am back in business.

    On a side note, I have Debug set to “true” and I am seeing this Notice in the plugin settings view, any concern? It is showing up under all of the Amazon settings:

    Notice: Undefined offset: 6 in /home/ultimate/www/www/wp-content/plugins/custom-content-by-country/views/worpit_options_helper.php on line 76

    Thanks again!

    • This reply was modified 6 years, 9 months ago by Jason Ryan.
    Plugin Author Paul

    (@paultgoodchild)

    great, thanks for the heads up

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘DB Tables Dropped Out of Nowhere’ is closed to new replies.