php - How to prevent SQLITE SQLSTATE[HY000] [14]?

Question

I receive sometimes the following error:

SQLSTATE[HY000] [14] unable to open database file

I open the datebase by using

new PDO("sqlite:database/datbase.db","","",array(
    PDO::ATTR_PERSISTENT => true
));

everytime I want read or write data from or to the database. The open process is the following function:

function opendatabase(){
try{
    return new PDO("sqlite:database/database.db","","",array(
        PDO::ATTR_PERSISTENT => true
    ));
}catch(PDOException $e){
    logerror($e->getMessage(), "opendatabase");
    print "Error in openhrsedb ".$e->getMessage();
}
}

After some time (sometime more than an hour, some times after some minutes I get the error message at the beginning of the post. How can I prevent such error?

Answer 1

If anyone is having the same message while reusing the PDO connection and still having problems, it might be because you're storing images you get from fopen() and forgot the fclose() statement. In this particular case, the error message is really misleading. Here's a question for the same error message that I managed to solve after a few days of troubleshooting. SQLSTATE[HY000] [14] : can't open database because too many connections are already opened