I had this "Error creating temp table for weapon specific per player totals" error too with MySQL 5.5, which was due to an error in the SQL syntax in includes/logsave.php, where it used "Type=HEAP" instead of "Engine=HEAP".

I struggled quite a bit to get UTStats working, seeing that OLStats crashed ...