UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Anyone recognise this error?

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 ?

yes - which is running along just fine now

.. touch wood

Another question would be is it on the same domain as another forum...

LOL - Just mighty coincidental to have such issues on a NEW install.

Just FYI I installed my new site yesterday and did not run into any issues aside from some nuances that I suggested changes for.

Did a clean new install of UBBT 7.1b4 on Linux system with Apache 1.3

Different domain (using my other licence - need to buy more LOL )

well, that would avoid the possiblity of any cookie conflicts (hey i'm grasping at straws here lol)

I was grasping at hardware/path/config issues of the main server for one or more of PHP or MySQL ????

Is this on Linux box?

both on linux - both forums on the same server, but different domain names.

All the paths are the same (except the domain part obviously)

Very strange....

I will check all settings again today - but it is the morning school run time now.....

The hardware seems sane, with the exception of his backup script which just eats away at system resources lol

tell me about it

However that is not the cause of this error....

as long as it's not preformance/resource related lol

Yep, but pretty strange that a NEW clean install has problems too right out the gate.

Looking at this again, the query seems to be a bit incomplete. That would give the total # of new posts in all forums older than a new date. I'm trying to locate where we even do a query like that.

Ok, I've been searching through all of the scripts and I can't find any query like this. The scripts that check for unread posts all specify an individual forum and use a join in the process, so they look more like "and t1.POST_POSTED_TIME > "

There is no query in the default code that I can find anywhere that executes a query like this.

Hi,

This was a stock install - nothing had altered - however it has now vanished.

All very strange....

As long as it remains that way, I will be happy.

Thanks for having a look and my apologies for any inconvenience

Don't have the code with me, but what about cache_builders/forum_stats.php

Nope, that one doesn't query the POSTS table at all. It grabs the total posts from the FORUMS table, using the FORUM_TOPICS and FORUM_POSTS fields.

Rick - when I first had this problem it was just after I had installed Ian's modification to forum_stats.php.

However this was a fresh install - I did various things to correct the issue, including re-uploading. Whether re-uploading this file did the trick I do not know.

Well yeah, that's my query, but if that was causing it it'd imply either an issue with $html->get_date(), php's ability to subtract, or $dbh->do_placeholder_query(). What bothers me is that I'm anal about using the __LINE__ and __FILE__ parameters in queries, so those for some reason weren't getting added into the error

I am now receiving the following error:

Will doing a repair on the ubbt_posts.myd table solve the problem? It isn't showing any rows with only 1B in both data_length and index_length columns.

Looking at the ubbt_posts table itself, it says "in use" which is what is obviously causing the problem.

I am ready to use the repair table ubbt_posts command, however, I want to make sure this is ok to do before I do it as I can't afford to mess up on such a critical table as I don't want to lose all the posts data.

It's saying it cannot read ubbt_POSTS, so I believe that a repair should fix the issue

this error code is associated with a crash of the MySQL database, where the table (in this case, the ubbt_POSTS table) is marked as needing repair.

MySQL.com provides:
"4.4.6.7 Using myisamchk for Crash Recovery" http://www.mysql.com/doc/en/Crash_recovery.html

I did the REPAIR TABLE ubbt_POSTS command about twenty or so minutes ago.

The data base has been growing ever since, and is still growing.

If it doesn't stop growing soon, I may run out of server space.

Does it create a temporary file or table while doing the repair?

While this is going on, it won't let me access the database via MySQL Admin.

It has increased by about 100MB since I executed the repair command via the UBBT Control Panel after closing down the board.

The repair didn't work via the SQL Command in the Control Panel.

It increased the database size up to the max. space and then reverted back to normal size again.

Any ideas on what to do next?

Their server support is now trying to repair it for me.

They said they are doing a "real repair" whatever that means.

Well, as long as it works, that is fine with me.