View Single Post
  #136  
Old 08-22-2004, 01:19 AM
xTerMn8R xTerMn8R is offline
 
Join Date: Mar 2004
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ShutDown23
On 3.0.1 when I am trying to install it get:

BV Shoutbox Installation - Running MySQL Queries
Dropping shout table (if it exists)... Done
Creating shout table... Done
Deleting setting group (if it exists)... Done
Deleting setting group phrase (if it exists)... Done
Creating setting group... Done
Creating permissions collumn...

There seems to have been a slight problem with the ******** database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.1:

Invalid SQL: ALTER TABLE usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions
mysql error: Duplicate column name 'shoutboxpermissions'

mysql error number: 1060

Date: Saturday 24th of April 2004 05:00:45 PM
Script: http://www.**********.com/forums/adm...ut_install.php
Referer: http://www.**********.com/forums/adm...ut_install.php
Username: Admin
IP Address: ***.***.***.**
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
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01329 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