Your message dated Wed, 11 Oct 2006 12:31:49 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Fixed in 2.9.0.2-0.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: phpmyadmin
Version: 4:2.7.0-pl2-1
Severity: important
Hi,
Use this database:
CREATE TABLE `demo` (
`blobby` blob,
`textty` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `demo` VALUES (NULL, 'DUMMY');
Now edit this value using the phpmyadmin-interface the following code is
generated even if NO new value has been entered:
UPDATE `demo` SET `blobby` = '' WHERE CONVERT( `blobby` USING utf8 )
IS NULL AND CONVERT( `textty` USING utf8 ) = 'DUMMY' LIMIT 1 ;
And the result is:
CREATE TABLE `demo` (
`blobby` blob,
`textty` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `demo` VALUES ('', 'DUMMY');
The NULL in blobby has become a ''.
There is NO possibility (apart from running the sqlcode by hand) to set the
field to his original-null-value.
This error happens if ProtectBinary is "FALSE", "blob" and "all".
Greetings
Torsten
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.13
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages phpmyadmin depends on:
ii apache2 2.0.55-4 next generation, scalable, extenda
ii apache2-mpm-prefork [httpd] 2.0.55-4 traditional model for Apache2
ii debconf [debconf-2.0] 1.4.70 Debian configuration management sy
ii php4 4:4.4.2-1 server-side, HTML-embedded scripti
ii php4-cgi 4:4.4.2-1 server-side, HTML-embedded scripti
ii php4-mysql 4:4.4.2-1 MySQL module for php4
ii php5-mysql 5.1.2-1 MySQL module for php5
ii ucf 2.005 Update Configuration File: preserv
Versions of packages phpmyadmin recommends:
pn php5-mcrypt | php4-mcrypt <none> (no description available)
-- debconf information:
* phpmyadmin/webserver: apache, apache2
* phpmyadmin/restart: true
* phpmyadmin/reconfigure-webserver: apache, apache-ssl, apache-perl, apache2
* phpmyadmin/restart-webserver: true
phpmyadmin/changed-extension:
--- End Message ---
--- Begin Message ---
Version: 4:2.9.0.2-0.1
Hello,
This has been fixed in the new upstream version which has been uploaded
to Debian yesterday. Thanks for reporting!
Thijs
signature.asc
Description: This is a digitally signed message part
--- End Message ---
