#130 error on login,

OPT_1.X_(Max)
closed
nobody
None
5
2006-09-10
2005-02-14
No

I just finished installing 1.2.6 MAX and right after
click on the login button, i receive the following
message.

Not Found
The requested URL /proj/opt/main_menu/<hr>The following
query failed:<br />select count(*) from news<br />
where chindate>0000-00-00 00:00:00<br />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 '00:00:00' at line 2<br><p>This
error occured while Administrator was accessing
/proj/opt/index.php<p>The user came here from
http://172.16.21.100/proj/opt/<p>Please make sure you
include the lines above when submitting a bug
report!<hr><div class= was not found on this server.

I suscpect it has something to do with the newletter
module but Im not sure can anyone please help me
troubleshoot this? I used all of the defaults settings.

Im using freebsd 5.1 as my OS.

Discussion

  • Martin Vernooij

    Martin Vernooij - 2005-03-30

    Logged In: YES
    user_id=608879

    Sorry, missed this one.
    What version of MySQL are you using? PHP version?

    Martin

     
  • Nobody/Anonymous

    Logged In: NO

    i got the same in Apache/2.0.53 (Ubuntu) PHP/4.3.10-10
    MySQL 3.23.56

     
  • Martin Vernooij

    Martin Vernooij - 2006-09-10

    Logged In: YES
    user_id=608879

    This was caused by the quoting and date changes between
    MySQL 3, 4 and 5. This should be fixed in the 1.2.7 release.

    Martin

     
  • Martin Vernooij

    Martin Vernooij - 2006-09-10
    • milestone: 314199 --> OPT_1.X_(Max)
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks