The Arcive of Official vBulletin Modifications Site.

A few annoying problems.... · **Released**: 01-30-2003

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:

Quote:

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:

Quote:

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/For...ing.php?step=2
Referer: http://www.thenemesis.net/Forums/adm...l_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.

Thank you for your time,

- Shpook

Iguana · #2 01-30-2003, 02:11 AM

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

mr e · #3 01-30-2003, 02:19 AM

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

PHP Code:


			
ALTER TABLE user DROP warninglvl

Iguana · #4 01-30-2003, 02:21 AM

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

Shpookdefied · #5 01-30-2003, 02:34 AM

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 · #6 01-30-2003, 06:51 AM

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 · #7 01-30-2003, 02:48 PM

Quote:

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:

Quote:

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 · #8 01-30-2003, 07:23 PM

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 · #9 01-31-2003, 07:01 AM

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 · #10 01-31-2003, 07:26 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.12752 seconds Memory Usage 2,289KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!