Especially if you are using database sessions with CodeIgniter, you should be aware that if you call a stored procedure, any query after the call with give you the Commands Out of Sync error:
Error Number: 2014
Commands out of sync; you can’t run this command now
— The query after your procedure call —
Line Number: 247
Reproduce the Error
To reproduce the error I just created a simple stored procedure that selects all the users in Community Auth’s users table:
DELIMITER $$ CREATE PROCEDURE `get_all_users` () BEGIN SELECT * FROM users; END $$
Then, in my application I call it:
$query = $this->db->query('CALL get_all_users()');
When I request the page where this is run, I get the commands out of sync error.
To fix this, I simply add the following line after the procedure call:
mysqli_next_result( $this->db->conn_id );
The error goes away.