Your message dated Sun, 01 Oct 2006 22:02:15 -0700 with message-id <[EMAIL PROTECTED]> and subject line Bug#353991: fixed in myphpmoney 1.3RC3+dfsg-2 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: myphpmoney Version: 1.3RC3+dfsg-1 Severity: important After upgrading the mysql server to newer version 5, myphpmoney is unusable, it compains that there is a error on the sql syntax, near 'OUT'. I went to another system, and tried to install it, and fails the same, but now on another sql sentence. The output is: MySQL Error : 1064(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUT BLOB NOT NULL, ' at line 13) Database : Invalid SQL: CREATE TABLE IF NOT EXISTS MPM_op ( OPID BIGINT(20) NOT NULL, NUMID BLOB NOT NULL, TEMPID INTEGER(1) NOT NULL, VALID_OP INTEGER(1) NOT NULL, USERID BIGINT(20) NOT NULL, DATES DATE NOT NULL, CAT BIGINT(20) NOT NULL, THIRD BIGINT(20) NOT NULL, COREL BIGINT(20) NOT NULL, COMMENTS BLOB NOT NULL, OUT BLOB NOT NULL, IMP BLOB NOT NULL, ACCOUNT BLOB NOT NULL, BALANCE BLOB NOT NULL, PERIOD INTEGER(1) NOT NULL, UNIQUE KEY PK_MPM_op (OPID), KEY FK_MPM_op (USERID) )type = MyISAM I think the error is on a row named 'OUT' on the 'MPM_op' table, being OUT a reserved word as stated in http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html and not being quoted. Thanks David -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (990, 'testing') Architecture: i386 (i586) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.4.32 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) Versions of packages myphpmoney depends on: ii apache [httpd] 1.3.34-2 versatile, high-performance HTTP s 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 libapache-mod-php4 4:4.4.2-1 server-side, HTML-embedded scripti ii libapache2-mod-php4 4:4.4.2-1 server-side, HTML-embedded scripti ii mysql-client 5.0.18-7 mysql database client (current ver ii mysql-client-5.0 [mysql-clien 5.0.18-7 mysql database client binaries 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-gd 4:4.4.2-1 GD module for php4 ii php4-mysql 4:4.4.2-1 MySQL module for php4 ii ttf-bitstream-vera 1.10-5 The Bitstream Vera family of free ii wwwconfig-common 0.0.44 Debian web auto configuration Versions of packages myphpmoney recommends: ii mysql-server-5.0 [mysql-serve 5.0.18-7 mysql database server binaries -- debconf information: * myphpmoney/webservers: apache, apache2 * myphpmoney/mysql_user: myphpmoney * myphpmoney/database_name: myphpmoney * myphpmoney/mysql_dbadmin: root * myphpmoney/installed: * myphpmoney/databasemgr_server: localhost * myphpmoney/configuration: true * myphpmoney/postrm_remove_database: false myphpmoney/dbcreateerror:
--- End Message ---
--- Begin Message ---Source: myphpmoney Source-Version: 1.3RC3+dfsg-2 We believe that the bug you reported is fixed in the latest version of myphpmoney, which is due to be installed in the Debian FTP archive: myphpmoney_1.3RC3+dfsg-2.diff.gz to pool/main/m/myphpmoney/myphpmoney_1.3RC3+dfsg-2.diff.gz myphpmoney_1.3RC3+dfsg-2.dsc to pool/main/m/myphpmoney/myphpmoney_1.3RC3+dfsg-2.dsc myphpmoney_1.3RC3+dfsg-2_all.deb to pool/main/m/myphpmoney/myphpmoney_1.3RC3+dfsg-2_all.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. Aurelien Jarno <[EMAIL PROTECTED]> (supplier of updated myphpmoney 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: Mon, 2 Oct 2006 01:08:56 +0200 Source: myphpmoney Binary: myphpmoney Architecture: source all Version: 1.3RC3+dfsg-2 Distribution: unstable Urgency: low Maintainer: Debian QA Group <[EMAIL PROTECTED]> Changed-By: Aurelien Jarno <[EMAIL PROTECTED]> Description: myphpmoney - Finance manager written in PHP Closes: 338789 353991 Changes: myphpmoney (1.3RC3+dfsg-2) unstable; urgency=low . * Orphaning this package, setting maintainer field to [EMAIL PROTECTED] * Bumped standards-version to 3.7.2 (no changes). * Added Swedish debconf translation. Thanks to Daniel Nylander (closes: bug#338789). * Use backquotes around OUT in SQL queries (closes: bug#353991). Files: beb94408a05fb65da795a01c5aa5c167 600 utils optional myphpmoney_1.3RC3+dfsg-2.dsc c62e02e5105c6a431316c8f25c224735 25926 utils optional myphpmoney_1.3RC3+dfsg-2.diff.gz fede2bf3f0b6b7bc2766d2be95ff8fd3 638890 utils optional myphpmoney_1.3RC3+dfsg-2_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFIEtZw3ao2vG823MRAspjAJ9gSfCl2NvxGQ4jXpKZ1wGKIVSloACfZ6DC edI9dDXPmoKOvL9vnqLmpik= =wnSr -----END PGP SIGNATURE-----
--- End Message ---
