Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2014, 11:38 PM
A Dead Puppie A Dead Puppie is offline
 
Join Date: Oct 2009
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error Installing mod

I'm trying to install a mod, (Point Market 3) and i keep getting a database error with the following:

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE user ADD market_points DECIMAL( 18, 3 ) NOT NULL DEFAULT '1.000';

MySQL Error   : Duplicate column name 'market_points'
Error Number  : 1060
Request Date  : Tuesday, May 13th 2014 @ 08:35:46 PM
Error Date    : Tuesday, May 13th 2014 @ 08:35:46 PM
Script        : http://machinimaevolved.net/admincp/plugin.php?do=productimport
Referrer      : http://machinimaevolved.net/admincp/plugin.php?do=productadd
IP Address    : 24.211.210.104
Username      : dudemanpeace
Classname     : vB_Database
MySQL Version : 5.5.36-cll
I've tried removing the tables and it keeps giving me this
Reply With Quote
  #2  
Old 05-14-2014, 12:10 AM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This should be posted in the modification's thread, as it pertains to the modification. This is not a general programming question. Thank you.
Reply With Quote
  #3  
Old 05-14-2014, 12:14 AM
A Dead Puppie A Dead Puppie is offline
 
Join Date: Oct 2009
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm sorry, there just hasn't been a post since February and none of the authors have been online for quite some time.
Reply With Quote
  #4  
Old 05-14-2014, 12:46 AM
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Location: Michigan
Posts: 2,310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Where can I find this plugin, here on the org?
Reply With Quote
  #5  
Old 05-14-2014, 12:58 AM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here you go!

https://vborg.vbsupport.ru/showthread.php?t=232676
Reply With Quote
  #6  
Old 05-14-2014, 12:58 AM
A Dead Puppie A Dead Puppie is offline
 
Join Date: Oct 2009
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Edit - tbworld beat me to it xD
Reply With Quote
  #7  
Old 05-14-2014, 01:00 AM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by A Dead Puppie View Post
Edit - tbworld beat me to it xD
Then it's a first.

--------------- Added 13 May 2014 at 19:04 ---------------

Quote:
Originally Posted by A Dead Puppie View Post
I'm trying to install a mod, (Point Market 3) and i keep getting a database error with the following:
Have you uninstalled this, then reinstalled? If the MySql is not coded correctly, reinstalling the MOD could give you a duplicated column error. This can also happen on multiple views across two or more tables with the same name -- although I realize this information is unhelpful.
Reply With Quote
Благодарность от:
blind-eddie
  #8  
Old 05-14-2014, 01:14 AM
A Dead Puppie A Dead Puppie is offline
 
Join Date: Oct 2009
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can't un-uninstall, since I'm receiving the error as the mod is being installed. I've removed the tables and even re-uploaded the files and then tried to re-install, to the same error.
Reply With Quote
  #9  
Old 05-14-2014, 01:15 AM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would not uninstall... That is usually a very bad idea -- unless you know what you are doing. Show us the error when you try to reinstall. Reminder: You should always have a complete backup of your board when trying a new modification.
Reply With Quote
  #10  
Old 05-14-2014, 01:17 AM
A Dead Puppie A Dead Puppie is offline
 
Join Date: Oct 2009
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ahk. Wonderful :/
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:24 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04118 seconds
  • Memory Usage 2,254KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (1)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)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_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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete