No, I can't upgrade to PHP5, yet. We're on PHP4.
Brandon Eley
[EMAIL PROTECTED]
On May 10, 2007, at 9:04 AM, Chris Peachment wrote:
I think I have misread your original posting.
Can you upgrade your version of PHP?
I use PHP version 5.2.1.
Running phpinfo() reveals the PDO driver to be:
PECL version: 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.1 2007/01/01
09:36:05 sebastian Exp $
Sqlite Library: 3.3.7undefined
Since you can run sqlite3 against the database without issue,
it appears that the version embedded in PHP is the problem.
Chris Peachment
------------------
On Thu, 10 May 2007 08:46:30 -0400, Brandon Eley wrote:
Thank you for this information. How would I access the 2.8.x database
from within PHP? is it even possible?
The database is created from a shopping cart program, so I can't
upgrade it, it has to remain the same version (for now).
Brandon Eley
[EMAIL PROTECTED]
On May 9, 2007, at 10:59 PM, Chris Peachment wrote:
There was a change of file structure with version 3.x.x
and this is described in the documentation under Version 3
Overview.
You are attempting to use Sqlite3 on a version 2.8.x database
and the formats are not compatible.
On Wed, 9 May 2007 19:42:06 -0400, Brandon Eley wrote:
I've gone through a few tutorials and can't seem to get this right.
I've had my web host install the PECL extension and the
following is
what is in my phpinfo();
sqlite
SQLite support enabled
PECL Module version 1.0.3 $Id: sqlite.c,v 1.62.2.25 2004/07/10
12:25:33 wez Exp $
SQLite Library 2.8.14
SQLite Encoding iso8859
Directive Local Value Master Value
sqlite.assoc_case 0 0
***********************************
This is the PHP code I'm using:
<?php
$db = sqlite_open("/home/xxx/data/xxx.db");
?>
***********************************
This is the error I'm getting:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or
is not a database in /home/xxx/public_html/test.php on line 140
***********************************
What am I doing wrong? I can run queries all day long using the
command line sqlite3 but I can't seem to get PHP to read the
stinkin
database!
Any help would be GREATLY appreciated!
Brandon Eley
[EMAIL PROTECTED]
--------------------------------------------------------------------
--
-------
To unsubscribe, send email to [EMAIL PROTECTED]
--------------------------------------------------------------------
--
-------
---------------------------------------------------------------------
--------
To unsubscribe, send email to [EMAIL PROTECTED]
---------------------------------------------------------------------
--------
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
