Your message dated Thu, 12 Apr 2007 13:32:10 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#417386: fixed in php-sqlite3 0.5-1 has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---Package: php4-sqlite3 Version: 0.4-1frontier1 Severity: important Tags: patch I contacted the maintainer for this package about a year ago about transaction support in php4-sqlite3; below are a couple of the messages we exchanged. It would be nice if this patch could be included in the Debian packaging. Unfortunately, it looks like it hasn't been committed upstream yet, but I've pinged Bruno to see what's up. I'll post any followup I receive. thanks, john Date: Wed, 31 May 2006 16:41:29 -0400 From: John Morrissey <[EMAIL PROTECTED]> To: Bruno Fleisch <[EMAIL PROTECTED]> Subject: Transaction support in SQLite-PHP Hi Bruno-- I tried e-mailing Chris Burton, who's listed as the maintainer for the SourceForge project, but my message bounced[1]. I found your contact information in the Debian packaging for SQLite-PHP - I hope you're an appropriate person to contact. If not, could you please let me know who I should be in touch with? I'm having a problem with transaction support with SQLite-PHP 0.4 and SQLite 3.3.5 (the Debian versions of both, FWIW). Based on the symptoms, it acts like autocommit mode is never being disabled. I can create a simple table, start a transaction, insert a row, then ROLLBACK, but the row I inserted remains. Here's a simple test case I got it down to: <?php system("sqlite3 foo.db 'CREATE TABLE user ( uid VARCHAR(32) );'"); require_once 'DB.php'; $db = DB::connect('sqlite3:///foo.db'); if (PEAR::isError($db)) { die($db->getMessage() . "\n"); } foreach (array( "BEGIN TRANSACTION;", "INSERT INTO user (uid) VALUES('jwm2');", "ROLLBACK;") as $query) { print "$query\n"; $result = $db->query($query); if (PEAR::isError($result)) { die($query->getMessage() . "\n"); } } The system() part to create the table isn't significant; the same symptoms appear if I create the table via SQLite-PHP. If I execute the same statements with the command line SQLite client, the behavior is as I would expect - after the ROLLBACK, the table is empty. Am I doing something wrong, or making a false assumption? I haven't had a chance to delve into the SQLite-PHP source yet, but I would appreciate it if you could have a look at this. thanks! john [1] <[EMAIL PROTECTED]>: host mail.sourceforge.net[66.35.250.206] said: 550-This @users.sourceforge.net account doesn't exist or isn't currently 550-functioning (mail to them is bouncing). You can check that you have the 550-right address by checking http://sourceforge.net/users/cburton/. It's also 550-possible that this alias just isn't active yet. It may take a few minutes 550 for new accounts to become active. (in reply to RCPT TO command) -- John Morrissey _o /\ ---- __o [EMAIL PROTECTED] _-< \_ / \ ---- < \, www.horde.net/ __(_)/_(_)________/ \_______(_) /_(_)__ Date: Fri, 02 Jun 2006 10:09:36 +0200 From: Bruno Fleisch <[EMAIL PROTECTED]> To: John Morrissey <[EMAIL PROTECTED]> Subject: Re: Transaction support in SQLite-PHP Selon John Morrissey <[EMAIL PROTECTED]>: > On Thu, Jun 01, 2006 at 05:56:24PM +0200, Bruno Fleisch wrote: > > Attached is a patch made against DB/sqlite3.php that should solve this > > issue. > > > > I've discovered that the BEGIN & END/ROLLBACK statments are executed by > > sqlite3_query(), like all regualar SELECT queries. Such queries are NOT > > performed until a fetchInto-like function is called. > > > > I've changed a bit that function. sqlite3_query() gets called by SELECT > > queries, all others are handled by sqlite3_exec(). > > > > Let me know if it works for you, > > Nifty - thanks for the quick response. There was no patch attached, though. > Let's try again... Below is the patch's content. Regards, Bruno --- sqlite3.php.org 2006-06-01 17:42:41.000000000 +0200 +++ sqlite3.php 2006-06-01 17:42:12.000000000 +0200 @@ -19,7 +19,7 @@ * @author Bruno Fleisch * @copyright 1997-2005 The PHP Group * @license http://www.php.net/license/3_0.txt PHP License 3.0 3.0 - * @version CVS: $Id: sqlite3.php,v 1.2 2006/03/28 15:33:30 bfleisch Exp $ + * @version CVS: $Id: sqlite3.php,v 1.1.1.1 2005/10/13 20:24:55 bfleisch Exp $ * @link http://pear.php.net/package/DB */ @@ -124,10 +124,10 @@ function simpleQuery($query) { - - $isManip = DB::isManip($query); - - if ($isManip) + + $isSelect = preg_match ("/^\s*SELECT/i", $query); + + if (! $isSelect) $this->result = sqlite3_exec($this->connection, $query); else $this->result = sqlite3_query($this->connection, $query); -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.12-10-xeon Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages php4-sqlite3 depends on: ii libapache-mod-php4 [p 4:4.3.10-19 server-side, HTML-embedded scripti ii libapache2-mod-php4 [ 4:4.3.10-19 server-side, HTML-embedded scripti ii libc6 2.3.2.ds1-22sarge5 GNU C Library: Shared libraries an ii libsqlite3-0 3.3.5-0.2 SQLite 3 shared library ii php4-cli [phpapi-2002 4:4.3.10-19 command-line interpreter for the p -- no debconf information
--- End Message ---
--- Begin Message ---Source: php-sqlite3 Source-Version: 0.5-1 We believe that the bug you reported is fixed in the latest version of php-sqlite3, which is due to be installed in the Debian FTP archive: php-sqlite3_0.5-1.diff.gz to pool/main/p/php-sqlite3/php-sqlite3_0.5-1.diff.gz php-sqlite3_0.5-1.dsc to pool/main/p/php-sqlite3/php-sqlite3_0.5-1.dsc php-sqlite3_0.5-1_i386.deb to pool/main/p/php-sqlite3/php-sqlite3_0.5-1_i386.deb php-sqlite3_0.5.orig.tar.gz to pool/main/p/php-sqlite3/php-sqlite3_0.5.orig.tar.gz php5-sqlite3_0.5-1_i386.deb to pool/main/p/php-sqlite3/php5-sqlite3_0.5-1_i386.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Julien Danjou <[EMAIL PROTECTED]> (supplier of updated php-sqlite3 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Thu, 12 Apr 2007 15:11:18 +0200 Source: php-sqlite3 Binary: php5-sqlite3 php-sqlite3 Architecture: source i386 Version: 0.5-1 Distribution: unstable Urgency: low Maintainer: Julien Danjou <[EMAIL PROTECTED]> Changed-By: Julien Danjou <[EMAIL PROTECTED]> Description: php-sqlite3 - PHP SQLite3 PEAR module php5-sqlite3 - SQLite3 module for php5 Closes: 416201 417386 418317 Changes: php-sqlite3 (0.5-1) unstable; urgency=low . * New upstream release - Fix bug with autocommit (Closes: #417386) * Don't restart anything (Closes: #416201) * Remove php4 support (Closes: #418317) Files: 79079c786fae3b0e4046ab5e57c54ee3 609 web optional php-sqlite3_0.5-1.dsc bf3db9ee02088f77cedda99f6916dd07 14106 web optional php-sqlite3_0.5.orig.tar.gz 5c66aa7f19e531e1c6829e0c30ac09aa 15734 web optional php-sqlite3_0.5-1.diff.gz 59330105c69f9e3689187f52f11be2ba 6198 web optional php-sqlite3_0.5-1_i386.deb 231fd4da81a1ba8ec0783e3c96e9a771 11556 web optional php5-sqlite3_0.5-1_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGHjMJpGK1HsL+5c0RAtNVAJ9WHmjyOmLSVyjmeLOXrGNExyDPfgCdGCd2 GNKYC3Th+xKxFXkR9fn+xto= =maJV -----END PGP SIGNATURE-----
--- End Message ---
