vb.org Archive - View Single Post - [RELEASE] Private Messaging (PM) Hack, v 1.2.0

#76 09-16-2000, 03:26 PM

This thing just doesn't want to work... I tried what you said, and still received an error:

Quote:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup DROP canusepm
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Saturday 16th of September 2000 12:01:52 PM
Script: /forums/makeprivtables.php

I ran it again after that, and got a new error:

Quote:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup DROP canusepm
mysql error: Can't DROP 'canusepm'. Check that column/key exists
mysql error number: 1091
Date: Saturday 16th of September 2000 12:03:44 PM
Script: /forums/makeprivtables.php

According to that error, it can't find 'canusepm' so it can drop it... so I commented out the command in makeprivtables.php that drops that table and tried again...

Quote:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canusepm TINYINT (4) DEFAULT '1' not null
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Saturday 16th of September 2000 12:04:52 PM
Script: /forums/makeprivtables.php

Just to clear up a few little things that could be causing this... lemme make sure I've done everything right here....

I uploaded makeprivtables.php to my /forums/ directory, and that's the ONLY file I have uploaded for this hack. In the php file it includes "global.php", which would mean it's including the global.php from the /forums/ directory and not the /forums/admin/ directory... is all of this correct? If so, I have NO clue why it's having so much trouble modifying the tables. It seems like it loses the MySQL connection ever time it's creating "canusepm", then runs into an error if I try again because it's trying to add a duplicate column... and this happens over and over. I hope somebody can help, I'd really like to get this hack working

Thanks.

-Tom

[Edited by Tomeeboy on 09-16-2000 at 12:29 PM]

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01012 seconds Memory Usage 1,764KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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 showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: