Thread: Major Additions - MySmilies VB (v3.7.0)
View Single Post
  #40  
Old 05-18-2008, 02:52 PM
Betablocker Betablocker is offline
 
Join Date: Oct 2004
Location: NorthWest England
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Mosh View Post
Uninstall the product, do all the queries, then re-install the product, that should fix it up.

Let me know if it does not work if you do it in that order.
Sorry to be the only one with problems

I did it again the right order.....nothing to uninstall i must have done it already.

So i got this error for each step but with different table names..

An error occurred while attempting to execute your query. The following information was returned.
error number: 1091
error desc: Can't DROP 'mysmiliesvb_totalsize'; check that column/key exists


When i try to install now i get this error


Database error in vBulletin 3.7.0:

Invalid SQL:
ALTER TABLE DTP_usergroup ADD mysmiliesvb_permissions INT DEFAULT 1 NOT NULL;

MySQL Error : Duplicate column name 'mysmiliesvb_permissions'
Error Number : 1060
Request Date : Sunday, May 18th 2008 @ 04:31:18 PM
Error Date : Sunday, May 18th 2008 @ 04:31:18 PM
Script : http://www.webaddy/vb/admincp/plugin...=productimport
Referrer :
IP Address : ip
Username : Betablocker
Classname : vB_Database
MySQL Version : 5.0.27

But if i go into phpmyadmin i can see DTP_mysmiles blah blah
and if i click on it i get 9 tables ......

i dont play in there very often but just went to look again.........last time i ticked them all and dropped them......me noob


So sorry to be a pain.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01029 seconds
  • Memory Usage 1,765KB
  • 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