Your message dated Thu, 17 Jan 2008 00:47:02 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#457141: fixed in mysql-navigator 1.4.2-11 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: mysql-navigator Version: 1.4.2-10 Severity: normal Unable to import previously exported database/ ### table created with the following ############################## #CREATE TABLE tbl_junk (tbl_junk_id BIGINT not null primary key auto_increment); #ALTER TABLE tbl_junk ADD mytxt VARCHAR(255) AFTER tbl_junk_id; #ALTER TABLE tbl_junk ADD editdate TIMESTAMP AFTER mytxt; #INSERT INTO tbl_junk (mytxt) VALUES ('abc123'); # ###### Below is the output from mysql_navigator export database ############################## # MySQL Navigator Xport # Database: bk_dev # [EMAIL PROTECTED] # CREATE DATABASE bk_dev; # USE bk_dev; # # Table structure for table 'tbl_junk' # # DROP TABLE IF EXISTS tbl_junk; CREATE TABLE `tbl_junk` ( `tbl_junk_id` bigint(20) NOT NULL auto_increment, `mytxt` varchar(255) default NULL, `editdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`tbl_junk_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; # # Dumping data for table 'tbl_junk' # INSERT INTO tbl_junk VALUES (1,'abc123',2007-12-19 10:45:42); ###### End of the output from mysql_navigator export database ############################## ###### attempting database import with above opens a window ########### ####### with the following error message. ############################# You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synatx to use near '10:45:42)'at line 1 ##### End of error message ############################# The exported file only can be used with import database if I manually adding single quotes around the editdate field. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.22 (PREEMPT) Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-navigator depends on: ii libc6 2.7-3 GNU C Library: Shared libraries ii libgcc1 1:4.2.2-3 GCC support library ii libmysqlclient15off 5.0.45-1+lenny1 MySQL database client library ii libqt3-mt 3:3.3.7-9 Qt GUI Library (Threaded runtime v ii libstdc++6 4.2.2-3 The GNU Standard C++ Library v3 mysql-navigator recommends no packages. -- no debconf information
--- End Message ---
--- Begin Message ---Source: mysql-navigator Source-Version: 1.4.2-11 We believe that the bug you reported is fixed in the latest version of mysql-navigator, which is due to be installed in the Debian FTP archive: mysql-navigator_1.4.2-11.diff.gz to pool/main/m/mysql-navigator/mysql-navigator_1.4.2-11.diff.gz mysql-navigator_1.4.2-11.dsc to pool/main/m/mysql-navigator/mysql-navigator_1.4.2-11.dsc mysql-navigator_1.4.2-11_i386.deb to pool/main/m/mysql-navigator/mysql-navigator_1.4.2-11_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. Sandro Tosi <[EMAIL PROTECTED]> (supplier of updated mysql-navigator 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: Wed, 16 Jan 2008 19:37:42 +0100 Source: mysql-navigator Binary: mysql-navigator Architecture: source i386 Version: 1.4.2-11 Distribution: unstable Urgency: low Maintainer: Sandro Tosi <[EMAIL PROTECTED]> Changed-By: Sandro Tosi <[EMAIL PROTECTED]> Description: mysql-navigator - GUI client program for MySQL database server Closes: 457141 Changes: mysql-navigator (1.4.2-11) unstable; urgency=low . * debian/control - bump Standards-Version to 3.7.3 - moved Homepage field from binary to source stanza - added dpatch build-dependency - added dependency on autoconf, libtool, automake1.7 for relibtoolizing * debian/menu - updated to new menu policy * debian/rules - added dpatch stuff - relibtoolizing in the configure target - don't ignore errors during clean target (lintian warning) - added remove of link header files in "include" dir - removed unneeded dh_makeshlibs call - simple changes to parameters to dh_* spacing * debian/patches/01_restore_pristine_code.dpatch - added to avoid direct upstream code modification * debian/desktop - removed "Encoding" entry since deprecated (lintian warning) * debian/patches/10_bts-457141_fix_export_database.dpatch - added to treat TIMESTAMP as strings, including those fields in quotes when exported (Closes: #457141) * debian/copyright - added copyright note, inferred by upstream changelog - clear identification of upstream author and license texts - license text fixed to be GPLv2 or any next release Files: 81bcf206b7985310a50afb746a5d44ff 802 misc optional mysql-navigator_1.4.2-11.dsc 1fb29b486f57bb77dc6a833c95f343da 94915 misc optional mysql-navigator_1.4.2-11.diff.gz b70d1cdf75d03f8bc77cdf42b7aa2093 585098 misc optional mysql-navigator_1.4.2-11_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHjqHFpdwBkPlyvgMRAtKiAJoCyATQ4anN6Nj0Ph19IctEi/UTMwCfaDOF W5SMUk5pRkB5REZwtit9Bhk= =QQmm -----END PGP SIGNATURE-----
--- End Message ---
