vb.org Archive - Major Additions - Tournaments, Ladders & Leagues Manager v4.x

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - Tournaments, Ladders & Leagues Manager v4.x (https://vborg.vbsupport.ru/showthread.php?t=238945)

I get this error when saving 'Front Page Banners'

Quote:

Warning: trim() expects parameter 1 to be string, array given in [path]/includes/class_core.php on line 2567

any ideas

Quote:

Originally Posted by Centurios (Post 2260615)

bananalive, can you update version v2.8.4 for 3.8x like you upgrade version for 4.x - new Tournament Types and other options?

+1

Alot of us are stuck on 3.8 with this amazing system. Have over 140 tournaments on my site. Would really need an ported version for 3.8 and i would happily donate to you $50 if you happen to do it, and im sure there are many out there who would do the same too :)

I think im missing something but how do I create a ladder/league/tournament catagories?

Dumb question is there a readme thing thats tells me what is what on here? For example what does groups represent in the Leagues?

Got what I asked before but how do I edit a ladders rules? I see nothing to allow me to do this? When I edit a ladder the only thing I can write is the description

Also how to I even add myself to a ladder, I feel something is missing from my install as this stuff isnt obvious at all

Quote:

Originally Posted by konixxx (Post 2262715)

I uploaded files, imported the product. I set up the permissions and when I try to enter tournament site i have MySQL Error : Table 'xxxxxxxxxxxx.tmnt_categories' doesn't exist
Do i have to add something manually to my database?

Error Number : 1146

I didn't see any response to this. I had the same problem. I'm using mysql5.5.8. 'turns out, none of the tables were created in the install process.

Code:

show tables like 'tmnt%'

returns nothing.
I looked and found the create statements in product-tournament2008.xml
they use the syntax create table blah () Type=MyISAM -- this failed--no longer supported by mysql. I changed all of these to Engine=MyISAM and the install created all the tables successfully.

from mysql: http://dev.mysql.com/doc/refman/5.1/...ate-table.html

Quote:

The older TYPE option was synonymous with ENGINE. TYPE has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed in MySQL 5.5. You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use ENGINE instead. (See Section D.1.62, ?Changes in MySQL 5.1.8 (Not released)?.)

Code:

show tables like 'tmnt%'

 Tables_in_forum (tmnt%)    

 -------------------------- 

 tmnt_activity              

 tmnt_announcements         

 tmnt_banners               

 tmnt_categories            

 tmnt_comments              

 tmnt_ladder_games          

 tmnt_ladder_mcs            

 tmnt_ladder_players        

 tmnt_ladders               

 tmnt_members               

 tmnt_players               

 tmnt_rules                 

 tmnt_teams                 

 tmnt_tmnts

DB error when going to the tournaments and ladders mod

Code:

Database error in vBulletin 4.1.8:



Invalid SQL:

 

                SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle

                FROM NCe_tmnt_categories AS cats

                LEFT JOIN NCe_tmnt_categories AS pcat

                        ON (cats.parentid = pcat.catid)

                LEFT OUTER JOIN NCe_tmnt_tmnts AS tmnts

                        ON (cats.catid = tmnts.catid)

                LEFT OUTER JOIN NCe_tmnt_ladders AS ladders

                        ON (cats.catid = ladders.catid AND ladders.league = 0)

                LEFT OUTER JOIN NCe_tmnt_ladders AS leagues

                        ON (cats.catid = leagues.catid AND leagues.league > 0)

                GROUP BY cats.catid

                ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;



MySQL Error   : Table 'forum.nce_tmnt_categories' doesn't exist

Error Number  : 1146

Request Date  : Wednesday, November 30th 2011 @ 11:21:33 PM

Error Date    : Wednesday, November 30th 2011 @ 11:21:33 PM

Script        : http://localhost/vbulletin/competitions.php

Referrer      : http://localhost/vbulletin/content.php

IP Address    : 127.0.0.1

Username      : owning

Classname     : vB_Database

MySQL Version : 5.5.8



Stack Trace:



#0 vB_Database->halt() called in [path]\includes\class_core.php on line 423

#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 456

#2 vB_Database->query_read() called in [path]\includes\functions_tal.php on line 1442

#3 build_tll_catcache() called in [path]\includes\functions_tal.php on line 133

#4 require_once([path]\includes\functions_tal.php) called in [path]\competitions.php on line 107

I have a problem in which when I try to add someone into the ladder, it is using his old username. For example, I use to have "abc123" and "abc" as members. Then, I change "abc" username into "xyz". When I try to add a player into username and I enter "abc" in the field, it keeps finding my old username, which is now "xyz" and add it into the ladder?

I hope my explanation is clear enough. Thank you. :)

Quote:

Originally Posted by mekmike (Post 2273655)

you already tried: ACP -> Mantenance -> Update counter -> Fix broken userprofiles

Quote:

Finds any users who do not have complete entries in the database. Sometimes the data is not inserted correctly and the user's profile becomes unusable. Running this should correct any incomplete profiles.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)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 (6)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03565 seconds Memory Usage 1,756KB 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 (3)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 (6)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
Messages: