fatfree icon indicating copy to clipboard operation
fatfree copied to clipboard

trigger a strange PDO syntax error

Open landall opened this issue 3 months ago • 7 comments

Server: CentOS 7 PHP 7.4.33 SQLite version 3.7.17 Cli & Apache mode all trigger it.

vendor/bcosca/fatfree-core/db/sql.php:268 report this error.

I insert a var_dump($cmd) in line 183.

Output is: string(137) "SELECT * FROM pragma_table_info('Versions') JOIN (SELECT sql FROM sqlite_master WHERE (type='table' OR type='view') AND name='Versions')"

The Output in Windows 10 & PHP 7.4.19 is: string(137) "SELECT * FROM pragma_table_info('Versions') JOIN (SELECT sql FROM sqlite_master WHERE (type='table' OR type='view') AND name='Versions')"

It reports PDO: near "(": syntax error in CentOS 7 but works in Windows.

landall avatar Apr 01 '24 18:04 landall