Update JL from 1.5.0a

All Installation / Update / Upgrade Issues here.
ingalb
.
Posts: 56
Joined: Tue May 26, 2009 11:09 pm
Location: Italy

Update JL from 1.5.0a

Postby ingalb » Sat May 28, 2011 12:16 pm

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

Return to “Installation / Update”

Who is online

Users browsing this forum: No registered users and 2 guests

cron