Assign players problem

Status: finished.
Here you can find pre-releases of JoomLeague, Errors and problems with these versions should only be discussed in this board.
NOTICE: BETA and RC versions should not be used on a live site! No support on upgrading to the final version!

Moderator: And_One

fikoslav
Newbie
Posts: 9
Joined: Thu Jul 15, 2010 11:22 pm

Assign players problem

Postby fikoslav » Tue Dec 21, 2010 7:50 pm

Hello,

I', trying the newest version of Joomleague. Everything is fine, but I have problem with player assignment. I create a player and assign him to the team. Everything is fine. But when I want to see the roster of the team, there's some error message and there are no players. And when I choose teams in project, it shows that the team has one member, but when I click it, the same error as the roster. When I click assign player in team/project, tehre are no player to assign. Please help.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Tue Dec 21, 2010 8:34 pm

hmm, and whats the error message?

fikoslav
Newbie
Posts: 9
Joined: Thu Jul 15, 2010 11:22 pm

Re: Assign players problem

Postby fikoslav » Tue Dec 21, 2010 9:16 pm

Roster page:
Warning: Invalid argument supplied for foreach() in web/components/com_joomleague/models/roster.php on line 137
Warning: Invalid argument supplied for foreach() in web/components/com_joomleague/models/roster.php on line 137

Roster page in backend in project:
Unknown column 'tp.project_position_id' in 'field list' SQL=SELECT ppl.firstname, ppl.lastname, ppl.nickname, ppl.height, ppl.weight, ppl.id, tp.id as tpid, ppl.id AS person_id, tp.*, tp.project_position_id, u.name AS editor FROM jos_joomleague_person AS ppl INNER JOIN jos_joomleague_team_player AS tp ON tp.person_id=ppl.id LEFT JOIN jos_users AS u ON u.id=tp.checked_out WHERE tp.projectteam_id= 65 AND ppl.published = '1' ORDER BY ppl.ordering ,ppl.lastname LIMIT 0, 50
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in web/libraries/joomla/database/database/mysqli.php on line 360
Last edited by fikoslav on Tue Dec 21, 2010 9:20 pm, edited 1 time in total.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Tue Dec 21, 2010 9:18 pm

did you assign a position to the project and the player?

fikoslav
Newbie
Posts: 9
Joined: Thu Jul 15, 2010 11:22 pm

Re: Assign players problem

Postby fikoslav » Tue Dec 21, 2010 9:20 pm

Yes, positions are OK.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Tue Dec 21, 2010 9:23 pm

ah
Roster page in backend in project:
Unknown column 'tp.project_position_id' in 'field list' SQL=SELECT ppl.firstname, ppl.lastname, ppl.nickname, ppl.height, ppl.weight, ppl.id, tp.id as tpid, ppl.id AS person_id, tp.*, tp.project_position_id, u.name AS editor FROM jos_joomleague_person AS ppl INNER JOIN jos_joomleague_team_player AS tp ON tp.person_id=ppl.id LEFT JOIN jos_users AS u ON u.id=tp.checked_out WHERE tp.projectteam_id= 65 AND ppl.published = '1' ORDER BY ppl.ordering ,ppl.lastname LIMIT 0, 50
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in web/libraries/joomla/database/database/mysqli.php on line 360


you need to do an update:
jl_update_position_id_to_project_position_id.php

After this you have to remove and recreate all postions/events and stas

Or

do a clean install and start all overagain, make sure you download the latest version

fikoslav
Newbie
Posts: 9
Joined: Thu Jul 15, 2010 11:22 pm

Re: Assign players problem

Postby fikoslav » Tue Dec 21, 2010 9:30 pm

thanks

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 9:44 am

when I want to assign players to a team I get the following error:

error1.png

And then when I give the button "Assign Player" I get the following error:

error2.png

JL Version: JoomLeague - v1.5.0.6a585f3
You do not have the required permissions to view the files attached to this post.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Thu Dec 23, 2010 10:04 am

I cant read the text in the image

do a clean install and start all overagain, make sure you download the latest version

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 10:19 am

I have install the version: JoomLeague - v1.5.0.6a585f3

The text of first image:

Unknown column 'tp.project_position_id' in 'field list' SQL=SELECT ppl.firstname, ppl.lastname, ppl.nickname, ppl.height, ppl.weight, ppl.id, tp.id as tpid, ppl.id AS person_id, tp.*, tp.project_position_id, u.name AS editor FROM jos_joomleague_person AS ppl INNER JOIN jos_joomleague_team_player AS tp ON tp.person_id=ppl.id LEFT JOIN jos_users AS u ON u.id=tp.checked_out WHERE tp.projectteam_id= 3 AND ppl.published = '1' ORDER BY ppl.ordering ,ppl.lastname LIMIT 0, 20
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/xxxxxxx/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxx/public_html/xxxxxx/libraries/joomla/database/database/mysql.php on line 344

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Thu Dec 23, 2010 10:28 am

@ And_one,

are these project_position_id in the sql files? Can you please double check it ?

@Atletic Rodenc
Run the project_position_id update from maintenance

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 10:34 am

timoline wrote:@ And_one,

are these project_position_id in the sql files? Can you please double check it ?

@Atletic Rodenc
Run the project_position_id update from maintenance


I run the project_position_id and the first error its clean, but now when I push the botton "Assing Player" give me that error:

Fatal error: Call to undefined method JoomleagueModelPersons::getProjectName() in /home/xxxxx/public_html/xxxxxxx/administrator/components/com_joomleague/views/persons/view.html.php on line 116

Thanks.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Thu Dec 23, 2010 10:40 am

Sorry ....I give up

Is this with a clean install? or an old installation?

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 10:42 am

timoline wrote:Sorry ....I give up

Is this with a clean install? or an old installation?


it's a new installation, I download now the component from de web and install it.

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Assign players problem

Postby timoline » Thu Dec 23, 2010 10:43 am

Atletic Rodenc wrote:
timoline wrote:Sorry ....I give up

Is this with a clean install? or an old installation?


it's a new installation, I download now the component from de web and install it.


But did you create a new (empty)db

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 10:48 am

timoline wrote:
Atletic Rodenc wrote:
timoline wrote:Sorry ....I give up

Is this with a clean install? or an old installation?


it's a new installation, I download now the component from de web and install it.


But did you create a new (empty)db



Yes I deleted old bd and make new and install JL in a new BD.

Now I try another time, delete a BD and uninstall JL, and install another time.

User avatar
Atletic Rodenc
.
Posts: 313
Joined: Mon Feb 15, 2010 10:28 am
Joomleague version: 2.0.x
Location: Roda de Ter
Contact:

Re: Assign players problem

Postby Atletic Rodenc » Thu Dec 23, 2010 11:17 am

Atletic Rodenc wrote:
timoline wrote:
Atletic Rodenc wrote:
timoline wrote:Sorry ....I give up

Is this with a clean install? or an old installation?


it's a new installation, I download now the component from de web and install it.


But did you create a new (empty)db



Yes I deleted old bd and make new and install JL in a new BD.

Now I try another time, delete a BD and uninstall JL, and install another time.


It's all ok !!! I install another time and all it's ok !

Thanks for all !


Return to “1.5.0-a (Alpha)”

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron