[ABD] phpBB Rivals (Clans, Ladders & Tournaments)

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
User avatar
James78
Registered User
Posts: 811
Joined: Sat Jul 30, 2005 4:54 pm
Location: Washington, USA
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by James78 » Sun Dec 21, 2008 6:48 pm

Pokerob wrote:Right okay, here is a proper question!

So everything has went well. I upload it perfectly, clear cache and then I get this when I click yes to the upgrade part.

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_rivals_challenges' already exists [1050]

SQL

CREATE TABLE phpbb_rivals_challenges ( challenge_id mediumint(8) UNSIGNED NOT NULL auto_increment, challenge_ladder mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, challenger mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, chalengee mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, chalenge_posttime int(11) DEFAULT '0' NOT NULL, challenge_details blob NOT NULL, PRIMARY KEY (challenge_id) )

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install_rivals/functions_install.php
LINE: 274
CALL: dbal_mysql->sql_query()

FILE: install_rivals/install.php
LINE: 43
CALL: load_schema()
Something like this came up for M0PIES earlier. Could someone reply with a solution to this please?

Thanks! :mrgreen:
Delete phpbb_rivals_challenges from MySQL.
If you encounter what is/or you think is a bug, please report it to the phpBB Bug Tracker

Pokerob
Registered User
Posts: 91
Joined: Mon Aug 06, 2007 10:43 am

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by Pokerob » Sun Dec 21, 2008 7:45 pm

So then after this I realised It would say this for all the tables. This was not the original error and during the end of the error I realised all it did was give an error, not work, but make the tables anyways.

Heres the proper error.

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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 'DEFAULT '0' NOT NULL, match_status smallint(4) UNSIGNED DEFAULT '0' NOT NULL, ' at line 5 [1064]

SQL

CREATE TABLE phpbb_rivals_matches ( match_id mediumint(8) UNSIGNED NOT NULL auto_increment, match_ladder mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, match_challenger mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, match_challengee DEFAULT '0' NOT NULL, match_status smallint(4) UNSIGNED DEFAULT '0' NOT NULL, match_finishtime int(11) DEFAULT '0' NOT NULL, match_posttime int(11) DEFAULT '0' NOT NULL, match_details blob NOT NULL, match_winner mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, match_looser mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, match_tie tinyint(2) DEFAULT '0' NOT NULL, match_winnerscore mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, match_looserscore mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (match_id) )

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install_rivals/functions_install.php
LINE: 274
CALL: dbal_mysql->sql_query()

FILE: install_rivals/install.php
LINE: 43
CALL: load_schema()
Help? :)

User avatar
M0PIES
Registered User
Posts: 103
Joined: Sun Sep 14, 2008 6:37 pm

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by M0PIES » Sun Dec 21, 2008 9:36 pm

I'm not too good with SQL so I wouldn't know, but apparently the MOD author has released a new version.
1.7.0
http://www.phpbbrivals.com/forums/viewt ... p?f=2&t=33

Pokerob
Registered User
Posts: 91
Joined: Mon Aug 06, 2007 10:43 am

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by Pokerob » Mon Dec 22, 2008 8:04 am

M0PIES wrote:I'm not too good with SQL so I wouldn't know, but apparently the MOD author has released a new version.
1.7.0
http://www.phpbbrivals.com/forums/viewt ... p?f=2&t=33
This is the version that I uploaded yesterday. It is a 1.7.0 error.

Help? :(

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by A.I. BOT » Mon Dec 22, 2008 3:53 pm

I see the problem, redownload the zip and replace the installer folder. Then try the install :)

Thanks.

mark05
Registered User
Posts: 80
Joined: Wed Feb 28, 2007 11:11 am
Location: Germany
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by mark05 » Mon Dec 22, 2008 3:57 pm

A.I. BOT wrote:I see the problem, redownload the zip and replace the installer folder. Then try the install :)

Thanks.
i did a hg update today and replace all files then i did an install_rivals/install.php and choose
upgrade.

but the error is still there.

holger

