Commands out of sync; you can't run this command now

The first thing to try is to take the semi-colon ( ; ) out of the query:

PHP Code:

$auth = $this->db->query("CALL sp_authenticate('{$username}')"); 


If that change does not fix the issue or change the error you're receiving, then you may also need to free the result before modifying the session. This should be as simple as calling $auth->free_result() before returning from authenticate_user(), but you'll have to make sure you've retrieved any data you need from the result before doing so.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide