I have problem to update 1.5.0a to Daniela JL 1.5.1 and I resolve it partially with some manual database update (version Daniela):
First Backup backup backup!!!
There are the steps:
A. fresh install
B. import old database (1.5.0a)
C. Do this manual updates:
1. Publish all persons, team player and staff
[syntax="mysql"]update jos_joomleague_person set jos_joomleague_person.published=1;
update jos_joomleague_team_player set jos_joomleague_team_player.published=1;
update jos_joomleague_team_staff set jos_joomleague_team_staff.published=1;[/syntax]
2. Update position in team_player
Code: Select all
UPDATE `jos_joomleague_team_player`, jos_joomleague_project_position, jos_joomleague_person, jos_joomleague_project_team SET `jos_joomleague_team_player`.`project_position_id` = `jos_joomleague_project_position`.`id` WHERE jos_joomleague_team_player.person_id = jos_joomleague_person.id AND `jos_joomleague_team_player`.`project_position_id` = `jos_joomleague_project_position`.`position_id` AND jos_joomleague_project_position.project_id = jos_joomleague_project_team.project_id AND jos_joomleague_project_team.id=jos_joomleague_team_player.projectteam_id;
Parsed in 0.017 seconds, using GeSHi 1.0.8.4
3. Update position in team staff
Code: Select all
UPDATE `jos_joomleague_team_staff`, jos_joomleague_project_position, jos_joomleague_person, jos_joomleague_project_team SET `jos_joomleague_team_staff`.`project_position_id` = `jos_joomleague_project_position`.`id` WHERE jos_joomleague_team_staff.person_id = jos_joomleague_person.id AND `jos_joomleague_team_staff`.`project_position_id` = `jos_joomleague_project_position`.`position_id` AND jos_joomleague_project_position.project_id = jos_joomleague_project_team.project_id AND jos_joomleague_project_team.id=jos_joomleague_team_staff.projectteam_id;
4. Update position for referee (there are some problems)
Code: Select all
UPDATE `jos_joomleague_project_referee`, jos_joomleague_project_position, jos_joomleague_person SET `jos_joomleague_project_referee`.`project_position_id` = `jos_joomleague_project_position`.`id` WHERE jos_joomleague_project_referee.person_id = jos_joomleague_person.id AND `jos_joomleague_project_referee`.`project_position_id` = `jos_joomleague_project_position`.`position_id` AND jos_joomleague_project_position.project_id = `jos_joomleague_project_referee`.`project_id`;
Is important to check correct position before doing the other steps.
5. Update player in matches
Code: Select all
UPDATE `jos_joomleague_team_player`, jos_joomleague_match_player SET jos_joomleague_match_player.project_position_id = `jos_joomleague_team_player`.`project_position_id` WHERE `jos_joomleague_team_player`.`id` = `jos_joomleague_match_player`.`teamplayer_id`;
6. Update staff in matches
Code: Select all
UPDATE `jos_joomleague_team_staff`, jos_joomleague_match_staff SET jos_joomleague_match_staff.project_position_id = `jos_joomleague_team_staff`.`project_position_id` WHERE `jos_joomleague_team_staff`.`id` = `jos_joomleague_match_staff`.`staff_id`;
7. Update referee in matches
Code: Select all
UPDATE `jos_joomleague_project_referee`, jos_joomleague_match_referee SET jos_joomleague_match_referee.project_position_id = `jos_joomleague_project_referee`.`project_position_id` WHERE `jos_joomleague_project_referee`.`id` = `jos_joomleague_match_referee`.`referee_id`;