Can't select database after calling stored procedure. - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Can't select database after calling stored procedure. (/showthread.php?tid=56579) |
Can't select database after calling stored procedure. - El Forum - 01-04-2013 [eluser]browntown[/eluser] I have recently stumbled onto an issue with stored procedures in CodeIgniter. I've used stored procedures with CodeIgniter projects before...never had a problem...until now. I am able to call a stored procedure once...then I get an error stating: Code: A Database Error Occurred Once this happens I have to restart Apache before I can hit the site again. I'm using the mysqli driver and a persistent database connection. I'm calling the stored procedure from the following code in my model: Code: $this->db->reconnect(); Does anyone have any ideas? Thanks. Can't select database after calling stored procedure. - El Forum - 01-04-2013 [eluser]browntown[/eluser] Two things: 1) I'm an idiot 2) I really needed to get some sleep. Once I had time to sleep, shower, and eat breakfast I realized what my issue was. My app is using CI Bonfire. CI Bonfire puts the database config in a "development" sub directory when you're developing your app. I had changed the wrong database config to use the mysqli driver. I updated the correct config file and everything is working fine. |