PHP version :5.5 SQLite version :3.8
the code i use:
try {
      $dbh = new PDO('sqlite:'.MF_DB_PATH.MF_DB_FILE);
      $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
} catch(PDOException $e) {
      $error_connecting =  "Error connecting to the database: ".$e->getMessage();
      $pre_install_error = $error_connecting;
    }
$query = "INSERT INTO forms_backup SELECT * FROM forms;";
$params = array();
$sth = $dbh->prepare($query);
try{
    $sth->execute($params);
}catch(PDOException $e) {
    $post_install_error .= $e->getMessage().'<br/><br/>';
}
$query = "DROP TABLE forms;";
$params = array();
try{
    $sth->execute($params);
}catch(PDOException $e) {
    $post_install_error .= $e->getMessage().'<br/><br/>';
}
error message: SQL: [20] DROP TABLE forms; Params: 0 Query Failed: SQLSTATE[HY000]: General error: 6 database table is locked
 
Aucun commentaire:
Enregistrer un commentaire