vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375)

chriskellar 10-20-2008 04:49 PM

Quote:

Originally Posted by bananalive (Post 1648783)
Why uninstall it manually when you can just click uninstall in admincp, which removes all data :confused:

I've tried that many times and it won't work. This is the error I get when trying to uninstall it.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

DROP TABLE vB_tmnt_tmnts;;

MySQL Error  : Unknown table 'vB_tmnt_tmnts'
Error Number  : 1051
Request Date  : Monday, October 20th 2008 @ 11:48:22 AM
Error Date    : Monday, October 20th 2008 @ 11:48:23 AM


bananalive 10-20-2008 05:15 PM

Quote:

Originally Posted by chriskellar (Post 1649029)
I've tried that many times and it won't work. This is the error I get when trying to uninstall it.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

DROP TABLE vB_tmnt_tmnts;;

MySQL Error  : Unknown table 'vB_tmnt_tmnts'
Error Number  : 1051
Request Date  : Monday, October 20th 2008 @ 11:48:22 AM
Error Date    : Monday, October 20th 2008 @ 11:48:23 AM


Admincp -> Plugins & Products -> Manage Products -> Edit vB Tournaments and Ladders -> Existing Install/Uninstall Code ( You may need to scroll down page to see it)
For every Uninstall Code box (all the ones on the right) change DROP TABLE to DROP TABLE IF EXISTS in product

SpiderFive 10-20-2008 05:17 PM

no problems:)

RK1gaming 10-20-2008 05:21 PM

yup upgraded no problems ... so far I am liking this add in ... very nice

I would add in the following for your next build or future builds

The ability to add in more Tournament Modes: - I know we would use more or custom ones for our site

I like the post bit and the bracket colors I think thats a good add in ... keep up the good work

chriskellar 10-20-2008 05:59 PM

Quote:

Originally Posted by bananalive (Post 1649051)
Admincp -> Plugins & Products -> Manage Products -> Edit vB Tournaments and Ladders -> Existing Install/Uninstall Code ( You may need to scroll down page to see it)
For every Uninstall Code box (all the ones on the right) change DROP TABLE to DROP TABLE IF EXISTS in product

Ok tried that and got a different error.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_usergroup DROP COLUMN tournamentpermissions;;

MySQL Error  : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number  : 1091
Request Date  : Monday, October 20th 2008 @ 12:58:01 PM
Error Date    : Monday, October 20th 2008 @ 12:58:01 PM

I tried to put "IF EXISTS" for that part, but it gives me a sql error.

bananalive 10-20-2008 06:35 PM

Quote:

Originally Posted by chriskellar (Post 1649084)
Ok tried that and got a different error.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_usergroup DROP COLUMN tournamentpermissions;;

MySQL Error  : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number  : 1091
Request Date  : Monday, October 20th 2008 @ 12:58:01 PM
Error Date    : Monday, October 20th 2008 @ 12:58:01 PM

I tried to put "IF EXISTS" for that part, but it gives me a sql error.

Unfortunately that mysql function (DROP COLUMN IF EXISTS) doesn't exist so just remove that query

chriskellar 10-20-2008 07:28 PM

Quote:

Originally Posted by bananalive (Post 1649121)
Unfortunately that mysql function (DROP COLUMN IF EXISTS) doesn't exist so just remove that query

Ok got it uninstalled. Now I'm moving forward with installing the upgraded version and here is the error that I'm getting.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_user ADD tmnt_joins INT(10) NOT NULL DEFAULT '0' ;;

MySQL Error  : Duplicate column name 'tmnt_joins'
Error Number  : 1060
Request Date  : Monday, October 20th 2008 @ 02:27:08 PM
Error Date    : Monday, October 20th 2008 @ 02:27:09 PM


The DaveyG 10-20-2008 09:23 PM

This is great. Has a player invite system been set up yet? I don't see one and would love the feature. Also a league setup would be awesome. Thanks for this mod.

butler312 10-20-2008 10:23 PM

Quote:

Originally Posted by The DaveyG (Post 1649262)
This is great. Has a player invite system been set up yet? I don't see one and would love the feature. Also a league setup would be awesome. Thanks for this mod.

A league would be freaking sweet, that automatically would generate schedules and then have playoff options and all sorts of stuff. But that is almost a completely different mod. What might be a good idea in the future though from banana's perspective is to make that a professional mod that will integrate with this one.

jackapup 10-20-2008 10:43 PM

Are you going to featuring a double elimination function anytime soon with the script?


All times are GMT. The time now is 09:35 AM.

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.02253 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete