Getting SQL Error , pls help

Hi,

first of all, i have to say, that i have used the Warning Hack from ZeroTolerance 1.5.

By mistake i runned first the install script for AWS 3.1.9 instead of the upgrade script.

Afterwards i have run the upgrade Script, no special Messages. Have edited all the Files.

I have set the setting in the Admincp :

If i hit "View Warnings Log" in Admincp, i am getting follwoing SQL Error :

Ungueltige SQL-Abfrage: 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
	warnings w
	left join user wuser on(wuser.userid=w.warned_user)
	left join user u on(u.userid=w.warned_by)
	left join user ruser on(ruser.userid=w.removed_by)
	left join warning_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

all other options are working there.


Second Problem. :

If i try to Warn somebody from Postbit Legacy, i am gettin following Error :

Ungueltige SQL-Abfrage: select * from warnings where warned_post='86444' AND warned_status='A'
mysql error: Unknown column 'warned_status' in 'where clause'

mysql error number: 1054

Coudl somebody help me ?


gr33tz

[taffy056]

Hi,

Getting a similar error message on the upgrade from Zero Tolerance's hack, I am using vb 3.0.7 though.

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
 warnings w
 left join user wuser on(wuser.userid=w.warned_user)
 left join user u on(u.userid=w.warned_by)
 left join user ruser on(ruser.userid=w.removed_by)
 left join warning_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

 Database error in vBulletin 3.0.7:
Invalid SQL: select * from warnings where warned_post='2800' AND warned_status='A'
mysql error: Unknown column 'warned_status' in 'where clause'
mysql error number: 1054
Date: Sunday 06th of March 2005 10:22:16 PM

[sv1cec]

Add the missing column, by running the following queries:

ALTER TABLE `".TABLE_PREFIX."warnings ADD COLUMN removed_by int(15)

ALTER TABLE `".TABLE_PREFIX."warnings ADD COLUMN removed_date int(15)

ALTER TABLE `".TABLE_PREFIX."warnings ADD COLUMN warned_status char(1)

ALTER TABLE `".TABLE_PREFIX."warnings ADD COLUMN caused_ban char(1)

These should fix the missing fields.

Let me know if you get any more errors. It's strange, because these fields exist in the upgrade_warn.php file, and of course, in the install_warn.php file, so they should have been created in either case.

Rgds

[taffy056]

Hi sv1cec,

Those queries did not work for me, what I did instead was uninstall using the uninstaller.php and then done a reinstall afterwards, that seemed to work fine, and now I have the AWS up and working fine So maybe H@K@N should try the same if thequery does not work for him.

thanks

[H@K@N]

4 me it worked .... but not with the Strings which was mentioned.

Don't know exactly, but i think the apostroph infront the Table_Prefix is not correct, so i have done this Statement in phpmyadmin, without Prefix.

Now its working ....

gr33tz

[sv1cec]

LoL,

yes, the queries wouldn't work, not because of the first single quote, but because of a missing second single quote:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN removed_by int(15)

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN removed_date int(15)

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN warned_status char(1)

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN caused_ban char(1)

Sorry folks, I keep saying to myself, not to answer questions early in the morning.

Rgds

[taffy056]

Hi sv1cec,

Thanks for the heads up , anyway I am really happy with this hack, thanks very much for sharing!!

[sv1cec]

Originally Posted by taffy056

Hi sv1cec,

Thanks for the heads up , anyway I am really happy with this hack, thanks very much for sharing!!

Most welcome!