> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://doc.common-services.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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.