Dotaz: PHP a SQLite error

[wr]

Snazim se nainstalovat modul SQLite na PHP v5.1.6

# pecl install SQLite-1.0.3.tgz

Ale pri kompilaci to hlasi chybu. Zkousel jsem to opravit pomoci http://pecl.php.net/bugs/bug.php?id=9742

downloading SQLite-1.0.3.tgz ...
Starting to download SQLite-1.0.3.tgz (371,189 bytes)
............................................................................done: 371,189 bytes
50 source files, building
running: phpize
Configuring for:
PHP Api Version:         20041225
Zend Module Api No:      20050922
Zend Extension Api No:   220051025
building in /var/tmp/pear-build-root/SQLite-1.0.3
running: /tmp/tmptWsQKe/SQLite-1.0.3/configure
checking for egrep... grep -E
checking for a sed that does not truncate output... /bin/sed
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking whether gcc and cc understand -c and -o together... yes
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... i686-redhat-linux-gnu
checking host system type... i686-redhat-linux-gnu
checking target system type... i686-redhat-linux-gnu
checking for PHP prefix... /usr
checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM 
-I/usr/include/php/Zend -I/usr/include/php/ext
checking for PHP extension directory... /usr/lib/php/modules
checking for PHP installed headers prefix... /usr/include/php
checking for re2c... no
configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for sqlite support... yes, shared
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for char *... yes
checking size of char *... 4
checking for usleep... yes
checking for nanosleep... yes
checking time.h usability... yes
checking time.h presence... yes
checking for time.h... yes
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for epcf90... no
checking for f95... f95
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether f95 accepts -g... yes
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
checking for f95 option to produce PIC... -fPIC
checking if f95 PIC flag -fPIC works... yes
checking if f95 static flag -static works... yes
checking if f95 supports -c -o file.o... yes
checking whether the f95 linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
configure: creating ./config.status
config.status: creating config.h
running: make
/bin/sh /var/tmp/pear-build-root/SQLite-1.0.3/libtool --mode=compile gcc -I/tmp/tmptWsQKe/SQLite-1.0.3/libsqlite/src -I.
-I/tmp/tmptWsQKe/SQLite-1.0.3 -DPHP_ATOM_INC 
-I/var/tmp/pear-build-root/SQLite-1.0.3/include 
-I/var/tmp/pear-build-root/SQLite-1.0.3/main 
-I/tmp/tmptWsQKe/SQLite-1.0.3 -I/usr/include/php 
-I/usr/include/php/main -I/usr/include/php/TSRM 
-I/usr/include/php/Zend -I/usr/include/php/ext  -DHAVE_CONFIG_H  -g
 -O2   -c /tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c -o sqlite.lo
mkdir .libs
 gcc -I/tmp/tmptWsQKe/SQLite-1.0.3/libsqlite/src -I. 
-I/tmp/tmptWsQKe/SQLite-1.0.3 -DPHP_ATOM_INC 
-I/var/tmp/pear-build-root/SQLite-1.0.3/include 
-I/var/tmp/pear-build-root/SQLite-1.0.3/main 
-I/tmp/tmptWsQKe/SQLite-1.0.3 -I/usr/include/php 
-I/usr/include/php/main -I/usr/include/php/TSRM 
-I/usr/include/php/Zend -I/usr/include/php/ext -DHAVE_CONFIG_H -g 
-O2 -c /tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c  -fPIC -DPIC -o .libs/sqlite.o
/tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c:56: error: 'BYREF_NONE' undeclared here (not in a function)
/tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c:56: error: 'BYREF_FORCE' undeclared here (not in a function)
/tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c:125: warning: initialization from incompatible pointer type
/tmp/tmptWsQKe/SQLite-1.0.3/sqlite.c:126: warning: initialization from incompatible pointer type
make: *** [sqlite.lo] Error 1
ERROR: `make' failed

Dokonce jsem to zkusil druhym zpusobem:

tar xfz php-5.2.4.tar.gz 
cd php-5.2.4/ext/sqlite
phpize
./configure --enable-sqlite-utf8
make
make install

sqlite.so by se melo nainstalovat do /usr/lib/php/modules
Diky za jakoukoliv radu!

Odpovědi

[H0ax]

Nejprve bych zacal s instalaciphp-pecl-sqlite
Pak bych ztahnul SQLite primo

$ pear download sqlite
$ tar zxvf SQLite-1.0.3.tgz
$ cd SQLite-1.0.3
$ phpize
$ ./configure
$ make

Pokud se to nepovede tak udelat nasledujici,
edituj sqlite.c a zakomentuj:

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

Zmeni nasledujici radky:

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

Potom uz jen

$ make
$ make install
$ cp modules/sqlite.so /usr/lib/php/modules
$ service httpd restart

Je to bug a potomhle by to melo fungovat.

[wr]

Jeste problem, kdyz volam:

$db = new SQLiteDatabase("my.db", 0666, $error) or die("Failed: $error");

Hodi to chybu Fatal error: Class 'SQLiteDatabase' not found.
Procedulatni verze zato chodi skvele:

$db = sqlite_open("my.db", 0666, $error) or die("Error: ".$error);

Po mensim hrani si s PDO jsem to zkopiloval takto:

POD ./configure --with-zlib --enable-pdo=shared --with-pdo-sqlite=shared --with-sqlite=shared
SQLite ./configure --with-sqlite=shared

Ale porad to hlasi tu chybu, ze nemuze najit tridu SQLiteDatabase. Co s tim?

[wr]

Volani do ztracena: Je tu nejaky PHP programator ktery by mi pomohl vyresit problem uvedeny vyse??

[wr]

Prosim pomuze nekdo???