Error when using plugin

  • Resolved nathanwright

    (@nathanwright)


    4 years, 10 months ago

    When I try and upgrade the storage engine button I get the following error:

    Table ‘ic_woo_full_details_v’ was not locked with LOCK TABLES

    How can I resolve this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author OllieJones

    (@olliejones)

    4 years, 10 months ago

    Thanks for the report. It looks like the plugin makes the (incorrect) assumption that all tables in the database belong to WordPress.

    Can you describe the purpose of the ic_woo_full_details_v table? Can you provide a list of the tables in your database?

    Thread Starter nathanwright

    (@nathanwright)

    4 years, 10 months ago

    Hi, digging some more it appears your plugin does not differentiate between tables and views and this is the issue.

    Plugin Author OllieJones

    (@olliejones)

    4 years, 10 months ago

    You are correct. Thanks. Version 1.0.2 corrects the problem, I believe. Please give it a try when you have time. If you don’t mind, please check the [x] upload metadata box when you try it, so I can see what’s going on.

    Sorry for the inconvenience.

    Plugin Author OllieJones

    (@olliejones)

    4 years, 10 months ago

    This has worked correctly on some other sites.

    Thread Starter nathanwright

    (@nathanwright)

    4 years, 10 months ago

    Yes this appears to have fixed the issue. Thanks

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Error when using plugin’ is closed to new replies.