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.
Logged In: YES
user_id=608879
Sorry, missed this one.
What version of MySQL are you using? PHP version?
Martin
Logged In: NO
i got the same in Apache/2.0.53 (Ubuntu) PHP/4.3.10-10
MySQL 3.23.56
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