[solved please delete]help with error : supplied argument is not a valid MySQL result resource

[eluser]quasiperfect[/eluser]
please delete this is found the problem
i have another query on top

Code:

$this->db->query("CALL delete_messages();");

that is triggering the error messages
using simple_query it works

hi

i have a error in my logs

Code:

ERROR - 2010-09-16 11:23:05 --> Severity: Warning  --> mysql(): supplied argument is not a valid MySQL result resource C:\wamp\www\final\system\database\drivers\mysql\mysql_result.php 37

i use ci2

i found the function and model that produces the error but is nothing wrong there
the query returns the results correctly and everything works but this keeps appearing in the logs so is confusing

i run the generated query in phpmyadmin and it works ok

i can't use simple query because i return results and use the results

my code is

Code:

$query = $this->db->query("my query here");
$myerror = $this->db->_error_message();
if ($myerror)
{
    log_message('error','Hmm problem :'.$myerror);
}
else
{
    if ($query->num_rows() > 0)
    {
        //do something
    }
    else
    {
        //do something else
    }
}