vb.org Archive - Major Additions - Forum Tournaments & Ladders

Database error in vBulletin 3.7.4:



Invalid SQL:

UPDATE tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1

Error Number  : 1064

Request Date  : Monday, November 24th 2008 @ 09:04:15 PM

Error Date    : Monday, November 24th 2008 @ 09:04:16 PM

Script        : http://www.com/forum/competitions.php?do=ladderteamreject&id=3

Referrer      : http://www.com/forum/competitions.php?do=ladderteamchallenges

IP Address    : ************

Username      : **********

Classname     : vB_Database

MySQL Version : 5.0.51a-community

Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.

honcho

11-25-2008 10:49 PM

Quote:

Originally Posted by honcho (Post 1672090)

how do i do this please

its ok i did it by editing config.php file

KHALIK

11-26-2008 10:24 AM

Quote:

Originally Posted by camomouse (Post 1631329)

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:



                        SELECT t.champion, u.userid FROM tournaments AS t

                        LEFT JOIN user AS u ON (t.champion = u.username)

                        WHERE champion<>'';



MySQL Error   : Unknown column 't.champion' in 'field list'

Error Number  : 1054

Request Date  : Friday, September 26th 2008 @ 08:57:34 PM

Error Date    : Friday, September 26th 2008 @ 08:57:35 PM

Script        : http://xaax.biz/forums/showthread.php?t=12346

Referrer      : http://xaax.biz/forums/halo_3/

IP Address    : 71.28.9.189

Username      : CamoMouse

Classname     : vB_Database

MySQL Version : 5.0.51b-community-nt

How do I get that to stop? There are now plugins installed of Tournaments. As far as I know, Tournaments should not exits on my site but I'm getting nothing but MySql errors when you visit my site. I need help.

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Table 'fragmast_khalik59.tournaments' doesn't exist
Error Number : 1146
Request Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Error Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Script : http://www.fragmasters.co.uk/forum/s...ad.php?t=28186
Referrer : http://www.fragmasters.co.uk/forum/index.php
IP Address : 194.106.36.230
Username : Fragmaster
Classname : vB_Database
MySQL Version : 5.0.51a

I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.

How do I stop it ?

corizo

11-26-2008 01:49 PM

Feature Requests:

Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
It would be nice to add names without being them registered users
Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
Fight for 2nd and 3rd place in tournaments
Being able to deactivate the ladder system if you don't need it

However, it's already a great modification! :)

Thanks for reading

OcR Envy

11-26-2008 01:54 PM

Quote:

Feature Requests:

Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
It would be nice to add names without being them registered users
Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
Fight for 2nd and 3rd place in tournaments
Being able to deactivate the ladder system if you don't need it

However, it's already a great modification! :)

Thanks for reading

Agreed.

+ Requests:

1. Randomized Map/Gametype that is tournament specific.
2. Ability to Report Wins/Loses to Tournament Mod to make advancement quicker.
3. Addition to the vB Notification system for said reports and Team Invites/Requests to join.

Toupsx

11-26-2008 03:15 PM

Quote:

Originally Posted by djlotus (Post 1672187)

Is "OD" the correct table prefix?

yes.

dirtyfeast

11-26-2008 08:44 PM

Quote:

Originally Posted by KHALIK (Post 1673257)

I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.

How do I stop it ?

I want to say that is your arcade tournaments. No database tables with this mod have the word tournaments in it. They all start tmnt and than whatever the table is for. tournaments is a database table for the arcade system.

dirtyfeast

11-26-2008 08:46 PM

Quote:

Originally Posted by dirtyfeast (Post 1672417)

Code:

Database error in vBulletin 3.7.4:



Invalid SQL:

UPDATE tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1

Error Number  : 1064

Request Date  : Monday, November 24th 2008 @ 09:04:15 PM

Error Date    : Monday, November 24th 2008 @ 09:04:16 PM

Script        : http://www.com/forum/competitions.php?do=ladderteamreject&id=3

Referrer      : http://www.com/forum/competitions.php?do=ladderteamchallenges

IP Address    : ************

Username      : **********

Classname     : vB_Database

MySQL Version : 5.0.51a-community

I want to add that this is with the Teams for the ladders. It works fine with just members of the forum joing the Player ladders. Could this issue be caused because you create a team name rather using the username of the forums.

Techno05

11-29-2008 12:10 AM

How can I place the postbit information under CSS?

Preview:
https://vborg.vbsupport.ru/external/2008/11/4.png

All times are GMT. The time now is 03:06 AM.

Page 109 of 213

109

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02886 seconds Memory Usage 1,759KB 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 (8)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: