UBB.Developers Forums Community Development Programming MySQL and Server Configuration Mysql Logs

(ubbthreads 6.3.2)

I my all mysql logs on the forum I have this lines:
[]
Unable to do_query: SELECT B_Main, B_Last_Post,B_Subject,B_Rating,B_Rates,B_RealRating,B_Board FROM w3t_Posts WHERE B_Number = - 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
[/]

In showthreaded.php (where is this error):

[]
// -----------------------------------------
// Grab the main post number for this thread
$query = "
SELECT B_Main, B_Last_Post,B_Subject,B_Rating,B_Rates,B_RealRating,B_Board
FROM {$config['tbprefix']}Posts
WHERE B_Number = $Number
";
$sth = $dbh -> do_query($query);
list ($current,$posted,$tsubject,$Rating,$Rates,$stars,$Board) = $dbh -> fetch_array($sth);
$dbh -> finish_sth($sth);
[/]

and WHERE B_Number = $Number <-this is line 3...

Quetions is: what is wrong in line 3 ?

The var $Number is empty.

ok... so how can I correct this?

That happends if someone clicks on a link that doesnt contain a the &Number parameter.
What version are you using? The current version should fetch this error.

Simply insert something like this:
// ----------------------------------------------------
// If we don't have a post number then we can't view it
if (!$Number) {
$html -> not_right($ubbt_lang['POST_PROB'],$Cat);
}

after this line:
$html = new html;

thx. I'm useing 6.3.2

6.3.2 should have this check already included. So it must be something else that causes this error.