[Hotte@gun]

Originally Posted by xscape2me

I'm getting an sql error.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT COUNT(*) ,
SUM(views) AS hits
FROM 600rr_ thread
mysql error: Table database.600rr_' doesn't exist

mysql error number: 1146

Date: Thursday 22nd of July 2004 12:52:54 PM
Script: http://www.miami600rr.com/forums/?

There is an whitespace which schouldnt be there use the following code

// ### Anzeige aller Hits START ###
$totalhits = $DB_site->query_first("
		SELECT COUNT(*) ,
		SUM(views) AS hits
		FROM " . TABLE_PREFIX . "thread
			");

	$totalhits = vb_number_format($totalhits['hits']);
// ### Anzeige aller Hits ENDE ###

This includes Numberformating an the wrong set space after FROM " . TABLE_PREFIX . "