Arch Linux

creo

Member

From: Krakow, Poland

Registered: 2005-10-19

Posts: 13

SQLite and PHP problem

I would like to use sqlite databae on my php scripts, but I'v go following problems by enabling this module.

I've wrote simple script:

$db = sqlite_open('data.db')

and its result is:

Fatal error: Call to undefined function sqlite_open()

I've tried to edit php.ini and uncomment following lines

extension=sqlite.so
extension=pdo_sqlite.s

but it doesn't help And worse, runnig php -v results with:

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/php/pdo_sqlite.so' - /usr/lib/php/extensions/php/pdo_sqlite.so: undefined symbol: php_pdo_unregister_driver in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/php/sqlite.so' - /usr/lib/php/extensions/php/sqlite.so: undefined symbol: php_pdo_unregister_driver in Unknown on line 0
PHP 5.1.4 (cli) (built: May 27 2006 13:43:35) 
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

BTW: I'm using: php 5.1.4-4

creo

Member

From: Krakow, Poland

Registered: 2005-10-19

Posts: 13

Re: SQLite and PHP problem

Found it!

Just need to uncomment:

extension=pdo.so

So simple

raylu

Member

From: Western Hemisphere

Registered: 2009-05-30

Posts: 1

Website

Re: SQLite and PHP problem

Sorry for the mega-bump, but this saved me just now.

I think that this is definitely less than intuitive. Optional dependencies for php mention "sqlite3: pdo_sqlite", but that's it. I suppose this is more of a problem with PHP than ArchLinux, though.

SamC

Member

From: Calgary

Registered: 2008-05-13

Posts: 611

Website

Re: SQLite and PHP problem

Please, don't restart three-year-old threads.