vb.org Archive
Page 21 of 54 « First 111920 21 222331 Last »
Show 40 post(s) from this thread on one page

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)

mlthmp 10-16-2008 06:24 PM
Installed latest version. The Rules link is now showing up. However when you click on it it gives you a DB error.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'smallbal_vbforums.vb_tmnt_rules' doesn't exist
Error Number : 1146

Installed with yes for overwrite selected.

gamerscms 10-16-2008 06:30 PM
Testing latest release, will report any bugs i find.

bananalive 10-16-2008 07:16 PM
Quote:
Originally Posted by mlthmp (Post 1646536)
Installed latest version. The Rules link is now showing up. However when you click on it it gives you a DB error.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'smallbal_vbforums.vb_tmnt_rules' doesn't exist
Error Number : 1146

Installed with yes for overwrite selected.
have you tried the rules fix here

MarceloS 10-16-2008 07:52 PM
Hi!

When I try to import the product, i get this:

Code:
Database error in vBulletin 3.7.2:

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

MySQL Error  : Duplicate column name 'threadid'
Error Number  : 1060

Timmsy 10-16-2008 07:54 PM
Same here MarceloS

darkforce114 10-16-2008 08:03 PM
Quote:
Originally Posted by Timmsy (Post 1646595)
Same here MarceloS
Same issue.

Database error in vBulletin 3.7.3:

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

MySQL Error : Duplicate column name 'threadid'
Error Number : 1060

mlthmp 10-16-2008 10:24 PM
Quote:
Originally Posted by bananalive (Post 1646566)
have you tried the rules fix here


:o

Nope, I missed that one. Im sorry.. That did the trick! Thanks!

TrIn@dOr 10-17-2008 01:24 AM
Same here.

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;

MySQL Error  : Duplicate column name 'rank'
Error Number  : 1060

IGCEMA 10-17-2008 09:19 AM
Same problem as above.

P.Jackson 10-17-2008 10:35 AM
anyone got any ideas how to place an image into the description?

JAnders 10-17-2008 03:21 PM
the guys with the alter issue?

what version are you updating to? I'm looking at the xml for the lastest version and I don't see the alter statement is giving you a hard time.

Revvin 10-17-2008 03:39 PM
Will there be a feature to add a separate rules page for each ladder/tournament and can ladder challenges be automatically PM'd to the challenger?

Fivetide 10-17-2008 04:19 PM
this looks great !

bananalive 10-17-2008 05:20 PM
For those with database errors which version are you upgrading from?

powerbook 10-17-2008 05:51 PM
Upgrading from 2.4.9

Quote:
Originally Posted by bananalive (Post 1647156)
For those with database errors which version are you upgrading from?

drmitaly 10-17-2008 06:00 PM
<font color="DarkRed">Database error in vBulletin 3.7.0:

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

MySQL Error : Duplicate column name 'threadid'
Error Number : 1060</font>

im not upgrading.
Its a new install of 2.5.7

... can you help me?

Timmsy 10-17-2008 06:09 PM
Quote:
Originally Posted by bananalive (Post 1647156)
For those with database errors which version are you upgrading from?
im not upgrading.
Its a new install of 2.5.7

msimonds 10-17-2008 06:40 PM
bananlive,

I have to say that this seems to be an outstanding add on. I thought of doing this one time for my sports site for Sports team tournaments, like American College Basketball or other sports.

do you have any thoughts of adding these features to your script?

Outstanding job sir!!!

bananalive 10-17-2008 06:47 PM
1 Attachment(s)
For New Installs:
Use Attachment 88248 to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Then import Attachment 88249 which is updated product file for mod

For upgrades:
Import Attachment 88249 which is updated product file for mod

RK1gaming 10-17-2008 07:11 PM
ok thanks ... just got the error and came back for you new xml and saw this post ..

powerbook 10-17-2008 07:29 PM
ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;


Quote:
Originally Posted by bananalive (Post 1647210)
For New Installs:
Use Attachment 88248 to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Then import Attachment 88249 which is updated product file for mod

For upgrades:
Import Attachment 88249 which is updated product file for mod

bananalive 10-17-2008 07:31 PM
Quote:
Originally Posted by powerbook (Post 1647235)
ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;
Are you new install or upgrade?

conker1 10-17-2008 07:35 PM
i got this error

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:

  INSERT INTO `vbtmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here');

MySQL Error  : Duplicate entry '1' for key 1
Error Number  : 1062
and errorfix2008.xml

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vbusergroup DROP COLUMN tournamentpermissions;;

MySQL Error  : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number  : 1091

powerbook 10-17-2008 07:37 PM
I had a install...Run the errorfix checked DB removed tables then run install..

Quote:
Originally Posted by bananalive (Post 1647236)
Are you new install or upgrade?

bananalive 10-17-2008 07:39 PM
Quote:
Originally Posted by conker1 (Post 1647239)
i got this error
Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.
Code:
$vbulletin->db->query_write("
  INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here')");

powerbook 10-17-2008 07:45 PM
There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...

Quote:
Originally Posted by powerbook (Post 1647242)
I had a install...Run the errorfix checked DB removed tables then run install..

bananalive 10-17-2008 07:45 PM
Quote:
Originally Posted by powerbook (Post 1647242)
I had a install...Run the errorfix checked DB removed tables then run install..
The product-errorfix.xml has code (see below) to remove ladder players data tables so you should not get multiple column error.
PHP Code:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
"); 

bananalive 10-17-2008 07:47 PM
Quote:
Originally Posted by powerbook (Post 1647251)
There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...
it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.

powerbook 10-17-2008 07:56 PM
From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");


Quote:
Originally Posted by bananalive (Post 1647254)
it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.

bananalive 10-17-2008 08:07 PM
Quote:
Originally Posted by powerbook (Post 1647259)
From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
Everything in installcode execs on product install and everything in uninstall execs on product uninstall
Code:
<code version="2.4.2.1">
                        <installcode><![CDATA[
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `noplayers` int(3) NOT NULL,
  `status` int(3) NOT NULL,
  `cr_userid` int(10) NOT NULL,
  `cr_username` varchar(100) NOT NULL,
  `cr_time` int(10) NOT NULL,
  `cr_ip` varchar(100) NOT NULL,
  `ed_userid` int(10) NOT NULL,
  `ed_username` varchar(100) NOT NULL,
  `ed_time` int(10) NOT NULL,
  `ed_ip` varchar(50) NOT NULL,
  `threadid` int(10) NOT NULL,
  `views` int(10) NOT NULL default '0',
  `winpoints` int(10) NOT NULL default '2',
  `drawpoints` int(10) NOT NULL default '1',
  `losepoints` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
  `id` int(11) NOT NULL auto_increment,
  `u` int(10) NOT NULL,
  `u2` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `accepted` int(10) NOT NULL,
  `lid` int(11) NOT NULL,
  `score_u` int(20) NOT NULL,
  `score_u2` int(20) NOT NULL,
  `agree_u` int(10) NOT NULL,
  `agree_u2` int(10) NOT NULL,
  `finished` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `username` varchar(100) NOT NULL,
  `lid` int(11) NOT NULL,
  `time` int(10) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `wins` int(10) NOT NULL,
  `draws` int(10) NOT NULL,
  `loses` int(10) NOT NULL,
  `challenges` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
]]></installcode>
                        <uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
                </code>

powerbook 10-17-2008 08:10 PM
Sorry only realized that after I posted..

Quote:
Originally Posted by bananalive (Post 1647267)
Everything in installcode execs on product install and everything in uninstall execs on product uninstall
Code:
<code version="2.4.2.1">
                        <installcode><![CDATA[
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `noplayers` int(3) NOT NULL,
  `status` int(3) NOT NULL,
  `cr_userid` int(10) NOT NULL,
  `cr_username` varchar(100) NOT NULL,
  `cr_time` int(10) NOT NULL,
  `cr_ip` varchar(100) NOT NULL,
  `ed_userid` int(10) NOT NULL,
  `ed_username` varchar(100) NOT NULL,
  `ed_time` int(10) NOT NULL,
  `ed_ip` varchar(50) NOT NULL,
  `threadid` int(10) NOT NULL,
  `views` int(10) NOT NULL default '0',
  `winpoints` int(10) NOT NULL default '2',
  `drawpoints` int(10) NOT NULL default '1',
  `losepoints` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
  `id` int(11) NOT NULL auto_increment,
  `u` int(10) NOT NULL,
  `u2` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `accepted` int(10) NOT NULL,
  `lid` int(11) NOT NULL,
  `score_u` int(20) NOT NULL,
  `score_u2` int(20) NOT NULL,
  `agree_u` int(10) NOT NULL,
  `agree_u2` int(10) NOT NULL,
  `finished` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `username` varchar(100) NOT NULL,
  `lid` int(11) NOT NULL,
  `time` int(10) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `wins` int(10) NOT NULL,
  `draws` int(10) NOT NULL,
  `loses` int(10) NOT NULL,
  `challenges` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
]]></installcode>
                        <uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
                </code>

conker1 10-17-2008 08:10 PM
Quote:
Originally Posted by bananalive (Post 1647245)
Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.
Code:
$vbulletin->db->query_write("
  INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here')");
i did, new error message

Code:
Database error in vBulletin 3.7.3:

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

MySQL Error  : Duplicate column name 'tmnt_joins'
Error Number  : 1060
and thanks for reply

RK1gaming 10-17-2008 08:58 PM
never mind brain cramp

fernas 10-18-2008 05:01 AM
My suggestions:

- Teams for ladders.
- vbAdvanced modules for newest teams and recent matches.

Tnis hack is great!!

Antek 10-18-2008 09:33 AM
I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:
Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error  : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM
Script        : http://xxx/tournament.php?do=rules
Referrer      : http://xxx/tournament.php?do=view&id=8
IP Address    : xxx
Username      : xxx
Classname    : vB_Database
MySQL Version : 5.0.37-standard

bananalive 10-18-2008 10:03 AM
Quote:
Originally Posted by Antek (Post 1647572)
I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:
Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error  : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM
Script        : http://xxx/tournament.php?do=rules
Referrer      : http://xxx/tournament.php?do=view&id=8
IP Address    : xxx
Username      : xxx
Classname    : vB_Database
MySQL Version : 5.0.37-standard
have you tried the rules fix here

bananalive 10-18-2008 10:08 AM
1 Attachment(s)
Quote:
Originally Posted by conker1 (Post 1647273)
i did, new error message

Code:
Database error in vBulletin 3.7.3:

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

MySQL Error  : Duplicate column name 'tmnt_joins'
Error Number  : 1060
and thanks for reply
Re-import Attachment 88261 (this is modified version just for you) and then try installing product-tournament2008.xml

Antek 10-18-2008 04:15 PM
bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT userid, id, time, title FROM vb_tmnt_announcements ORDER BY id DESC LIMIT 0, 2;

MySQL Error  : Table 'xxx.vb_tmnt_announcements' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 07:18:31 PM
Error Date    : Saturday, October 18th 2008 @ 07:18:32 PM
Script        : http://xxx/tournament.php
Referrer      : xxx/
IP Address    : xxx
Username      : xxx
Classname    : vB_Database
MySQL Version : 5.0.37-standard

bananalive 10-18-2008 04:43 PM
Quote:
Originally Posted by Antek (Post 1647751)
bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php
You are missing table which means you need to reinstall product.

Antek 10-18-2008 06:23 PM
Ops :D It's working now :)


All times are GMT. The time now is 09:33 AM.
Page 21 of 54 « First 111920 21 222331 Last »
Show 40 post(s) from this thread on one page

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.02971 seconds
  • Memory Usage 1,865KB
  • 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
  • (13)bbcode_code_printable
  • (1)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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