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:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
