<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hey gang.<br><br>I tried to install myphpmoney on my ubuntu server and it sure was a challenge. Needless to say I got it mostly running but need a little help. Apparently it was written for MySQL 4 but I have MySQL5 running. I found a fix on google groups but I don't know how to implement it. It involves changing all occurences of OUT to `OUT` in all of the php scripts since OUT is now a reserved word in mysql5. How do I do that?<br><br>Here are the citations I found<br><br>-----cause-----<br>Package: <b style="color: black; background-color: rgb(255, 255, 102);">myphpmoney</b> <br> Version: 1.3RC3+dfsg-1 <br> Severity: important <br> <p>After upgrading the mysql server to newer version 5, <b style="color: black; background-color: rgb(255, 255, 102);">myphpmoney</b> is unusable, it <br>
compains that there is a error on the sql syntax, near '<b style="color: black; background-color: rgb(160, 255, 255);">OUT</b>'. <br> </p><p>I went to another system, and tried to install it, and fails the same, but now <br> on another sql sentence. The output is: <br> </p><p>MySQL Error : <br> </p><p>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 '<b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> BLOB NOT NULL, ' at line 13) <br> Database : <br> Invalid SQL: CREATE TABLE IF NOT EXISTS MPM_op <br> ( <br> OPID BIGINT(20) NOT NULL, <br> NUMID BLOB NOT NULL, <br> TEMPID
INTEGER(1) NOT NULL, <br> VALID_OP INTEGER(1) NOT NULL, <br> USERID BIGINT(20) NOT NULL, <br> DATES DATE NOT NULL, <br> CAT BIGINT(20)
NOT NULL, <br> THIRD BIGINT(20) NOT NULL, <br> COREL BIGINT(20) NOT NULL, <br> COMMENTS BLOB NOT NULL, <br> <b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> BLOB
NOT NULL, <br> IMP BLOB NOT NULL, <br> ACCOUNT BLOB NOT NULL, <br> BALANCE BLOB NOT NULL, <br> PERIOD INTEGER(1) NOT NULL, <br> UNIQUE KEY PK_MPM_op
(OPID), <br> KEY FK_MPM_op (USERID) <br> )type = MyISAM <br> </p><p>I think the error is on a row named '<b style="color: black; background-color: rgb(160, 255, 255);">OUT</b>' on the 'MPM_op' table, being <b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> a <br> reserved word as stated in <a target="_blank" href="http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html">http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html</a> <br> and not being quoted. <br> </p><p>Thanks <br> </p>David <br><br><br>------solution------<br>The reason of the problem is the <b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> column and <b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> is now a keyword of <br> mysql syntax! <br> I replace all <b style="color: black; background-color: rgb(160, 255, 255);">OUT</b> with `<b style="color: black; background-color: rgb(160, 255, 255);">OUT</b>`
(backquotes) in <br> /var/lib/<b style="color: black; background-color: rgb(255, 255, 102);">myphpmoney</b>/public_html directory.... and now it works fine! <br><br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>