Player view

Status: under development
Branch: https://gitlab.com/joomleague/joomleague/tree/3.0.0

Moderator: And_One

User avatar
benio08
.
Posts: 488
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

Player view

Postby benio08 » Mon Sep 05, 2016 6:14 am

After transfer player from team A to team B i heve this error
1241 - Operand should contain 1 column(s) SQL=SELECT m.*, ios.* FROM #__joomleague_match AS m INNER JOIN ( SELECT mp.match_id, t1.id AS team1, t2.id AS team2, r.roundcode, r.project_id, tp.projectteam_id, p.timezone, COALESCE(sum(mp.came_in=0 AND mp.teamplayer_id IN (('145686','155056'))),0) AS started, COALESCE(sum(mp.came_in=1 AND mp.teamplayer_id IN (('145686','155056'))),0) AS sub_in, COALESCE(sum((mp.teamplayer_id IN (('145686','155056')) AND mp.out = 1) OR mp.in_for IN (('145686','155056'))),0) AS sub_out FROM #__joomleague_match_player AS mp INNER JOIN #__joomleague_team_player AS tp ON tp.id=mp.teamplayer_id INNER JOIN #__joomleague_match AS m ON m.id=mp.match_id INNER JOIN #__joomleague_round r ON r.id=m.round_id INNER JOIN #__joomleague_project AS p ON p.id=r.project_id INNER JOIN #__joomleague_project_team AS pt1 ON pt1.id=m.projectteam1_id INNER JOIN #__joomleague_team AS t1 ON t1.id=pt1.team_id INNER JOIN #__joomleague_project_team AS pt2 ON pt2.id=m.projectteam2_id INNER JOIN #__joomleague_team AS t2 ON t2.id=pt2.team_id WHERE ((mp.teamplayer_id IN (('145686','155056'))) OR (mp.in_for IN (('145686','155056')))) AND m.published = 1 AND p.published = 1 GROUP BY mp.match_id, t1.id, t2.id, r.roundcode, r.project_id, tp.projectteam_id, p.timezone ) AS ios ON ios.match_id=m.id ORDER BY m.match_date
Jomla 2.5.8 last joomleague revision

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Mon Sep 05, 2016 9:15 pm

Can you attach your project export pls.

User avatar
benio08
.
Posts: 488
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

Re: Player view

Postby benio08 » Tue Sep 06, 2016 6:06 am

Project is attached as zip file player Jakub Czerwiński transfered between team Pogoń Szczecin and Legia Warszawa
You do not have the required permissions to view the files attached to this post.
Jomla 2.5.8 last joomleague revision

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Thu Sep 08, 2016 12:45 pm

your sportstype is wrong, change it from soccer to COM_JOOMLEAGUE_ST_SOCCER

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Thu Sep 08, 2016 1:27 pm

Hi, And_One, I've set up a test league on localhost (php 5.6.20 and Joomla 3.6.2), and originally I had a 1064 error and white page linking both from roster view and from a new menu item.
Immediately after changing sporttype from "calcio" to COM_JOOMLEAGUE_ST_SOCCER, it went as it was before, blank page.
Then I've created a results-rank page, and from there (and from then on) I've been able to navigate to each page without issues.
As it is now it works, even disabling the res-rank menu item, so it's just a strange behaviour for you to know.
Thanks indeed for your work.

User avatar
benio08
.
Posts: 488
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

Re: Player view

Postby benio08 » Thu Sep 08, 2016 1:37 pm

it was changed screen sporttype and but bug stil exist
You do not have the required permissions to view the files attached to this post.
Jomla 2.5.8 last joomleague revision

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Thu Sep 08, 2016 1:46 pm

Hi benio, did you manually input all these sporttypes?
I have installed from gitlab last zip, But there's no one already there...

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Thu Sep 08, 2016 1:47 pm

can you document the problem step by step with screenshots pls

User avatar
benio08
.
Posts: 488
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

Re: Player view

Postby benio08 » Thu Sep 08, 2016 2:01 pm

teddy wrote:Hi benio, did you manually input all these sporttypes?
I have installed from gitlab last zip, But there's no one already there...

I don't remember maybe was chanded manualy old sporttypes soccer to COM_JOOMLEAGUE_ST_SOCCER
Jomla 2.5.8 last joomleague revision

User avatar
benio08
.
Posts: 488
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

Re: Player view

Postby benio08 » Thu Sep 08, 2016 4:57 pm

I try import this zip file to new clean install jL and more teamplayer was skipped after import isn't asigned to correct teams
All Person data was import but don't assign it to team as teamplayer unfortunately this player isn't assigned to team
Jomla 2.5.8 last joomleague revision

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Thu Sep 08, 2016 5:38 pm

And_One, if you meant me, I'm installing from scratch on a clean db, and there's no pre defined sport type there.
I don't think it's a bug, but with usability in mind, maybe a short list of 10 sports would show users what to do in case they have to add one.

After creating sport type COM_JOOMLEAGUE_ST_SOCCER, I've created a season, league, event types, positions, clubs, teams and persons.
Then a project, assigning to it positions and teams, then creating rounds and only one match. On this match, after result, I've added 2 players, one per team, and then events.
All seeemed well, so I've created a menu page for a team's roster and a player page: clicking on player's link on menu and on roster page, leads to a 1064 (blank)page.
After adding the results-ranking page all goes well and players become visible.
I'm sending you the export attached in case it can be useful.
You do not have the required permissions to view the files attached to this post.

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Thu Sep 08, 2016 9:04 pm

a clean install should create the standard sport-types, thats a bug which needs a fix

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Sun Sep 11, 2016 12:12 am

And_One, I could add the bug to the bugtracker, where once I had an account, but now it doesn't seem so, please let me know if you need help there.

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Sun Sep 18, 2016 12:49 am

Hi, I've added manually COM_JOOMLEAGUE_ST_SOCCER after installing last JL version, on a 3.6.2 Joomla with italian installed and set as default language. Despite the correct JL italian language file being present, and correctly translated, I get a "Soccer" translation (and not "calcio"). Should I correct manually? Or is it just a bug and should be left as it is?

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Sun Sep 18, 2016 4:19 am

You have to translate it on transfex

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Sun Sep 18, 2016 10:10 am

And_One, that's what I thought, now I double checked and it seems the item I translated 4 days ago on 30-admin-com_joomleague-sport_types-ini is correctly set on "Calcio". But maybe I have to look somewhere else?

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Mon Sep 19, 2016 8:29 am

Translation files will be only included if the overall translation status is >80%.

User avatar
teddy
.
Posts: 304
Joined: Wed Feb 28, 2007 12:01 pm

Re: Player view

Postby teddy » Mon Sep 19, 2016 9:10 am

And they are actually, I've checked the file both on transifex (translated on Sep 14th, 6:37 pm) and on my installations, that's why I'm asking...

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3609
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Player view

Postby And_One » Mon Sep 19, 2016 9:24 am

Code: Select all

Database Tables Picture Path Migration - Success
Database Tables update suspensions of event types for soccer (e.g. red card) - Success
Creating new Image Folder structure - Success
Duration: 0s
All language translations are powered by Transifex

Available backend translations: ar_AA, de_DE, en_GB, es_ES, es_419, fr_FR, it_IT, ku_IQ, my_MM, nl_NL, sv_SE, tl_PH, zh_CN.GB2312 - Success

Available frontend translations: ar_SA, ar_AA, bg_BG, ca_ES, cs_CZ, da_DK, de_DE, el_GR, en_GB, es_AR, es_ES, es_419, et_EE, fa_IR, fi_FI, fr_FR, he_IL, hr_HR, hu_HU, id_ID, is_IS, it_IT, ja_JP, ku_IQ, lt_LT, lv_LV, my_MM, nb_NO, nl_NL, pl_PL, pt_BR, pt_PT, ro_RO, ru_RU, sk_SK, sl_SI, sq_AL, sr_RS, sv_SE, th_TH, tl_PH, tr_TR, uk_UA, zh_CN, zh_TW, zh_CN.GB2312 - Success
Duration: 1s
Inserting Ghost-Player data - Skipped
Inserting default Sport-Types - Success
Updating database version from '3.0.11.18eb7db-Blue ' to '3.0.14.d74d897-Blue' - Success


Updated the jl3 testsite and i see all languages are correct installed.


checked your issue and it seems to be correct translated and now delivered with the latest package:

it-IT.com_joomleague_sport_types.ini

Code: Select all


; Note : All ini files need to be saved as UTF-8
; Note: YES, NO, TRUE, FALSE are reserved words in INI format.
; Double quotes in the values have to be formatted as "_QQ_"

; @package       Joomleague
; @subpackage    administration
; @copyright   Copyright (C) 2006-2014 joomleague.at. All rights reserved.
; @license      GNU/GPL, see LICENSE.php
;
; Note : All ini files need to be saved as UTF-8 without BOM

;----------------------------------------------------------
;Standard sports types
;----------------------------------------------------------
COM_JOOMLEAGUE_ST_AMERICAN_FOOTBALL="Football Americano"
COM_JOOMLEAGUE_ST_HOCKEY="Hockey"
COM_JOOMLEAGUE_ST_ICEHOCKEY="Hockey su ghiaccio"
COM_JOOMLEAGUE_ST_SOCCER="Calcio"
COM_JOOMLEAGUE_ST_VOLLEYBALL="Pallavolo"
COM_JOOMLEAGUE_ST_ESPORT_CS="Counter-Strike"
COM_JOOMLEAGUE_ST_ESPORT_CSS="Counter-Strike Source"
COM_JOOMLEAGUE_ST_ESPORT_CSGO="Counter-Strike - Global Offensive"
COM_JOOMLEAGUE_ST_ESPORT_DODC="Day of Defeat Classic"
COM_JOOMLEAGUE_ST_ESPORT_DODS="Day of Defeat Source"
COM_JOOMLEAGUE_ST_GENERIC="Generico"
COM_JOOMLEAGUE_ST_KORFBALL="Korfball"
COM_JOOMLEAGUE_ST_HANDBALL="Pallamano"
COM_JOOMLEAGUE_ST_FUTSAL="Calcetto"
COM_JOOMLEAGUE_ST_BASKETBALL="Pallacanestro"
COM_JOOMLEAGUE_ST_BASEBALL="Baseball"
COM_JOOMLEAGUE_ST_RUGBY="Rugby"
COM_JOOMLEAGUE_ST_SPORTSHOOTING="Sport di tiro"


please update to Release 3.0.14.d74d897

fistersn
.
Posts: 39
Joined: Wed Aug 15, 2007 5:11 pm
Contact:

Re: Player view

Postby fistersn » Wed Oct 05, 2016 8:37 pm

I also seems to have the same problem on this page
http://sulkesligaen.no/index.php/sulkesligaen-2016.
Strangly enough it works fine for this page http://sulkesligaen.no/index.php/sulkesligaen-2015

any suggestion to what could be wrong?

davilafran
Newbie
Posts: 13
Joined: Wed Feb 20, 2013 4:38 pm

Re: Player view

Postby davilafran » Fri Nov 11, 2016 4:58 pm

Hi!

I transferred two players using the "player since" date on Extended, under Edit Team Player. I don't know the proper way to reflect a transfer during a season. As soon as I do it, I get the error of the first post. I don't know what it has to do with the sports type, as I don't understand why the conversation here turned out onto that issue. My sports type didn't seem to be wrong to me.

How do you reflect transfers of players? And if I'm doing it right... what does this error has to do with the sport type?

Thanks.


Return to “3.0.22.57ae969-Blue (Joomla: 3.x)”

Who is online

Users browsing this forum: No registered users and 4 guests

cron