PHP and ADODB execution calls return false

Question

I'm using ADODB 5.21.2 and PHP 7.4. I get the error "Command out of sync; you cannot run this command now when executing a query. My database is MySQL 5.7 and I am using the mysqli driver. This problem only occurs on one of my servers. The query works Running on 10 other servers. Confused. Any help would be greatly appreciated. Call the execute method to execute the insert SQL.

$rs = $glb_dbconn->Execute($sql);

I am expecting a result set to be returned. However, the execution returns "false". I also tried running a select query that actually returns a result set. Even this fails with the same error.

Answer 1

This was discussed in the

ADOdb support chat on Gitter.

Users report that the issue is caused by a bug in their code, possibly due to executing a new query without using the results of the previous query, as

MySQL Documentation.