Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHP5 SQLite3 recompile for UPDATE, DELETE LIMIT

I need recompile SQLite3 with CFLAG:

SQLITE_ENABLE_UPDATE_DELETE_LIMIT

as is written in How do you enable LIMIT for DELETE in SQLite?:

tar xzf sqlite-3.6.20.tar.gz
cd sqlite-3.6.20
export CFLAGS='-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1'
./configure
make

compilation were done with no errors.

but PHP5 still ends with:

Warning: SQLite3::query() [sqlite3.query]: near "LIMIT": syntax error in /var/www/xxx.php on line 987
like image 257
user5332 Avatar asked Nov 13 '22 12:11

user5332


1 Answers

There is a step missing from this process,

make install

This should come after make. This will install the library to the right place on your system.

like image 69
Jon Cairns Avatar answered Nov 16 '22 03:11

Jon Cairns