Problem with retrieving plugin’s database table

  • pixelbrad

    (@pixelbrad)


    6 years ago

    Hello,

    You might want to be careful storing the Simple Documentation table as a site option. I had to migrate a website from one environment to another, where the database prefixes were completely different.

    Due to the plugin storing the Simple Documentation table, complete with the prefix, in the WordPress options table, the plugin kept trying to load data from a table that didn’t exist, and so aside from being unable to see all the content that migrated over, I was seeing database errors.

    Old database table, probably from when this plugin was installed: wp_simpledocumentation.
    New table post-migration that this plugin couldn’t locate: local_simpledocumentation.

    I guess you probably have this logic in the client-documentation.php file for compatibility as the plugin matured. But this turned out to be a problem during migration.

    Thanks,
    B

    • This topic was modified 6 years ago by pixelbrad.
Viewing 1 replies (of 1 total)
  • Plugin Author mathieuhays

    (@mathieuhays)

    Hi @pixelbrad,

    Thanks for reporting it!

    Storing the table name is definitely something I want to go away from but I’m a bit stuck due to backward-compatiblity as you mentioned.

    I’ll probably do an update that will migrate the table of the oldest installs.
    This will only affect people that installed the plugin when it was version 1.0.0 so probably not that many people.

Viewing 1 replies (of 1 total)
  • The topic ‘Problem with retrieving plugin’s database table’ is closed to new replies.