[Dejavu]

Originally Posted by dstruct2k

I don't think the installer made my gamesessions table.

Database error in vBulletin 3.0.0:
 
Invalid SQL: 
		SELECT COUNT(*) AS plays, SUM(finish-start) as time
		FROM gamesessions
		WHERE valid=1
 
mysql error: Table 'db87385808.gamesessions' doesn't exist
 
mysql error number: 1146

That doesn't look right though... "db87385808" is my database, not a table name...


[edit]Checked in phpmyadmin... the table is "vb3__gamesessions" so something's not working right.

[edit 2]Found the bug in arcade.php.... Most of you aren't using table prefixes, otherwise you'd have this bug too.
FIX:
Find:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM gamesessions
WHERE valid=1
");

Replace with:

$stats = $DB_site->query_first("
SELECT COUNT(*) AS plays, SUM(finish-start) as time
FROM " . TABLE_PREFIX . "gamesessions
WHERE valid=1
");

I found the same problem with the mini-stats addon included with the release, didn't have a clue what was going on until i opened the file, and sure enough it didn't have the TABLE_PREFIX or whatever it is in its place