I had this problem. I am trying to add information to the table. But the browser gives an error

"No Data Received"

I use SQLite. The insert is primitive:

$db->exec("INSERT INTO mapseasy VALUES ('TEST2', 'TEST', '1234')");

Immediately open this database through SQLite Manager and add it manually - everything is fine. I think the problem is that I have several triggers. And they (AFTER INSERT) block something or interrupt ... I tried various options for several hours, nothing helps. And in the directory where the database is located, a file with the extension .sqlite-journal is created. It takes about 2 minutes, the file is deleted, the browser returns a blank page.

I think that this file is created when a very complex query is sent to the database? But my request is primitive, and the time for executing triggers on the PC is spent very little, maybe there is some restriction on the server?
I would be grateful if you tell me something. Thank.

Guys, I still read. They write that SQLite blocks the base for a single user. That is, it turns out that I am making a request from the site (php file), and the triggers are executed on behalf of the system user? Maybe this is why a conflict arises?

    1 answer 1

    The query does not list the fields that are inserted, it should be like this:

     INSERT INTO mapseasy (field1, field2, field3) VALUES ('TEST2', 'TEST', '1234');
    • No, that's not the point ... - istimbi
    • one
      If not in this, then the fortune-telling on the coffee grounds ... Or you need to lay out all the triggers so that you can find the cause, although the matter is unlikely in them, because they would work with manual insertion - Isaev
    • I figured it out. The topic can be closed. The problem is in multi-user access to the database file. - istimbi