php sqlite_PHP: SQLite (PDO) - Manual

最新推荐文章于 2022-10-29 20:16:18 发布

远赴惊鸿人间舞

最新推荐文章于 2022-10-29 20:16:18 发布

阅读量121

点赞数

文章标签： php sqlite

本文链接：https://blog.csdn.net/weixin_33781072/article/details/115106358

版权

SQLite PDO 错误修复文件格式 PHP源码

关键词由CSDN通过智能技术生成

Issue:

Error: SQLSTATE[HY000]: General error: 1 unsupported file format

Resolution:

To solve this (and/or many issues) involving this type of error, I assumed the error to be generated from php. Well, it was to an extent. The sqlite pdo code offered the solution:

I researched the error by grep'ing the php source code and found the error string to come from php-5.1.4/ext/pdo_sqlite/sqlite/src/prepare.c, lines 265:278 :

** file_format==1 Version 3.0.0.

** file_format==2 Version 3.1.3.

** file_format==3 Version 3.1.4.

** Version 3.0 can only use files with file_format==1. Version 3.1.3

** can read and write files with file_format==1 or file_format==2.

** Version 3.1.4 can read and write file formats 1, 2 and 3.

if( meta[1]>3 ){

sqlite3BtreeCloseCursor(curMain);

sqlite3SetString(pzErrMsg, "unsupported file format", (char*)0);

return SQLITE_ERROR;

}

This is interesting as I am running SQLite version 3.3.5 which the databases were created in. I see that the SQLite PDO source in the php source is :

# cat ext/pdo_sqlite/sqlite/VERSION

3.2.8

My solution was then to find a version of sqlite that was =< 3.1.4. I found source for 3.1.3, compiled, recreated my database using that version (NOTE: the databases are unsupported between 3.1.x and 3.2.x versions of SQLite). Once I did this it worked.

Also as a side note, to get SQLite compiled as a PDO, I had to:

1) configure with

...

--enable-pdo=shared \

--with-sqlite=shared \

--with-pdo-sqlite=shared

--with-zlib

... \

'make && make install' if configure is successful.

2) Make sure the pdo libs were copied/installed to the correct directory. On my installation it was /usr/local/include/php/ext/pdo/

3) Make these changes in my php.ini:

- change ' extension_dir = "./" ' to ' extension_dir="/usr/local/include/php/ext/pdo/" '