[vauge]

Originally Posted by ShadowOne

im getting this...

Database error in vBulletin 3.5.4:

Invalid SQL:

	SELECT 
  	warnlog.wid as ID,
  	user1.username as Moderator,
  	user.username as To_User,
  	user.userid as To_Userid,
  	warnlog.w_adjust as Adjust,
  	warnlog.w_amount as Amount,
  	warnlog.w_notes as Notes,
  	warnlog.w_expire as Expires,
  	warnlog.w_expired as Expired,
  	warnlog.w_time as Time,
  	thread.title as Thread_Title,
  	warnlog.w_post as PostId
	FROM  warnlog 
 	INNER JOIN user ON (warnlog.w_user=user.userid)
 	INNER JOIN user user1 ON (warnlog.w_by=user1.userid)
 	LEFT JOIN post ON (warnlog.w_post=post.postid)
 	LEFT JOIN thread ON (post.threadid=thread.threadid)
		
		ORDER BY Time DESC
		LIMIT 0, 15;

MySQL Error  : Table 'urban_HHB.warnlog' doesn't exist
Error Number : 1146
Date         : Wednesday, April 5th 2006 @ 12:23:07 PM
Script       : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
Referrer     : http://www.hiphopbloodlinez.com/forum/admincp/warnlog.php
IP Address   : 
Username     : Unorthodox
Classname    : vb_database

I changed the following to the SELECT statement in warnlog.php - and it started working...

$logs = $db->query_read("
	SELECT 
  	" . TABLE_PREFIX . "warnlog.wid as ID,
  	user1.username as Moderator,
  	" . TABLE_PREFIX . "user.username as To_User,
  	" . TABLE_PREFIX . "user.userid as To_Userid,
  	" . TABLE_PREFIX . "warnlog.w_adjust as Adjust,
  	" . TABLE_PREFIX . "warnlog.w_amount as Amount,
  	" . TABLE_PREFIX . "warnlog.w_notes as Notes,
  	" . TABLE_PREFIX . "warnlog.w_expire as Expires,
  	" . TABLE_PREFIX . "warnlog.w_expired as Expired,
  	" . TABLE_PREFIX . "warnlog.w_time as Time,
  	" . TABLE_PREFIX . "thread.title as Thread_Title,
  	" . TABLE_PREFIX . "warnlog.w_post as PostId
	FROM " . TABLE_PREFIX . "warnlog 
 	INNER JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "warnlog.w_user=" . TABLE_PREFIX . "user.userid)
 	INNER JOIN " . TABLE_PREFIX . "user as user1 ON (" . TABLE_PREFIX . "warnlog.w_by=user1.userid)
 	LEFT JOIN " . TABLE_PREFIX . "post ON (" . TABLE_PREFIX . "warnlog.w_post=" . TABLE_PREFIX . "post.postid)
 	LEFT JOIN " . TABLE_PREFIX . "thread ON (" . TABLE_PREFIX . "post.threadid=" . TABLE_PREFIX . "thread.threadid)
		$sqlconds
		ORDER BY $order
		LIMIT $startat, " . $vbulletin->GPC['perpage'] . "
	");