+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Database Error: 2014 (/showthread.php?tid=62549)
Database Error: 2014 - sammyci - 07-27-2015
Yes, it is related to MySQL.... i am trying to bring a library used in an app written using classic PHP. There is a search script that runs two queries at times, based on request. In that case the error comes up.
We never had a problem with the library before but then it was on a PDO envrionment. I am not very familiar with CI to go on change it to be PDO compatible right now nor have time.
I tried freeing the first result set by $query->free_result();.
The codes call stored procuederss:
PHP Code:
$result=$this->CI->db->query('CALL Spec()');
if($result->num_rows()>0){
$row=$result->row();
$totalRecord=$row->total;
}
else {//no result.
die("quit");
}//no result or error
//FREE RESULT
$result->free_result();
If it continues, then a similar query but SELECT field...in nature is expected to run but it just stops with error 2014. Where am I supposed to free the query?
RE: Database Error: 2014 - raknjak - 03-29-2017
for PDO you have to enter a dsn in config/database.php.
And/or using php-mysqlnd seems to help.