XF 2.0 MySQL statement prepare error

[Tommi Gustafsson]

Hi!

I am trying to execute the following command in my uninstall step:

$this->db()->query('DROP EVENT update_and_delete_download_list_items;');

But I get

[XF\Db\Exception]
MySQL statement prepare error [0]:

I was able to get some connection debug info as follows:
client_info:"mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $"
client_version:50012
connect_errno:0
connect_error:null
errno:1295
error:"This command is not supported in the prepared statement protocol yet"
error_list:array(0)
field_count:9
host_info:"127.0.0.1 via TCP/IP"
info:null
insert_id:0
server_info:"5.7.22-log"
server_version:50722
stat:"Uptime: 193423 Threads: 4 Questions: 39692 Slow queries: 0 Opens: 2414 Flush tables: 1 Open tables: 1075 Queries per second avg: 0.205"
sqlstate:"00000"
protocol_version:10
thread_id:847
warning_count:0

What does it mean that "This command is not supported in the prepared statement protocol yet"? When I try to run the query in MySQL Workbench, it works perfectly fine. How can I run this query for my addon? There is also a create event query that I need to run in an install step.

Thanks for any help!
Tommi

 

[Tommi Gustafsson]

I found the answer:
I had to use ->rawQuery() instead of ->query()

Best regards,
Tommi