View Single Post
  #165  
Old 09-23-2004, 02:28 PM
Harley D's Avatar
Harley D Harley D is offline
 
Join Date: Jan 2003
Location: WagnerTech.net
Posts: 266
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by xTerMn8R
I had a lot of these types of problems with my hacks after upgrading from 3.01 to 3.03. How i fixed it was looked at the error and went into phpmyadmin and dropped and entries that continued to come up.(ie. in ur case here the "Usergroup" table 'shoutboxpermissions' entry

After finally getting rid of all the Table Modifications associated with the hack was I able to do fresh installs of the hacks... Its a time consuming process, but it works and can turn out to be less time consuming then other methods.

***Note*** Here's a tip .. If ya drop a table entry error and try and install the hack and it errors at a new point further along then the previous error spot then you'll probably need to drop BOTH table Mods again and so on and so forth for as many as there are. SO I just Copy and pasted them into a txt file and then I had the Hack Table Mods on file.

Good luck
Thanks, This did help alot, However the table additions that the install script errored on still have to be installed manually in order for the hack to work.
So If someone that is MYSQL talented could help us add these frases manually in th ADMINCP by properly wording and formatting the SQL table additions, this would be all that is left to get my clients Shout Box working.

Evething is showing on the page, but the Shot Box iss empty, I believe its due to PERMISSIONS, I cannot edit them in the ADMINPC because there is nothing under USERGROUPS, and it just happens that this is where the install script errored. I removed 2 table edits from the install script to get it to complete the install as instructed above.

Here is the installs table edits that I had to remove in order for the install script to complete.


ALTER TABLE . TABLE_PREFIX . usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions

and

"ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL, ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL",

I need these typed so I can cut and paste it into the ADMINCP's Execute SQL Query box.
This should add the Shout Box in my user groups, so I may change the permissions, so It can be viewed.

Am I making sense?? LOL
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01737 seconds
  • Memory Usage 1,768KB
  • 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
  • (1)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_onlinestatus
  • (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
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete