1. Home
  2. WHMCS + QuickBooks Sync Module
  3. Troubleshooting
  4. Fatal error: Error Num.: Error Msg.: SQL: SHOW TABLES Database:

Fatal error: Error Num.: Error Msg.: SQL: SHOW TABLES Database:

Keep getting this error when you’re trying to install our WHMCS QuickBooks Online Module?

Error

Fatal error: Error Num.: Error Msg.: SQL: SHOW TABLES Database: /my_database in /home/user/public_html/modules/addons/quickbooks_sync/lib/myworks/QuickBooks/Driver/Sql/Mysqli.php on line 0

Cause

The database password for your WHMCS database (specified in your configuration.php file) contains an invalid character – one of the following:
+ / # % ‘ ?

Resolution

Simply update the database password in your control panel to a password that does not include any of the above characters – then update your configuration.php file with this password.

Updated on August 1, 2017

Was this article helpful?