We encountered a problem. The reason reported was
Script:
Line#:
SQL 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 '' at line 3
SQL Error #: 1064
Query: select count(*) from ubbt_POSTS WHERE POST_POSTED_TIME >

Please use your back button to return to the previous page

------------------

This was when trying to make a new post in a forum...

People seem to be psoting in other forums - this forum can only have posts started by admins (it is a site news forum)

The post was posted fine, despite the error.

I have posted in an admin forum as a test and all was fine.

At what point did you get the error? The only place that query is used in is to show the total # of unread posts in a forum, the 7.1 feature.

the error has now gone - mind you the database then corrupted LOL

not having a lot of luck

Okay - just set up a new forum as a test - and am getting this error again.

This is a stock 7.1b4 - and I get the error on all items (posts, CP changes etc..)

I have not altered any templates yet - so this is out of the box.

Even just showing 'who's online' brings up this error

BTW - tried repairing ubbt_POSTS - no joy

anyone?

any thoughts?

Query: select count(*) from ubbt_POSTS WHERE POST_POSTED_TIME >

It looks like it failed when trying to count the number of posts before a specific time, such as for the "latest posts in thread" opion that shows at the thread listing; it looks like the time wasn't included or something?

is it reoccouring?

yes - but this is a brand new forum - it happened on the very first post

I have only made 3 so far - 1 global announcement, 1 sticky and now a test in an admin forum.

All had this error, as did various changes in the CP prior to even posting.

However on every ocasion the requested task is carried out, despite the error.

Is this on the same server as your production forum ?