Troubleshooting

Databases

Connection errors, corrupted tables, phpMyAdmin failures and MySQL 8 compatibility.

13 articles in this topic

13 of 13 articles

  1. Why cPanel and phpMyAdmin show different sizes for a database Explains why cPanel and phpMyAdmin calculate different sizes, how to find the large tables and when to optimise them or wait for the quota to be recalculated. 4 min · Reviewed 09/2026
  2. GLPI time zone error with MariaDB or MySQL Tell apart time zone data that has not been loaded from the permission that only GLPI versions earlier than 10.0.20 require. 4 min · Reviewed 09/2026
  3. PrestaShop, layered_filter_block table grows too large Measure and clear the Faceted search cache, tell it apart from its price index and update the module before automating a task. 4 min · Reviewed 09/2026
  4. Error accessing phpMyAdmin from cPanel, Access denied for user Restore access to phpMyAdmin when the error identifies the temporary cPanel user and its MySQL credentials have got out of sync. 2 min · Reviewed 09/2026
  5. SQLSTATE 2026 error when installing or updating PrestaShop Diagnose the SSL connection to MySQL that prevents Doctrine from querying the server version, without changing PDO options unrelated to the error. 3 min · Reviewed 09/2026
  6. Joomla 1.5 and 2.5, compatibility with MySQL 8 Deal with unsupported Joomla's incompatibility with MySQL 8 through isolation, inventory and gradual migration to maintained versions, without core patches. 2 min · Reviewed 09/2026
  7. Error "Shop not found at line xxx in file classes/shop/Shop.php" Track down Shop not found by checking the requested URL, shop_url and the scope of PS_SHOP_DEFAULT before changing a shop. 3 min · Reviewed 09/2026
  8. Old Drupal, conflict with the system table in MySQL 8 Withdraws the unsafe renaming of the system table and points the recovery of Drupal 6 or 7 towards a supported migration. 2 min · Reviewed 09/2026
  9. Error "Argument X passed OrderProductForViewing must be of the type string" Identify the exact argument and row that deliver NULL when viewing a PrestaShop order, without bulk-replacing valid data. 3 min · Reviewed 09/2026
  10. Some databases do not appear in phpMyAdmin Check whether the database belongs to the account, and ask for a review of the permissions or the cPanel map when it appears in MySQL Databases but not in phpMyAdmin. 2 min · Reviewed 09/2026
  11. Import/export failure in phpMyAdmin Diagnose phpMyAdmin's Missing parameter warnings by renewing the session in a targeted way and reviewing logs and configuration if they recur. 2 min · Reviewed 09/2026
  12. PrestaShopException: diagnosing Invalid address Find the exact reference behind Invalid address and clean up only carts with no order, preserving the historical addresses of orders. 3 min · Reviewed 09/2026
  13. Corrupted tables in a MySQL database Confirm a table's error and engine before repairing it, keep a backup and avoid running REPAIR TABLE on InnoDB or on the whole database without evidence. 2 min · Reviewed 09/2026

No articles match “”.