fatfree icon indicating copy to clipboard operation
fatfree copied to clipboard

sqlite database issue: PDO: no such table: pragma_table_info

Open labsterx opened this issue 3 years ago • 1 comments

This is for fatfree version 3.7.

When connecting to a sqlite database created with an older version of sqlite3 (for example, v 3.11.0 of sqlite3 on ubuntu), there will be an Internal Server Error with error message "PDO: no such table: pragma_table_info".

As it turned out, databases created by older versions of sqlite3 doesn't have the "pragma_table_info" table.

I don't think this table is critical for most applications using sqlite.

Therefore, I hope fatfree can ingore the missing table "pragma_table_info" so that it can be compatible with older version of sqlite databases.

labsterx avatar May 09 '21 04:05 labsterx

I have the same issue, but I try this command and It's working : pragma table_info("tableName");

jauninp avatar Nov 08 '21 13:11 jauninp