Debian Bug report logs - #673313
[php5-sqlite] FastCGI-stderr: PHP Fatal error

[Message part 1 (text/plain, inline)]
Package: php5-sqlite
Version: 5.4.0-3
Severity: normal

--- Please enter the report below this line. ---

Tested under lighttpd and fastcgi-php with simple script:

<?php
// Create an SQLite DB in the file test.sqlite
  $db = new SQLiteDatabase("test.sqlite");
  $db->query("BEGIN;
          CREATE TABLE dbtest(id INTEGER PRIMARY KEY, article CHAR(50),price FLOAT(10));
          INSERT INTO dbtest (article,price) VALUES('Book1','12.99');
          INSERT INTO dbtest (article,price) VALUES('Book2','15.23');
          COMMIT;");
  $result = $db->query("SELECT * FROM dbtest");

  // Read and show the DB we created
  echo "<PRE>";
  printf("+------------+------------------------------------------+\n");
  printf("| Price       | Article                              |\n");
  printf("+------------+------------------------------------------+\n");
  while ($result->valid()) {
    $row = $result->current();
    printf("| %10s | %-40s |\n",$row['price'],$row['article']);
    $result->next();
  }
  printf("+------------+------------------------------------------+\n");
  echo "</PRE>";
  unset($db);
 phpinfo();
?>

There is always in lighttpd error log:
FastCGI-stderr: PHP Fatal error:  Class 'SQLiteDatabase' not found in /mnt/data/www/test.php on line 3

--- System information. ---
Architecture: i386
Kernel:       Linux 3.2.0-2-686-pae

Debian Release: wheezy/sid
  500 testing         ftp.at.debian.org 

--- Package information. ---
Depends                   (Version) | Installed
===================================-+-============
libc6                      (>= 2.4) | 2.13-32
libsqlite3-0             (>= 3.7.4) | 3.7.11-3
phpapi-20100525+lfs                 | 
php5-common             (= 5.4.0-3) | 5.4.0-3
ucf                                 | 3.0025+nmu3

Package's Recommends field is empty.

Package's Suggests field is empty.

[signature.asc (application/pgp-signature, attachment)]
[Message part 1 (text/plain, inline)]
Version: 5.4.0-3

Hi,

You're trying to run sqlite code under PHP 5.4.0. See
http://www.php.net/manual/en/migration54.removed-extensions.php

You should migrate your code to sqlite3, see
http://www.php.net/manual/en/book.sqlite3.php

Good luck (:

Kaplan

[Message part 2 (text/html, inline)]
Version: 5.4.0-3

sqlite extension has been removed from upstream. You have to use sqlite3.

Thus no bug here.

O.

On Thu, May 17, 2012 at 9:35 PM, Marek Straka <marek@straka.info> wrote:
> Package: php5-sqlite
> Version: 5.4.0-3
> Severity: normal
>
> --- Please enter the report below this line. ---
>
> Tested under lighttpd and fastcgi-php with simple script:
>
> <?php
> // Create an SQLite DB in the file test.sqlite
>  $db = new SQLiteDatabase("test.sqlite");
>  $db->query("BEGIN;
>          CREATE TABLE dbtest(id INTEGER PRIMARY KEY, article CHAR(50),price FLOAT(10));
>          INSERT INTO dbtest (article,price) VALUES('Book1','12.99');
>          INSERT INTO dbtest (article,price) VALUES('Book2','15.23');
>          COMMIT;");
>  $result = $db->query("SELECT * FROM dbtest");
>
>  // Read and show the DB we created
>  echo "<PRE>";
>  printf("+------------+------------------------------------------+\n");
>  printf("| Price       | Article                              |\n");
>  printf("+------------+------------------------------------------+\n");
>  while ($result->valid()) {
>    $row = $result->current();
>    printf("| %10s | %-40s |\n",$row['price'],$row['article']);
>    $result->next();
>  }
>  printf("+------------+------------------------------------------+\n");
>  echo "</PRE>";
>  unset($db);
>  phpinfo();
> ?>
>
> There is always in lighttpd error log:
> FastCGI-stderr: PHP Fatal error:  Class 'SQLiteDatabase' not found in /mnt/data/www/test.php on line 3
>
> --- System information. ---
> Architecture: i386
> Kernel:       Linux 3.2.0-2-686-pae
>
> Debian Release: wheezy/sid
>  500 testing         ftp.at.debian.org
>
> --- Package information. ---
> Depends                   (Version) | Installed
> ===================================-+-============
> libc6                      (>= 2.4) | 2.13-32
> libsqlite3-0             (>= 3.7.4) | 3.7.11-3
> phpapi-20100525+lfs                 |
> php5-common             (= 5.4.0-3) | 5.4.0-3
> ucf                                 | 3.0025+nmu3
>
>
> Package's Recommends field is empty.
>
> Package's Suggests field is empty.
>
> _______________________________________________
> pkg-php-maint mailing list
> pkg-php-maint@lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-php-maint

-- 
Ondřej Surý <ondrej@sury.org>

Debian Bug report logs - #673313 [php5-sqlite] FastCGI-stderr: PHP Fatal error

Debian Bug report logs - #673313
[php5-sqlite] FastCGI-stderr: PHP Fatal error