5.13 + ubbthreads - statistics fail

[encaustic]

I upgraded 2 sites to 5.13 with ubbthreads integration including the new 5.13 forum/threads.php

One worked the other had "unrecoverable errors".

It turns out that if the statistics sidebar is on, then this error is identified:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/site/mysite/htdocs/myphotopost/forums/threads.php on line 56

Line 56 seeks the SQL table that has my Admin-forum-options set to (ubb_) then it appends Cache, so seeks for the table "ubb_cache" that does not exist. It used to work in 5.11 - what should I alter to get this to function?

Code in 5.13 is like this - lines 48/60
// For each BB, get the total number of users
//

function get_totalusers() {
global $Globals, $db_link;

$query = "SELECT C_Users FROM {$Globals['dprefix']}Cache";
$queryv = ppmysql_query($query, $db_link);
list( $totalusers ) = mysql_fetch_row($queryv);

return( $totalusers );
}

//

The photoposts work is statistics are switched off in admin.

[Chuck S]

Okay you have an old threads. try changing the query line here as you see

$query = "SELECT C_Users FROM {$Globals['dprefix']}Cache";

to

$query = "SELECT COUNT(*) FROM {$Globals['dprefix']}Users";

[encaustic]

That worked a treat and seems to have solved the problem perfectly thanks.