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

[Delphiprogrammi]

hi,

seems like your database is missing some fields .... always download the latest zip and hit install if u use aws hack (this will notify u if John updates it) to add that field run

ALTER TABLE warnings ADD COLUMN warned_status char(1);

if you use a "TABLE_PREFIX" you must add it before the tablename (warnings in this case) the cause of your problem is an out of date installation try to uploaded the latest files and see if that resolves your problem.(open install_warn.php there you can see the MySQL schemas)

[sv1cec]

Originally Posted by SnitchSeeker

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:


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):

Are you using a table prefix equal to '1'?

If you check the errors, you will notice that all the queries have the digit 1 in front of the table name. Is that needed or you just entered that 1 somewhere by mistake?

[SnitchSeeker]

Originally Posted by sv1cec

Are you using a table prefix equal to '1'?

If you check the errors, you will notice that all the queries have the digit 1 in front of the table name. Is that needed or you just entered that 1 somewhere by mistake?

The guy that installed vb for me in the beginning added the one to the table prefix by mistake and now all the tables have that!

Originally Posted by Delphiprogrammi

hi,

seems like your database is missing some fields .... always download the latest zip and hit install if u use aws hack (this will notify u if John updates it) to add that field run

ALTER TABLE warnings ADD COLUMN warned_status char(1);

if you use a "TABLE_PREFIX" you must add it before the tablename (warnings in this case) the cause of your problem is an out of date installation try to uploaded the latest files and see if that resolves your problem.(open install_warn.php there you can see the MySQL schemas)

I don't see how I could have anything but the latest version since I downloaded it and installed it the very same day (only minutes apart) which was like 2 days ago (the day I started this thread).

[SnitchSeeker]

Why does it look like my thread is getting ignored??

Does this mean there is no hope for this working and I should uninstall it?

How do I fix the mysql tables back to how they were before the install then?

[sv1cec]

Originally Posted by SnitchSeeker

Why does it look like my thread is getting ignored??

Does this mean there is no hope for this working and I should uninstall it?

How do I fix the mysql tables back to how they were before the install then?

Well, your thread is not noticed because vBulletin.org is not always sending me emails to let me know people have answered.

Now, you know that you are using table prefix 1. Run the query suggested, only add that 1 in front of the table name.

ALTER TABLE 1warnings ADD COLUMN warned_status char(1);

Tell us what happens.

[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

[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.

[SnitchSeeker]

Originally Posted by sv1cec

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.

Thank you! That seems to have fixed the sql errors!

When inside a thread, I still get only a blank white screen when I click "warn ___" or "view ___'s warnings".

But it looks like it will work if I warn them through the admin cp. (I haven't tried it, but at least I don't get any sql errors when I click the links in the menu any more.)

[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