How can I detect right db type?

wpdb->dbh is declared as protected property, you should not even have access to it, unless you are subclassing wpdb?

The only public property is wpdb->is_mysql which is just hardcoded for true and meant for detection of non–native database drop–ins.

So overall wpdb context is meant to be internal, you set up the connection and let it deal with the detail from that point.

I have no experience with triggers in WP context, but it sounds strange for arbitrary query to not just work in query() method. I would recommend to get to the bottom of that. It might be that issue is with query or something related and not WP call running it.

Related Posts:

  1. Rename a table in MySQL
  2. How should I tackle –secure-file-priv in MySQL?
  3. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  4. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  5. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  6. Using wpdb to connect to a separate database
  7. Checking if Database Table exists
  8. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  9. How to fetch Data in WordPress using MySQLi or $wpdb
  10. Connect to database using wordpress wp-config file
  11. wpdb->insert multiple record at once
  12. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  13. How to define composite keys with dbDelta()
  14. Is it possible to define two databases for one installation?
  15. Does WordPress use the InnoDB engine for MySQL by default?
  16. WordPress for a very large website
  17. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  18. Huge wp_options table
  19. “MySQL server has gone away” since update to 3.8
  20. Error establishing a database connection – with Debug Data
  21. How to execute mulitple statement SQL queries using $wpdb->query?
  22. Can I transfer a mysql database to another site?
  23. Database with mixed collation (utf8mb4 & utf8_general_ci)
  24. MySQL Syntax Error upon restoring database from backup [closed]
  25. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  26. Set Display Name to first and last name (phpmyadmin SQL Query)
  27. Is it safe to convert tables from MyISAM to InnoDB?
  28. Emojis getting converted to “?”
  29. Migrating database / content of non-CMS site to WordPress
  30. Does WordPress ever need multiple databases?
  31. Why are no posts showing despite my apparently correct DB restoration?
  32. Delete all post meta except featured image Using SQL
  33. How do I properly update the WordPress database password?
  34. wpdb_prepare with multiple or condition
  35. Adding new row to wp_post table
  36. WordPress Install and Database on separate hosting?
  37. SQL Error wp_commentmeta – incorrect table definition
  38. WordPress database error – Error in SQL syntax – I can’t identify any error?
  39. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  40. How do I get the posts within a certain year/date(with sql query)?
  41. Using GROUP CONCAT in my-sql query with wp_usermeta table
  42. Create table from array with prepare
  43. How to prevent/delay MySQL connections when an object cache is used?
  44. Migrating from PDO using SQLite to clean new install using MySQL
  45. Migration: Copying database content to a different server
  46. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  47. Duplicated site isn’t recognized as a site
  48. Query multiple tables at once?
  49. Have working sql query… trying to adjust it to use $wpdb
  50. Changing root password in PHPMyAdmin for WordPress Database when going live
  51. How to properly check if a table exists in WordPress Database using Show Tables Query
  52. Can’t update WordFence Options, clear data manually
  53. creating new field on mysql
  54. Remove empty rows from the database
  55. Custom WordPress Table wpdb
  56. How and where is wordpress adding mySQL content to database?
  57. how to encyrpt DB_PASSWORD in wp-config
  58. SQL query to set posts in bulk based on the post content
  59. How to create more than one new wpdb object?
  60. How to connect and insert data in database of wordpress?
  61. Files on Localhost, Database on Server
  62. Remote database -> massive response time increase?
  63. Second ezSQL initialization for MSSQL
  64. Fetch a single row from a custom table for to a given ID
  65. Database create or redirect
  66. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  67. Cloning blog to localhost via WAMP
  68. Counting post and changing roles in mysql database. Query not code
  69. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  70. DB prefix not updating
  71. Recovery – Restore Database after moving folder location locally
  72. Replacing javascript link in WordPress database without getting mysql syntax errors
  73. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  74. How to edit custom table data in frontend
  75. local wordpress broke after changing URL
  76. how to access 2nd Mysqli Database from different server for wordpress
  77. Error establishing a database connection – WordPress setup, everything else is working
  78. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  79. How to map data on CSV to web pages?
  80. How to create index (sql) to a meta_key?
  81. Search and Replace in Windows XAMPP site
  82. WPCLI search and replace in a particlar site dir effect another site-dir
  83. How can i syn wordpress user table with a stand-alone php script?
  84. insert data from a form:: Warning Empty query mysqli::query()
  85. How can I get $wpdb to show MySQL warnings?
  86. After renaming MySQL database, I can no longer access my Blog page
  87. WordPress Database Posts Table query
  88. Hang Up Followed By Can’t select database
  89. How to extract some part of WordPress full source code
  90. Mysql Queries per Visit – Crazy High
  91. Create a new table on the database and save parameters from a contact form
  92. Why is converting my database to UTF-8 truncating entries?
  93. using same mysql user with many databases
  94. Why are my WordPress post queries so slow?
  95. How to back-up a database on IIS
  96. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  97. export individual posts to text files or a single csv file
  98. Custom wordpress SQL statement for a website
  99. How to find fresh (last modified) and sql backup?
  100. Uploading to WordPress Database
error code: 523