A few annoying problems....

[Shpookdefied]

Well, I'm experiencing a few problems that are really annoying for my staff and my members.

A: Every now and then, when you click on a link, you just get a blank page and have to refresh.

B: Whenever you click on someones profile you get this error:

Fatal error: Call to undefined function: checkwarnlink() in /home/hazelboy/public_html/Forums/member.php on line 1397

C: After removing the Warning System Hack, I run into this error when trying to reinstall:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: ALTER TABLE user ADD warninglvl int(10) NOT NULL DEFAULT '0'
mysql error: Duplicate column name 'warninglvl'

mysql error number: 1060

Date: Wednesday 29th of January 2003 09:04:03 PM
Script: http://www.TheNemesis.net/Forums/Forums/admin/install_warning.php?step=2
Referer: http://www.thenemesis.net/Forums/admin/install_warning.php?


I was told to go thru phpMyAdmin and delete the query, but I don't have it installed, and don't have the time to install it right now. The only problem this is causing is the warning links don't show up in the post-bit.

D: After installing vBPad, the options show up under Warnings Systems in the adminCP.

Anyone willing to offer advice? It would be nice to get all of these fixed. :D

Thank you for your time,

- Shpook

[Iguana]

Wait, correct me if i read your post wrong, but you're trying to re-install your board?

[mr e]

well if you want to get rid of the column from the db, run this query, i think it should do it


ALTER TABLE user DROP warninglvl

[Iguana]

He can run queries from the Admin CP? I didn't know that was possible...

[Shpookdefied]

Iguana: No, I'm just reinstalling the Warning System Hack.

mr e: Thank you, will go try this now. I'll let you know how it goes.

Iguana: with phpMyAdmin, I believe you can.

[TECK]

B. Function checkwarnlink() is not present in functions.php file.
C. You forgot to remove also the hack changes.

I strongly recommend you to upload all vBulletin files and restore the database to an unhacked version.
Also, always install a hack on a test board first, not a live one.

[Iguana]

Originally posted by Shpookdefied

Iguana: with phpMyAdmin, I believe you can.

Yes, I know you can run queries from phpMyAdmin, but didn't you say: I was told to go thru phpMyAdmin and delete the query, but I don't have it installed, and don't have the time to install it right now.

Since you don't have phpMyAdmin installed. and you can't run queries from the Admin CP in vBulletin, where are you going run th query from?

[Shpookdefied]

TECK: Thank you, I've got the problem sorted out. I had to re-format my hard rive, and haven't had time to re-download phpTriad, thats why I didn't install it on a test bord. I'm probably just going to to make a new mySQL databse on my host and run a test board from there, that way my admins can access it and help me.

Iguana: Sorry, I misunderstood. I use Logician's Query Running script to run all my queries.

Does anyone know how to fix A and D? A is the only one I'm really worried about.

[TECK]

Why are you using PhpTriad? Do it manually, is the best way. Triad only screws everything.
A. Check your code.
D. Check your code.

[Shpookdefied]

Well, that's the thing, I don't know exactly where to check. I'm not very keen on PHP, and I'm still in the process of learning.