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