WordPress(wpdb class) and mysql stored procedures

wpdb detects the type of query and returns the result if it starts with select, else the affected rows. Since yours starts by call, it’s probably mistaking it for an insert, update, delete, etc. statement.

Try this (might trick wpdb into thinking it’s a select statement:

/* select */ call ...;

Or this (not sure the mysql parser will like it):

select * from ( call ... );

If all else fails (and even if not), consider opening a ticket in the wp trac.

Related Posts:

  1. How do you properly prepare a %LIKE% SQL statement?
  2. $wpdb and MySQL Create Trigger
  3. wpdb->prepare function remove single quote for %s in SQL statment
  4. Alternative to mysql_real_escape_string
  5. Increment value (value = value+1) of $wpdb->update
  6. wpdb Custom Meta Data with 2 conditions
  7. wpdb prepare syntax
  8. SQL query not working in alphabetical post title/content search
  9. MySQL LIKE not working
  10. Proper way to work with wpdb to get user’s firstname
  11. How to check for empty and not a failure
  12. Database: Custom table: sprintf value for DateTime column
  13. Converting mysql to $wpdb
  14. WP_USE_EXT_MYSQL
  15. wpdb insert and boolean fields
  16. Join new table with SQL query
  17. writing inner join in wpdb
  18. How to split the a table in database?
  19. MySQL Rank & $wpdb
  20. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  21. How do I join a $wpdb query with user meta using default value if not exist?
  22. How to translate this mySQL query to $wpdb query
  23. $wpdb select all meta for each post
  24. $wpdb to insert html form information
  25. Proper usage of $wpdb->update()?
  26. Can’t run database query
  27. Using WPDB->Insert()
  28. Active DB queries in WordPress?
  29. How to stop $wpdb from prepending database name
  30. WordPress $wpdb get posts from category and sort by custom meta
  31. How to get INSERT errors from $wpdb?
  32. Getting Error Trying to Create Table
  33. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  34. Understanding custom php that reads from WP MYSQL
  35. How to insert dash (-) into database using wpdb and new_to_publish hook?
  36. $wpdb->get_var multiple queries in one database check
  37. List users with the most posts in the last 30 days
  38. Insert two row in wordpress database
  39. WordPress $wpdb no result
  40. PHP variables in mysql query
  41. MySQL ‘duplicate entry’ error
  42. User set date and time from frontend doesn’t get stored into database
  43. Wpdb query with dynamic table name
  44. get posts whether meta_key exists or not
  45. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  46. How to search usermeta table
  47. How to add virtual column in wpdb get_result statement
  48. wpdb insert into point column in db
  49. WPDB delivers wrong results from complex queries
  50. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  51. CONCAT_WS in custom sql query
  52. Geographical proximity query using post_meta
  53. MySQL Select within WP Page template
  54. Saving custom term value to the database in new table
  55. why is $wpdb->update() causing a DB error from within wp_set_password()
  56. $wpdb->get_var returns 0
  57. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  58. Cannot add or update a child row: a foreign key constraint fails
  59. Rename a column in MySQL
  60. Not unique table/alias
  61. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  62. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  63. Disable ONLY_FULL_GROUP_BY
  64. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  65. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  66. difference between primary key and unique key
  67. MySQL Error #1133 – Can’t find any matching row in the user table
  68. How can I prevent SQL injection in PHP?
  69. Best way to store an array in MySQL database?
  70. MySQL date formats – difficulty Inserting a date
  71. How to check if mysql database exists
  72. #1062 – Duplicate entry for key ‘PRIMARY’
  73. Optimize WordPress Query that take 5 seconds to execute
  74. MySQL Replication Latency Issues in wp-admin pages
  75. Multipart/formatted MySQL query problem
  76. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  77. Importing MariaDB into Mysql in WordPress
  78. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  79. Update a WordPress post or page takes 60+ seconds
  80. add_post_meta does not respect the content
  81. Show MySQL errors that occur when I excute $wpdb->insert()
  82. Select multiple wp_postmeta keys with single select
  83. Help with a $wpdb MySQL Query
  84. Is it possible to create a WordPress table using array and loop?
  85. Match tag names with form titles
  86. Error missing MySQL extension
  87. How can I add a new row in a separate database when someone registers via WordPress?
  88. Why doesn’t custom mysql query return results? Is syntax correct?
  89. SQL statement using placeholder is not returning results
  90. “BS_” rows in postmeta table
  91. Regular XML-RPC timeouts
  92. update multiple rows in mysqli table base on two values
  93. How to write in MySQL more characters in user_nicename
  94. Advanced WordPress SQL Query
  95. How To connect to the same WordPress database with different database user
  96. $wpdb->get_var not returning count
  97. Custom user query – orderby meta_key (that may not exist)
  98. MySQL query in WordPress with AJAX
  99. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  100. How do I load a sql.gz file to my database? (importing)