Updating with $qpdb->query() always returns 0 rows affected

wpdb uses PHP’s mysqli_affected_rows() or mysql_affected_rows(), which can be disabled via an argument in php.ini. I am guessing that that is what has happened. Check the disabled_functions line in your php.ini file and remove the references to those function.

Of the top of my head, I am not sure if extensions like Suhosin mess with that function but that is certainly possible.

Related Posts:

  1. Multipart/formatted MySQL query problem
  2. wpdb COALESCE won’t work
  3. Get posts from category with custom query
  4. Valid SQL query return empty
  5. mysql query – how to escape apostrophe?
  6. How to return count of custom post type posts with a specific custom field value via $wpdb?
  7. WordPress Mysql query and Duplicate
  8. Help with Related Posts Function
  9. Mysql query and odd results
  10. Return only Count from a wp_query request?
  11. Differences between wpdb->get_results() and wpdb->query()
  12. simple sql query on wp_postmeta very slow
  13. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  14. wpdb get posts by taxonomy SQL
  15. How many WordPress SQL Queries per page?
  16. Custom $wpdb Query for Custom Post Type by Category
  17. Can’t pass table to $wpdb->prepare
  18. $wpdb->get_var not returning a result
  19. Are database queries created using WordPress filters protected from SQL injection?
  20. Most effective use of DB querys
  21. Grouping related postmeta data via SQL query
  22. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  23. Mysql / WordPress killing my server with 80k users [closed]
  24. Slow meta_query with about 4 milion record on wp_postmeta
  25. wpdb::prepare() isn’t working
  26. Select User by Joining Multiple Meta Value Results
  27. mySQL query. ORDER BY meta_key
  28. $wpdb doesn’t appear to work on page inside of a plugin
  29. Strange string in console from wpdb query
  30. Using $wpdb->update but confused on the WHERE in and SET
  31. Update slug (URL) of pending posts via phpMyAdmin
  32. My SQL function to change user_name
  33. You have an error in your SQL syntax – Help with query
  34. What’s wrong with my $wpdb prepare?
  35. Make one query for adding entries to database
  36. Why is variable not working on custom sql query using wpdb?
  37. MySQL variable in query
  38. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  39. Alter a specific query on WordPress
  40. Advanced SELECT query with condtional statements
  41. how would I create a custom query to get all users, and a related post based on a postmeta field?
  42. Help with MySQL to $WPDB query
  43. SQL query to select posts from multiple categories
  44. How do I see the mysql query generated by get_posts( $args )?
  45. Alter query with posts_clauses to retrieve NULL values last
  46. wpdb->term_taxonomy count posts from both published and private posts?
  47. wpdb print all post meta
  48. Plugin will sort users by usermeta
  49. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  50. MySql Query very slow
  51. Searching With Apostrophe
  52. wpdb query problem to access previous 3 days posts
  53. WordPress Query wp-terms SLOW
  54. How to write: $wpdb->update having WHERE NOT value pair in the array
  55. I can’t figure out what’s wrong with this statement. $wpdb->query update
  56. Use mysql_query instead of $wpdb query
  57. Custom Query – Based on user input
  58. Custom WordPress Table wpdb
  59. Custom SQL Query passing array to WHERE p.id
  60. Best practice to limit results in get_row()?
  61. Placing a widget with $wpdb query
  62. Custom Query returns array, but I can’t see it’s elements
  63. how to insert missing tags into the posts through mySQL?
  64. Ideas how to search & replace post_content when string contains a newline?
  65. Query Column of Specific ID from Database Table
  66. Query the WordPress database to get data together with replaced information
  67. $wpdb->prepare affecting the query?
  68. Optimize slow SQL query for multiple meta values
  69. prepare function sql safe method
  70. WordPress Insert not working with ajax
  71. How do I query for posts by custom meta and those that have been stickied?
  72. wpdb update multiple row?
  73. Formatting a date/time returned from a custom $wpdb query
  74. Improve performance of slow query
  75. How to delete all images from code in all post_content
  76. How do I get specific readable results from this query and array results
  77. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  78. Delete oldest wordpress post (SQL query)
  79. Displaying data from custom table
  80. Get 2 meta values from meta key column
  81. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  82. SQL query to delete users with multiple meta keys and comments
  83. WordPress Database Query works in phpMyAdmin but not in the code
  84. OR condition not working
  85. Trouble migrating custom post types from non-wordpress cms
  86. implementing my wp_query using $wpdb class
  87. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  88. Exclude Posts from a Widget
  89. Fastest and most efficient SQL query to check if UID exists
  90. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  91. How to make MySQL search queries with quotes
  92. Use $wpdb->get_results with filter based on array
  93. $wpdb query for price in custom field value
  94. Display result from custom post meta query
  95. Wpdb empty result only if language is Russian
  96. Run an update query in a function
  97. How to fix this insert? Don’t work for me!
  98. Function returning queried meta value based on current post ID
  99. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  100. Update vs Insert logic but the last key is always inserted?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)