Problem after OPT installation

Help
2005-09-21
2013-03-22
  • Eduardo Seixas
    Eduardo Seixas
    2005-09-21

    Hi,

    Yesterday i installed the OPT on my Linux RedHat 8.0 machine with Apache 2.0 and after the install i'm getting the error bellow. This installation was with the root user of my MySQL 4. Does anybody have the idea what's going on?

    Not Found

    The requested URL /opt/main_menu/<hr>The following query failed:<br />select count(*) from news<br /> where chindate>2005-09-21 09:36:58<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 '09:36:58' at line 2<br><p>This error occured while Administrator was accessing /opt/index.php was not found on this server.

    PS: I'm receiving this email too:

    The OPT system at www.xxx.com issued a database error:
    --------------------------
    The following query failed:
    select count(*) from news
                 where chindate>0000-00-00 00:00:00
    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
    --------------------------
    This error occured while Administrator  was accessing
    /opt/index.php?OPT_Session=d94a987ffefe952ec194a5a6a2a23966
    The user came here from
    http://www.xxx.com/opt/index.php?OPT_Session=d94a987ffefe952ec194a5a6a2a23966
    OPT 1.2.6 Max
    GET variables:
        OPT_Session = d94a987ffefe952ec194a5a6a2a23966

    POST variables:
        justlogged = 1
        username = optadm
        password = orelha
        lang = 0
        tz = -0300
        button = Login now

    Register globals: Off
    User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8b4)
    Gecko/20050908 Firefox/1.4