Page 1 of 1

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

Posted: Fri Mar 15, 2024 3:38 am
by 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


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

Posted: Fri Mar 15, 2024 10:16 am
by arbei

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


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

Posted: Fri Mar 15, 2024 11:31 pm
by 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


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

Posted: Sat Mar 16, 2024 10:13 am
by arbei

You may enable Debug and check the log files.