User avatar
James78
Registered User
Posts: 811
Joined: Sat Jul 30, 2005 4:54 pm
Location: Washington, USA
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by James78 » Mon Dec 22, 2008 4:44 pm

Can you check all the MySQL queries? The problem still exists.
If you encounter what is/or you think is a bug, please report it to the phpBB Bug Tracker

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by A.I. BOT » Mon Dec 22, 2008 5:12 pm

Okay, checked them all and fixed them all, had someone test it for me. Zip re-uploaded.

Thanks.

User avatar
James78
Registered User
Posts: 811
Joined: Sat Jul 30, 2005 4:54 pm
Location: Washington, USA
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by James78 » Mon Dec 22, 2008 6:57 pm

Thanks. :D
If you encounter what is/or you think is a bug, please report it to the phpBB Bug Tracker

User avatar
vlastanovak
Registered User
Posts: 83
Joined: Thu Dec 04, 2008 11:48 pm
Location: Wollongong, Australia

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by vlastanovak » Mon Dec 22, 2008 7:32 pm

I tested it for the creator on my website and it now installs fine. However the links up the top such as 'addclan' and 'clancp' when clicked simply refresh the current page and they do not actually take you anywhere.

Still a few little bugs to fix up I think, but I really would like to see this mod in full flight.

User avatar
vlastanovak
Registered User
Posts: 83
Joined: Thu Dec 04, 2008 11:48 pm
Location: Wollongong, Australia

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by vlastanovak » Tue Dec 23, 2008 4:35 pm

I get the following error when trying to run the install file;

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Duplicate column name 'clan_session' [1060]

SQL

ALTER TABLE `users` ADD COLUMN `clan_session` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/db_tools.php
LINE: 618
CALL: dbal_mysql->sql_query()

FILE: includes/db/db_tools.php
LINE: 910
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install_rivals/install.php
LINE: 45
CALL: phpbb_db_tools->sql_column_add()
Thoughts?

User avatar
M0PIES
Registered User
Posts: 103
Joined: Sun Sep 14, 2008 6:37 pm

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by M0PIES » Tue Dec 23, 2008 6:38 pm

vlastanovak wrote:I get the following error when trying to run the install file;

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Duplicate column name 'clan_session' [1060]

SQL

ALTER TABLE `users` ADD COLUMN `clan_session` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/db_tools.php
LINE: 618
CALL: dbal_mysql->sql_query()

FILE: includes/db/db_tools.php
LINE: 910
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install_rivals/install.php
LINE: 45
CALL: phpbb_db_tools->sql_column_add()
Thoughts?
I had that error before. I went into my phpMyAdmin, found phpBB_users, found clan_session and deleted it. The installation worked fine after that.
(also clan_session should be at the very bottom of phpBB_users)

Pokerob
Registered User
Posts: 91
Joined: Mon Aug 06, 2007 10:43 am

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by Pokerob » Wed Dec 24, 2008 10:17 am

Right okay, ive installed it all correctly. Now I have a non coding question.

How would I go about creating tournaments and ladders on this?

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by A.I. BOT » Wed Dec 24, 2008 11:07 am

Go into your phpBB ACP, if you installed it correctly you should see a tab called phpBB Rivals. From there you can do all this :)

Just a note to anyone, I'll be on vaction from 26th to the 2nd, so any problems I will have to deal with when I get back, wont have my computer with me.

Thanks.

User avatar
M0PIES
Registered User
Posts: 103
Joined: Sun Sep 14, 2008 6:37 pm

Re: [BETA] phpBB Rivals (Clans, Ladders & Tournaments)

Post by M0PIES » Wed Dec 24, 2008 2:52 pm

Ok so the bug I have is that it goes to www.yoursite.com/phpBB3/ instead of www.forum.yoursite.com/ (which is mine) when people try to accept invites to a Clan. Well I looked at the link that accepts you into a clan and copy + pasted the end of it to www.forum.yoursite.com/ and it worked. Now I just need to learn how to change it so it goes to forum.yoursite.com instead of www.yoursite.com/phpBB3/.

Does anyone know how to do that?

Locked

Return to “[3.0.x] Abandoned MODs”