Major Help Needed with Warning System Hack

[Rynthar]

Hey guys. Really want Warning System, but it just wont seem to work =( Here is a conversation with Davey that explains the entire situation, what we tried, what I get, etc.

EDIT: Forgot to say I am on 2.3.0 and that I double checked that my code is correct numerous times

_______________________________________________


<Rynthar> Alright
<Rynthar> once I go to install_warning.php
<Rynthar> I click continue
<Rynthar> then I get...
<Rynthar> Query Installer: Running Queries Now!
<Rynthar> Creating Warning Logs Table.
<Rynthar> Warning Logs Table Successfully Created!
<Rynthar> Creating Warnings Table.
<Rynthar> Warnings Table Successfully Created!
<Rynthar> Inserting Defualt Warnings Into Warnings Table
<Rynthar> Defualt Warning Values Successfully Inserted!
<Rynthar> Altering User Table: Adding Warning Level.
<Rynthar> under that I get
<Rynthar> There seems to have been a slight problem with the Xoxide Forum Network database
<Rynthar> inside the database error box is
<Rynthar> Database error in vBulletin Control Panel 2.3.0:
<Rynthar> Invalid SQL: ALTER TABLE user ADD warninglvl int(10) NOT NULL DEFAULT '0'
<Rynthar> mysql error: Duplicate column name 'warninglvl'
<Rynthar> mysql error number: 1060
<Rynthar> Date: Thursday 17th of April 2003 09:46:44 PM
<Rynthar> Script: http://www.xoxideforums.com/admin/install_warning.php?step=2
<Rynthar> Referer: http://www.xoxideforums.com/admin/install_warning.php
<Rynthar> I mean, when I click on the links inside the admin cp it works
<Rynthar> the view warning list link works
<Rynthar> but like, nowhere in the postbit or anything does it show the persons warn levels or anything
<Rynthar> any help is extremely appreciated, the warning system is something i looked very forward to having
<Davey> Delete 'warninglvl'
<Rynthar> ?
<Rynthar> What do you mean
<Davey> You have access to phpMyAdmin?
<Rynthar> no I do not, I have SSH tho
<Rynthar> and the run db query from admin cp
<Davey> Ok umm.
<Rynthar> so those are what all those errors are tho lol
<Davey> Try running this query.
<Davey> ALTER TABLE user DEL warninglvl;
<Davey> Then try reinstalling the hack and tell me what happens.
<Rynthar> when i run the query
<Rynthar> I get Database error in vBulletin Control Panel 2.3.0:
<Rynthar> Invalid SQL: ALTER TABLE user DEL warninglvl;
<Rynthar> mysql error: You have an error in your SQL syntax near 'DEL warninglvl' at line 1
<Rynthar> mysql error number: 1064
<Rynthar> lol
<Davey> Try ALTER TABLE user DROP warninglvl;
<Davey> Sorry I'm not very good with ALTER TABLE.
<Davey> I don't exactly "use" it.
<Rynthar> its weird tho, I dont get any of the things that GForce has in screenie A, B, C, or D
<Rynthar> lol, i understand
<Rynthar> Running ALTER TABLE user DROP warninglvl; ... Success! =)
<Rynthar> I get this now... Database error in vBulletin Control Panel 2.3.0:
<Rynthar> Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
<Rynthar> mysql error: Duplicate entry '40' for key 1
<Rynthar> mysql error number: 1062
<Rynthar> *sighs*
<Davey> Now install it again.
<Rynthar> I did
<Rynthar> thats what I got
<Davey> Hmm.
<Rynthar> like, instead of that error 1060, i got the erro 1064
<Rynthar> you want admin access?
<Davey> Nah I'm okay.
<Davey> I can't help anymore than that.
<Rynthar> *sighs*
<Davey> Ask on vBulletin.org.
<Davey> Um.
<Rynthar> well, do you know where you actually see the screenshots A,B,C, and D?
<Davey> I would ask in Support.
<Davey> Sec.
<Rynthar> like as to why the postbit isnt there, etc
<Davey> ?
<Rynthar> https://vborg.vbsupport.ru/attachment.php?s=&postid=296290
<Rynthar> like that
<Rynthar> I dont know where to see that or anything
<Rynthar> https://vborg.vbsupport.ru/attachment.php?s=&postid=296292 and that and https://vborg.vbsupport.ru/attachment.php?s=&postid=296293
_________________________________________

And thats where it ended =) When I get this working I got a spare Ekko Licence if someone wants one =)

EDIT: Also, I would be willing to give any of you dummy admin access since I am not sure whether I did some of the templates right since we have a custom postbit much different then the postbit in the install.txt file =(

[DigitalDesktops]

hmm, it looks like you have a duplicate column "warninglvl". try going into the user table and dropping that. try using this:

use these queries:

DROP TABLE warnings_log

DROP TABLE warnings

ALTER TABLE user DROP warninglvl

DELETE FROM settinggroup WHERE displayorder=44

DELETE FROM setting WHERE settinggroupid=44

DELETE FROM template WHERE title IN('warn_add','warn_banemail_notify','warn_banemai l_subject','warn_error_cantwarngroup','warn_error_ emptyreason','warn_error_maxwarnlimit','warn_error _noaccess','warn_error_noexist','warn_error_nowarn ings','warn_error_postnoexist','warn_error_whywarn self','warn_getinfo_warning','warn_list','warn_lis ting','warn_pmemail_notify','warn_pmemail_subject' ,'warn_pmno','warn_pmyes','warn_redirect_userban', 'warn_redirect_warnsuccess','warn_seelink','warn_s how','warn_show_warn','warn_userinfo','warn_viewli nk','warn_warnlink') AND templatesetid=-1

Run install_warning.php again and see if it works.

[Rynthar]

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

I get that now

[Rynthar]

for the record, when I run /warn.php I get

Invalid SQL:
SELECT name, warnlvl, points
FROM warnings
ORDER BY (warnlvl) ASC, (worder) ASC
mysql error: Table 'xoxideforums_com.warnings' doesn't exist

mysql error number: 1146

[drives fast]

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1
you have to go into your database and into the settinggroup table and remove that entry as well.
Invalid SQL:
SELECT name, warnlvl, points
FROM warnings
ORDER BY (warnlvl) ASC, (worder) ASC
mysql error: Table 'xoxideforums_com.warnings' doesn't exist

mysql error number: 1146
you are getting that because you have not re-installed the database parts of the hack again after removing everything mentioned in this thread