sqlite failed to execute SQL Error:1 (1) in production server not in dev (v2020)

[mgqz]

Hello, I am having an issue with this using a simple phpm 2020 app of 4 tables so using sqlite, the problem is that in linux production server event the app works, and show data and the tables etc suddenly gives the above error, seems it starts when using a add form that need to populate a dropdown select from a table data.

Does anyone know how can debug this and check ?

thanks

[arbei]

Make sure the web server uses has write permission to the folder the sqlite database.

[mgqz]

Thank you the server has, as it show or let add data etc, from the phpm app but it appear randomly, any way to debug the origin of the error.

thanks

[arbei]

You may enable Debug and check the log files.