Ali Abbas

Weather it is installing a software or recompiling a package, dependencies/libraries problems are always around the corner to make the life of a sys admin more complicated than it is.

This Howto is more of a fix type than an overview on how to configure Sqlite. One day I was confronted to the challenge to install sqlite on a server when I got this error after compilation “offset error”

To fix the problem, I have edited the sqlite.c file… looked for the method

static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE };

then commented it out like this

// static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE };

I have then followed to replace

function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, arg3_force_ref)
PHP_FE(sqlite_popen, arg3_force_ref)

with

function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, third_arg_force_ref)
PHP_FE(sqlite_popen, third_arg_force_ref)

Save the file, recompile and install with make / make install

and voila proceed to normal install.

cheers,