Arch Linux

skazhy

Member

From: Riga, Latvia

Registered: 2009-07-01

Posts: 46

Sqlite and php problems

Hi!

I, i am having problems with sqlite. The database file is ok (checked some queries in console with sqlite3 command) but I cant get it working with php!

Here are some parts from my php.ini:

;extension=bcmath.so
;extension=bz2.so
;extension=calendar.so
;extension=curl.so
;extension=dba.so
;extension=enchant.so
;extension=exif.so
;extension=ftp.so
;extension=gd.so
extension=gettext.so
;extension=gmp.so
;extension=iconv.so
;extension=imap.so
;extension=intl.so
;extension=json.so
;extension=ldap.so
extension=mcrypt.so
extension=mysql.so
;extension=mysqli.so
;extension=odbc.so
;extension=openssl.so
extension=pdo.so
;extension=pdo_mysql.so
;extension=pdo_odbc.so
;extension=pdo_pgsql.so
extension=pdo_sqlite.so
;extension=pgsql.so
;extension=phar.so
;extension=posix.so
;extension=pspell.so
;extension=shmop.so
;extension=snmp.so
;extension=soap.so
;extension=sockets.so
extension=sqlite.so
extension=sqlite3.so
;extension=sysvmsg.so
;extension=sysvsem.so
;extension=sysvshm.so
;extension=tidy.so
;extension=xmlrpc.so
;extension=xsl.so
;extension=zip.so

;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[sqlite]
; http://php.net/sqlite.assoc-case
;sqlite.assoc_case = 0

[sqlite3]
;sqlite3.extension_dir =

[Pcre]
; http://php.net/pcre.backtrack-limit
;pcre.backtrack_limit=100000

;PCRE library recursion limit. 
;pcre.recursion_limit=100000

[Pdo]
;pdo_odbc.connection_pooling=strict

and with the php function phpinfo() i get these lines for sqlite3:

SQLite
SQLite support    enabled
PECL Module version     2.0-dev $Id: sqlite.c,v 1.166.2.13.2.9.2.22 2009/06/25 09:38:04 johannes Exp $
SQLite Library     2.8.17
SQLite Encoding     UTF-8

Directive    Local Value    Master Value
sqlite.assoc_case    0    0

sqlite3
SQLite3 support    enabled
SQLite3 module version     0.7-dev
SQLite Library     3.6.19

Directive    Local Value    Master Value
sqlite3.extension_dir    no value    no value

There is no directory set for sqlite3 extensions. Is that the problem? If so, what is the dir?

Thanks in advance,

-skazhy