Diverse Fehler bei Update

Moderators: And_One, Heart

vikingX
.
Posts: 28
Joined: Wed Jun 20, 2012 6:56 pm

Diverse Fehler bei Update

Postby vikingX » Thu Sep 10, 2015 8:21 pm

Servus! Hoffe jemand kann mir bei den Problemen mit dem Update weiterhelfen..
Erstmals erschienen folgende Fehlermeldungen während ich das Update-Script laufen liess (siehe attachment). Weiss nicht ob dies schon der Grund ist, dass das Update nicht richtig funktioniert hat.

Die meisten Daten sind vorhanden, es fehlen aber zum Beispiel die Saisons:
( Fehlermeldung: Unknown column 's.published' in 'where clause' SQL=SELECT s.*, u.name AS editor FROM rasrx_joomleague_season AS s LEFT JOIN rasrx_users AS u ON u.id=s.checked_out WHERE s.published = 1 ORDER BY s.ordering LIMIT 0, 20)

und alle Spiele:
(Fehlermeldung: Unknown column 'p.timezone' in 'field list' SQL=SELECT mc.*, p.timezone, CASE mc.time_present when "00:00:00" then NULL else DATE_FORMAT(mc.time_present, "%H:%i") END AS time_present, IFNULL(divhome.shortname, divhome.name) divhome, divhome.id divhomeid, divaway.id divawayid, t1.name AS team1, t2.name AS team2, u.name AS editor, (Select count(mp.id) FROM rasrx_joomleague_match_player AS mp WHERE mp.match_id = mc.id AND (came_in=0 OR came_in=1) AND mp.teamplayer_id in ( SELECT id FROM rasrx_joomleague_team_player AS tp WHERE tp.projectteam_id = mc.projectteam1_id ) ) AS homeplayers_count, (Select count(ms.id) FROM rasrx_joomleague_match_staff AS ms WHERE ms.match_id = mc.id AND ms.team_staff_id in ( SELECT id FROM rasrx_joomleague_team_staff AS ts WHERE ts.projectteam_id = mc.projectteam1_id ) ) AS homestaff_count, (Select count(mp.id) FROM rasrx_joomleague_match_player AS mp WHERE mp.match_id = mc.id AND (came_in=0 OR came_in=1) AND mp.teamplayer_id in ( SELECT id FROM rasrx_joomleague_team_player AS tp WHERE tp.projectteam_id = mc.projectteam2_id ) ) AS awayplayers_count, (Select count(ms.id) FROM rasrx_joomleague_match_staff AS ms WHERE ms.match_id = mc.id AND ms.team_staff_id in ( SELECT id FROM rasrx_joomleague_team_staff AS ts WHERE ts.projectteam_id = mc.projectteam2_id ) ) AS awaystaff_count, (Select count(mr.id) FROM rasrx_joomleague_match_referee AS mr WHERE mr.match_id = mc.id ) AS referees_count FROM rasrx_joomleague_match AS mc LEFT JOIN rasrx_users u ON u.id = mc.checked_out LEFT JOIN rasrx_joomleague_project_team AS pthome ON pthome.id = mc.projectteam1_id LEFT JOIN rasrx_joomleague_project_team AS ptaway ON ptaway.id = mc.projectteam2_id LEFT JOIN rasrx_joomleague_team AS t1 ON t1.id = pthome.team_id LEFT JOIN rasrx_joomleague_team AS t2 ON t2.id = ptaway.team_id LEFT JOIN rasrx_joomleague_round AS r ON r.id = mc.round_id LEFT JOIN rasrx_joomleague_project AS p ON p.id=r.project_id LEFT JOIN rasrx_joomleague_division AS divaway ON divaway.id = ptaway.division_id LEFT JOIN rasrx_joomleague_division AS divhome ON divhome.id = pthome.division_id WHERE mc.round_id = 213 ORDER BY mc.match_date , divhome.id, divaway.id LIMIT 0, 20 )

Kann jemand beim reparieren helfen? :help:

Danke!
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: 3612
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: Diverse Fehler bei Update

Postby And_One » Mon Sep 14, 2015 3:21 pm

Unknown column 'p.timezone' , die Spalte in der Tabelle. Versuch mal das Update Script laufen lassen

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

Re: Diverse Fehler bei Update

Postby And_One » Mon Sep 14, 2015 3:21 pm

Unknown column 'p.timezone' , die Spalte in der Tabelle. Versuch mal das Update Script laufen lassen


Return to “de-DE”

Who is online

Users browsing this forum: No registered users and 2 guests