MySQL error after install

Brilliant Hack! I can see you put a LOT of work into it. It's great!

But after installing it I get this MySQL error when trying to add a warning:

Database error in vBulletin 3.0.7:

Invalid SQL: select * from 1warnings where warned_post='1362607' AND warned_status='A'
mysql error: Unknown column 'warned_status' in 'where clause'

mysql error number: 1054

And when I try to "view" warnings, I get only a blank screen.

I had ZeroTolerence's hack installed before, but I followed your instructions very closely and am positive I did everything correct.

I am running this on a Windows server (if that makes a difference).

Thanks for your help!! :nervous:

I just got another MySQL error when trying to view the warnings log (via the admincp):

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: Saturday 12th of March 2005 08:58:41 AM
Script: http://www.snitchseeker.com/vb3/admi...p?act=viewlogs

[SnitchSeeker]

Originally Posted by sv1cec

Make sure that the templates are there. Make sure that you have the templates installed in the default skin. If you are running more than one skins, make sure that the templates are installed in the skin you are testing the hack with. There is a thread in here, which provides instructions on what to do if you are running more than one set of templates (skins).

Rgds

Everybody gets only blank screens when they try to warn somebody - even when using the admincp or modcp.

What can I check? Is it warn.php that could be messed up?

[sv1cec]

Originally Posted by SnitchSeeker

Everybody gets only blank screens when they try to warn somebody - even when using the admincp or modcp.

What can I check? Is it warn.php that could be messed up?

Well, I told you to check that your templates are there. Are they? Are you using more than one style?

[SnitchSeeker]

I installed the templates into my "default" skin - which is the only one I use.

All other skins I have adopt attributes from the default skin. So I can't imagine there is a problem in that arena.

But shouldn't we be able to warn from the modcp or admin cp regardless of if the templates were installed into all skins?

[sv1cec]

ModCP does not give you the option to warn. In ModCP, you can only see the issued warnings, in the Warnings Log. The only places you can warn from are AdminCP and the standard forums, from postbit.

If your templates are there, and you still get a blank screen when you try to warn someone, either from admincp or from postbit, I do not know what else to tell you.