[bobjackson]

Originally Posted by Socomjunky.com

i tired to install it and i got the same database error i had to un-install it

there are a couple of missing TABLE_PREFIX's...

the sql script needed an additional two prefix's (in bold below):

$getmessages = $DB_site->query("
		SELECT pmtext.pmtextid, pmtext.fromusername, pmtext.fromuserid, pmtext.dateline, pm.pmid, user.userid, user.usergroupid, 
			COUNT(pmtext.fromuserid) AS fromusertotal FROM " . TABLE_PREFIX . "pmtext AS pmtext 
			LEFT JOIN " . TABLE_PREFIX . "pm AS pm USING(pmtextid) 
			LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=pmtext.fromuserid) 
			WHERE pm.userid=$bbuserinfo[userid] AND messageread=0
			GROUP BY pmtext.fromusername ORDER BY user.usergroupid ASC
	");