[asus]

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 12:45 AM, 16-04-2007 AND open <> 10, 1, 0)) AS newthread

FROM thread AS thread


WHERE forumid = 129
AND sticky = 0
AND visible IN (0,1,2);

MySQL Error : 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 ':45 AM, 16-04-2007 AND open <> 10, 1, 0)) AS newthread

FROM thread AS threa' at line 1
Error Number : 1064


can anyone help in this matter

[Code Monkey]

Is this a custom script?

[Makc666]

Originally Posted by asus

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 12:45 AM, 16-04-2007 AND open <> 10, 1, 0)) AS newthread

FROM thread AS thread


WHERE forumid = 129
AND sticky = 0
AND visible IN (0,1,2);

MySQL Error : 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 ':45 AM, 16-04-2007 AND open <> 10, 1, 0)) AS newthread

FROM thread AS threa' at line 1
Error Number : 1064


can anyone help in this matter

thread.lastpost > 12:45 AM, 16-04-2007 AND open <> 10, 1, 0
this one is not right.

time in thread.lastpost is storied on UNIX format (Date/Epoch).
Also <> 10, 1, 0 is not right also. it can't be so.

it must look like:
thread.lastpost > 1176713100 AND open = 10 AND open = 0 AND open = 1

To get UNIX time you can use:
Date/Epoch Converter
Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft