How to Fix Error: "Your hosting doesn't allow: SHOW TABLES" - Amazon Marketplace Plus

When accessing the information page of the Amazon Marketplace Plus module, you may encounter the following diagnostic error message:

Your hosting doesn't allow: SHOW TABLES

Why Does This Error Occur?

The SHOW TABLES command is a standard SQL query used by the module to check your database structure, verify that all required module tables exist, and ensure everything is running smoothly.

If this error appears, it means your hosting environment has highly restrictive database security permissions. The database user account configured for your PrestaShop store is being blocked from running this basic inspection command by your server or firewall.

How to Resolve the Error

To fix this, you will need to adjust your database permissions or contact your hosting provider. Follow these troubleshooting steps:

Step 1: Check Database User Privileges

If you have access to your hosting panel (such as cPanel, Plesk, or Cloudways):

1. Navigate to your MySQL Databases or Database Management section.
2. Locate the database user assigned to your PrestaShop installation.
3. Check the user's privileges. Ensure that ALL PRIVILEGES are granted to this user.
4. Specifically, ensure the account has permissions for SELECT, SHOW VIEW, and standard read operations, which are required for SHOW TABLES to execute.

Step 2: Contact Your Hosting Support

Many managed hosting providers implement strict rules that block specific database commands by default. If you cannot change these settings yourself, reach out to your host's technical support team.

Updated on: 03/06/2026