Error when clicking on WooCommerce Settings link

  • Resolved SteveHale

    (@stevehale)


    1 year, 9 months ago

    Hi There

    I am getting this error when I click on the settings link for Woocommerce, only when I click on WooCommerce settings link, after the latest updates:

    Unexpected database error.<br><br><a href="https://thelondonlifecoachingcompany.com/wp-admin/admin.php?page=smart-slider3&repairss3=1&_wpnonce=ef5396c5c7" class="n2_button n2_button--big n2_button--blue">Try to repair database</a><br><br>Your database user has limited access and isn't able to run DROP or ALTER database commands. Contact your server host and ask them to fix this for you!<br><br><b>Can't DROP 'application'; check that column/key exists</b><br>ALTER TABLE llccxx_nextend2_section_storage DROP INDEXapplication`

    Unexpected database error.<br><br><a href=”https://thelondonlifecoachingcompany.com/wp-admin/admin.php?page=smart-slider3&repairss3=1&_wpnonce=ef5396c5c7&#8243; class=”n2_button n2_button–big n2_button–blue”>Try to repair database</a><br><br>Your database user has limited access and isn’t able to run DROP or ALTER database commands. Contact your server host and ask them to fix this for you!<br><br><b>Can’t DROP ‘thumbnail’; check that column/key exists</b><br>ALTER TABLE llccxx_nextend2_smartslider3_slides DROP INDEX thumbnail

    Unexpected database error.<br><br><a href=”https://thelondonlifecoachingcompany.com/wp-admin/admin.php?page=smart-slider3&repairss3=1&_wpnonce=ef5396c5c7&#8243; class=”n2_button n2_button–big n2_button–blue”>Try to repair database</a><br><br>Your database user has limited access and isn’t able to run DROP or ALTER database commands. Contact your server host and ask them to fix this for you!<br><br><b>Duplicate key name ‘thumbnail'</b><br>ALTER TABLE llccxx_nextend2_smartslider3_slides ADD INDEX thumbnail (thumbnail(100))`

    Please can you help.

    Regards

    Steve B

Viewing 1 replies (of 1 total)

  • Hi,

    Sorry for the delay in responding, we are receiving a high ticket volume on all our queues, including the WooCommerce Forums.

    As a first step, I recommend to reach out to your web host, they can provide you with more information, you can ask them if they have a backup to help you restore the database.

    You can as well verify your database tables, this option is under WooCommerce > status > tools > verify database tables.

    If you need further help after that, please share a copy of your site’s System Status Report? It is under WooCommerce > Status. Select “Get system report” and then “Copy for support”.? So that we can get a clearer idea about this case.

Viewing 1 replies (of 1 total)
  • The topic ‘Error when clicking on WooCommerce Settings link’ is closed to new replies.