[detalhe]

Originally Posted by dwh

Is the lack of spaces only coming from your post or is it in your code as well? And what version of mysql do you have installed?

Now that you mention it, I think you should correct your code above, I think that lack of spaces comes from it

PHP Code:

$DB_site->query("INSERTINTO".TABLE_PREFIX ."threadviewsaggregate SELECT threadid , COUNT(*)ASviewsFROM " . TABLE_PREFIX . "threadviews GROUP BY threadid");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "threadviews"); 

$DB_site->query(
         "UPDATE " . TABLE_PREFIX . "thread,". TABLE_PREFIX ."threadviewsaggregate 
        SET ". TABLE_PREFIX ."thread.views = ". TABLE_PREFIX ."thread.views + ".TABLE_PREFIX."threadviewsaggregate.views
        WHERE ". TABLE_PREFIX ."thread.threadid = ". TABLE_PREFIX ."threadviewsaggregate.threadid"); 

$DB_site->query("DELETE FROM ". TABLE_PREFIX ."threadviewsaggregate"); 


Will try it