The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Major Help Needed with Warning System Hack Details »» | |||||||||||||||||||||||||
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/in...ing.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/attachmen...&postid=296290 <Rynthar> like that <Rynthar> I dont know where to see that or anything <Rynthar> https://vborg.vbsupport.ru/attachmen...&postid=296292 and that and https://vborg.vbsupport.ru/attachmen...&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 =( Show Your Support
|
Comments |
#2
|
|||
|
|||
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: PHP Code:
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
Quote:
Quote:
|
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|