[sv1cec]

Originally Posted by SnitchSeeker

Thanks John,
Glad to see I wasn't being ignored intentionally.

I ran the query exactly as you have it above.

Affected Rows: 272

Then I went to the warning system (in admin cp) and chose "view warnings log" and got this error page:

Database error in vBulletin 3.0.7:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.*,wuser.username as warned_username_v,wuser.userid as warned_userid_v, ruser.username as removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate from
	1warnings w
	left join 1user wuser on(wuser.userid=w.warned_user)
	left join 1user u on(u.userid=w.warned_by)
	left join 1user ruser on(ruser.userid=w.removed_by)
	left join 1warning_types wt on(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 20
mysql error: Unknown column 'w.removed_by' in 'on clause'

mysql error number: 1054

Date: Thursday 17th of March 2005 02:06:21 AM
Script: http://www.snitchseeker.com/vb3/admincp/admin_warn.php?act=viewlogs
Referer: http://www.snitchseeker.com/vb3/admincp/index.php?do=nav

Run the following query:

ALTER TABLE 1WARNINGS ADD COLUMN `removed_by` int(15)

For some reason, several people who have used the ZT's hack and upgrade are missing some columns from their tables. I do not know why, the script for the upgrade is correct.

Let me know if you are missing anything else.