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)

bananalive 09-29-2008 08:11 PM

1 Attachment(s)
Quote:

Originally Posted by bananalive (Post 1633357)
Sorry yes there's an error with PM sending to user being challenged. (Fix will be released with next version.)

v2.4.2 BETA 2
- contains ladder challenge fix

mlthmp 09-29-2008 08:24 PM

OK.. just uploaded the files form the BETA 2 zip.
When I tried to import the file, I get this.

Invalid SQL:
ALTER TABLE vb_usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'ladderpermissions'
Error Number : 1060
Request Date : Monday, September 29th 2008 @ 05:22:50 PM
Error Date : Monday, September 29th 2008 @ 05:22:53 PM

bananalive 09-29-2008 08:37 PM

Quote:

Originally Posted by mlthmp (Post 1633378)
OK.. just uploaded the files form the BETA 2 zip.
When I tried to import the file, I get this.


Invalid SQL:
ALTER TABLE vb_usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'ladderpermissions'
Error Number : 1060
Request Date : Monday, September 29th 2008 @ 05:22:50 PM
Error Date : Monday, September 29th 2008 @ 05:22:53 PM

find and delete in product file
Code:

$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;");

mlthmp 09-29-2008 09:03 PM

When I did that, I kept getting the same error, for different tables.

So, instead I went in via myphpadmin and physically found, and deleted every table, or addition to existing tables the modification created. Took awhile, but when I was done, it installed correctly.

I have one suggestion. Is it possible to create, and include an additional file that will delete all modification DB changes encase anyone ever wants or needs to uninstall? I know some phpbb mods include an install / uninstall file you can upload, and click on to add/remove tables. Maybe something like that is possible here?

I know it was sure a hassle to find, and remove all the DB tables by hand, lol. Maybe save someone some heartbreak if they ever need to remove to upgrade or something?

BTW, I like the merged mods. Looks great together! Great job!

gamerscms 09-29-2008 09:08 PM

Still getting the PM error:

Please complete both the subject and message fields.

mlthmp 09-29-2008 09:19 PM

Found one small error to add.

When a user adds a comment to an event, it pops up the message that its been entered, and click here if you do not wish to wait. Clicking does nothing, and the message just stalls.

No biggie, the guys can just use the back button.. but just wanted to let you know.

AK47 Nemesis 09-30-2008 09:45 AM

Small sugestion: Maybe you could add a section to put rules? That would be great.

rob01 09-30-2008 04:03 PM

hey im trying to install the new tournament
but if i drop the tournament mob i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_tmnt_activity;;
MySQL Error : Unknown table 'vbb_tmnt_activity'

and if i drop ladder i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_ladders;;
MySQL Error : Unknown table 'vbb_ladders'

but i already try adding the vbb_ladders table with mysql, but still i get the same error :(
any help? pleas thanks :)

indie2industry 09-30-2008 04:58 PM

is there a way to change the color of the brackets?? I have an all black VB and no one can see the actual brackets :o

Chris11987 10-01-2008 04:27 AM

I'm having a big problem.... I can't update usergroups because of a table from the tournament. I tried to uninstall the tournament and this is what I get everytime:

Quote:

Invalid SQL:

DROP TABLE vb_tmnt_activity;;

MySQL Error : Unknown table 'vb_tmnt_activity'
Error Number : 1051
I tried reinstalling and upgrading the tournament as well, and no luck. I haven't even used the tournament software in about a week, so I'm unsure as to why it suddenly did this. I checked phpmyadmin and the table doesn't exist. What do I do here?

fyi: I was using/reinstalled/upgraded with version 2.4.

edit: This is the error I get when trying to update a usergroup:
Quote:

MySQL Error : Unknown column 'tournamentpermissions' in 'field list'
Error Number : 1054
Both of those are missing form the db, even after I update the product again.


All times are GMT. The time now is 03:01 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.02598 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)bbcode_code_printable
  • (4)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