1 Topic by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Topic: Updating warehouse from SVN trunk

Hi all,
A heads up for anyone who is updating there own warehouse from the SVN trunk. As I have just fixed an incorrect script date in a couple of the upgrade scripts, you should run the following query to correct this otherwise any subsequent scripts will not run:

update system set last_run_script='201303041010_list_user_trusts.sql' where last_run_script='201304041010_list_user_trusts.sql';

Cheers
John

John van Breda
Biodiverse IT

johnvanbreda's Website

2 Reply by Alan Hale

  • Alan Hale
  • Veteran
  • Offline
  • From: Aberystwyth, Wales
  • Registered: 11-05-2006
  • Posts: 278

Re: Updating warehouse from SVN trunk

Thanks John - done.
Alan

Alan Hale
Aberystwyth

Alan Hale's Website

3 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: Updating warehouse from SVN trunk

Hi

As John says above, r5415 changes a couple of script dates for users updating a warehouse from the development trunk of the repository.

A couple of days later, r5425 changes script dates for users updating from branch 0.8.2 of the repository.

The corresponding query that branch 0.8.2 users need to execute so that scripts continue to run is

update system set last_run_script='201303031008_occurrence_training.sql' where last_run_script='201304031008_occurrence_training.sql';

Jim Bacon