Update JL from 1.5.0a

[ingalb]

Hi to all,

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`;