Big problem in the admin JoomLeague

Moderator: And_One

User avatar
Ghost
.
Posts: 273
Joined: Sun May 20, 2007 2:13 pm
Location: France
Contact:

Big problem in the admin JoomLeague

Postby Ghost » Tue Sep 24, 2013 4:19 pm

Big problem in the admin JoomLeague indeed I create a new project, and I wanted to set the starting point (as former championship) and I save to put in the correct order and that I'm doing this all over my project.

thank you for helping me quickly

Unknown column 'pt.ordering' in 'order clause' SQL = SELECT tl.id projectteamid AS, tel. *, U.name AS editor, u.email AS email, t.name, t.club_id, c.email AS club_email (SELECT count (id) FROM WHERE projectteam_id un7_joomleague_team_player tp = projectteamid and tp.published = 1) playercount, (SELECT count (id) FROM WHERE projectteam_id un7_joomleague_team_staff ts = projectteamid and ts.published = 1) staffcount, tl.info FROM un7_joomleague_project_team AS tl LEFT JOIN un7_joomleague_team t on tl.team_id = t.id LEFT JOIN un7_users tl.admin = u on u.id LEFT JOIN on t.club_id un7_joomleague_club c = c.id LEFT JOIN un7_joomleague_division of it d.id = tl.division_id LEFT JOIN on plg.id un7_joomleague_playground plg = tl.standard_playground WHERE tl.project_id = 4 ORDER BY pt.ordering, t.name LIMIT 0, 20


==========================

Gros problème dans l'admin joomleague en effet j'ai creer un nouveau projet, et je voulais mettre les point de depart (car ancien championnat) et j'ai enregistrer afin de mettre dans le bon ordre et la cela me fais cela sur tout mes projet.

merci de m'aider rapidement

Unknown column 'pt.ordering' in 'order clause' SQL=SELECT tl.id AS projectteamid, tl.*, u.name AS editor, u.email AS email, t.name, t.club_id, c.email AS club_email, (SELECT count(id) FROM un7_joomleague_team_player tp WHERE projectteam_id = projectteamid and tp.published=1) playercount, (SELECT count(id) FROM un7_joomleague_team_staff ts WHERE projectteam_id = projectteamid and ts.published=1) staffcount, tl.info FROM un7_joomleague_project_team AS tl LEFT JOIN un7_joomleague_team t on tl.team_id = t.id LEFT JOIN un7_users u on tl.admin = u.id LEFT JOIN un7_joomleague_club c on t.club_id = c.id LEFT JOIN un7_joomleague_division d on d.id = tl.division_id LEFT JOIN un7_joomleague_playground plg on plg.id = tl.standard_playground WHERE tl.project_id = 4 ORDER BY pt.ordering , t.name LIMIT 0, 20

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: Big problem in the admin JoomLeague

Postby And_One » Tue Sep 24, 2013 6:55 pm

use the table update script

User avatar
Ghost
.
Posts: 273
Joined: Sun May 20, 2007 2:13 pm
Location: France
Contact:

Re: Big problem in the admin JoomLeague

Postby Ghost » Wed Sep 25, 2013 7:42 am

where.

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: Big problem in the admin JoomLeague

Postby And_One » Wed Sep 25, 2013 8:17 am

:wiki:

User avatar
Ghost
.
Posts: 273
Joined: Sun May 20, 2007 2:13 pm
Location: France
Contact:

Re: Big problem in the admin JoomLeague

Postby Ghost » Wed Sep 25, 2013 8:20 am

thnaks but i looking and i don't find

User avatar
Ghost
.
Posts: 273
Joined: Sun May 20, 2007 2:13 pm
Location: France
Contact:

Re: Big problem in the admin JoomLeague

Postby Ghost » Wed Sep 25, 2013 8:28 am

it's OK

thanks


Return to “matches”

Who is online

Users browsing this forum: No registered users and 1 guest

cron