Re: [sqlite] Problem with SQLite Pecl extension for PHP4
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: *** 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] -
Re: [sqlite] Problem with SQLite Pecl extension for PHP4
It's ShopSite (www.shopsite.com) and I'm building add-on modules for the cart that need to access information in the DB. Unfortunately, we can't upgrade to PHP5 just yet, as we have quite a few sites on the server running open source software and we haven't verified they are all compatible with PHP5. Is there a way to upgrade the module to SQLite 3 on PHP4? Brandon Eley [EMAIL PROTECTED] On May 10, 2007, at 8:58 AM, T wrote: Hi Brandon, 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 SQLite Library 2.8.14 How would I access the 2.8.x database from within PHP? is it even possible? I think you have the problem backwards. Your database data file is probably already "upgraded" to SQLite version 3.x format. But it's the SQLite executable library in PHP that is lagging at 2.8.14. You need to upgrade your PHP SQLite library so it can open your newer version database file. The simplest way I found to do this, was to upgrade my PHP to the latest 5.2.1, which includes SQLite support for 3.x database files. The database is created from a shopping cart program, so I can't upgrade it, it has to remain the same version (for now). Out of curiosity, what is the shopping cart software that you're using? Tom -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem with SQLite Pecl extension for PHP4
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: *** 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] -
[sqlite] Problem with SQLite Pecl extension for PHP4
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: *** 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]