How can I debug my database connection for unit testing?

Put a file named db-error.php into the wp-content directory. Here you can ask the global $wpdb object for more detailed errors:

global $wpdb;
$wpdb->print_error();

This will print out the last error message if the database handler.

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. MySQL error 2006: mysql server has gone away
  3. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  4. Cannot delete or update a parent row: a foreign key constraint fails
  5. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  6. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  7. Your password does not satisfy the current policy requirements
  8. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  9. what does “/index.php?admin/admin_dashboard” in my url mean
  10. How to join two tables by multiple columns in SQL?
  11. How to get size of mysql database?
  12. SQL – Update multiple records in one query
  13. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  14. MySQL: Invalid use of group function
  15. mysqladmin: connect to server at ‘localhost’ failed
  16. mysql update multiple columns with same now()
  17. Usage of MySQL’s “IF EXISTS”
  18. How can I loop through all rows of a table? (MySQL)
  19. Generating a random & unique 8 character string using MySQL
  20. MySQL > Table doesn’t exist. But it does (or it should)
  21. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  22. mysql count duplicates
  23. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  24. MySQL config file location – redhat linux server
  25. How to create a foreign key in phpmyadmin
  26. Can’t create test file lower test start server mysql
  27. MySQL delete multiple rows in one query conditions unique to each row
  28. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  29. CAST to DECIMAL in MySQL
  30. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  31. MySql – HAVING vs WHERE 
  32. How to stop mysqld
  33. Is merge statement available in MySQL
  34. GROUP_CONCAT comma separator – MySQL
  35. Failed to Connect to MySQL at localhost:3306 with user root
  36. How do you properly prepare a %LIKE% SQL statement?
  37. Optimize Multiple Taxonomy Term MySQL Query?
  38. WordPress MySQL & PHP Performance
  39. Using source control with WordPress
  40. SQL query to update post_date (one post = one single date & time)
  41. Updating User Meta with SQL Query
  42. wpdb prepare syntax
  43. How to run this SQL query of wp_terms database
  44. Configure WordPress to connect to Mysql DB using SSH tunneling
  45. Proper way to work with wpdb to get user’s firstname
  46. How to change post format from Aside to Image for all posts?
  47. Inserting Hundreds of Thousands of Posts at Once
  48. wp_admin edit.php slow with lots of queries
  49. How to add and SQL query of posts only published
  50. Slow Mysql Queries
  51. can database and media folder be moved to a different drive?
  52. Find duplicate posts with same slug and author
  53. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  54. Rewrite database urls
  55. writing inner join in wpdb
  56. How to get data from WordPress site sql file
  57. Unknown collation when I import a dump from an existing site into a development database?
  58. PHP script can’t connect to Database on port 3307
  59. WordPress with php5-fpm and nginx
  60. Migrating from Existing MySQL Setup to WordPress
  61. How to split the a table in database?
  62. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  63. How to translate this mySQL query to $wpdb query
  64. $wpdb to insert html form information
  65. Proper usage of $wpdb->update()?
  66. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  67. Separate DB by yearly archive of WordPress
  68. What should a WordPress developer know about MySQL? [closed]
  69. Copyright: Get first and last date of post type
  70. Update MySQL query so that it functions again
  71. Query posts by custom taxonomy and sort by post_modified
  72. WordPress $wpdb get posts from category and sort by custom meta
  73. WordPress tables and aliases?
  74. What’s the sql for this condition?
  75. Array Formation Issue
  76. How can I write a formal sql query to get data from a custom table
  77. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  78. WordPress $wpdb no result
  79. Word Press and database from another server sync
  80. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  81. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  82. edit_user_created_user hook – using to update Groups
  83. Changes not being reflected on new server
  84. Mysql Error in querying form entries in Gravity Form plugin
  85. Improving performance of SQL sub-queries in WordPress
  86. MySQL – How to combine data from two tables into one?
  87. Saving custom term value to the database in new table
  88. Stop my loop to register data twice
  89. MySQL errors after a WordPress clone
  90. How to restore: Database intact but folders deleted
  91. XML RPC post produces immediate revision with odd post_date_gmt
  92. MYSQL Join on meta key value?
  93. Woocommerce: Grab total revenue of a product over all orders
  94. Complicated MySQL Query
  95. problem with quotes on new post
  96. SQL Database Lost
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?

Leave a Comment