search

bcosca / fatfree

A powerful yet easy-to-use PHP micro-framework designed to help you build dynamic and robust Web applications - fast!
2.66k stars 446 forks source link

sqlite database issue: PDO: no such table: pragma_table_info #1223

Open labsterx opened 3 years ago

labsterx commented 3 years ago

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.

jauninp commented 3 years ago

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