search

FWM-Team / FWM-Backlog-Issues

This is a backlog of issues to deal with
0 stars 0 forks source link

Database updates #10

Open FWAJL opened 9 years ago

FWAJL commented 9 years ago

Hello @FWM-Team/owners,

I will describe here how to create database update scripts formally, what guidelines to follow and what to do when you have one ready.

Stay tune!

Thank you.

FWAJL commented 9 years ago

Hello,

Please run the scripts following in order:

Thank you.

bsaiken commented 9 years ago

Jeremie,

Your update scripts never work for me. Never have. I always get an error like the one attached.

The way I have always got around this in the past is that I delete my local database and download the online database.

I have noticed, however, that all the scripts that have been given to me by Damir and Souvik work. So I would like you to look into why.

Brian

On 2015-03-25 18:34, FWAJL wrote:

Hello,

Please run the scripts following in order:

https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-19.sql [1] https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-23.sql [2] * https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-25.sql [3]

Reply to this email directly or view it on GitHub [4].

*

Links:

[1] https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-19.sql [2] https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-23.sql [3] https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-03-25.sql [4] https://github.com/FWM-Team/FWM-Backlog-Issues/issues/10#issuecomment-86162460

FWAJL commented 9 years ago

@FWM-Team/owners

Please run locally https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_devsupport/Database/Scripts/Updates/2015-03-26.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

Please run locally https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-03-31.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

Just in case you missed something (_Please run in the order below_): https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-04-01.sql https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-04-02.sql https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-04-07.sql https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-04-06.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

FYI, I'm adding the live database backups to the repository so you can all have the latest data on your local machine. It can be found in this folder.

FWAJL commented 9 years ago

@FWM-Team/owners

Please find the latest Live database data in this file if you need it: https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Online-backups/baiken_fwm_1_20150415.sql

FWAJL commented 9 years ago

@FWM-Team/owners

Please run the latest script on your local database:

https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_damir/Database/Scripts/Updates/2015-04-16.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

Please run the latest script on your local database: https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Updates/2015-04-14.sql https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_thread/Database/Scripts/Updates/2015-04-17.sql https://github.com/FWAJL/FieldWorkAssistantMVC/blob/feature_thread/Database/Scripts/Updates/2015-04-20.sql

Please let me know if you have any issue. Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

You can find the latest backup here: https://github.com/FWAJL/FieldWorkAssistantMVC/blob/dev/Database/Scripts/Online-backups/baiken_fwm_1_20150421.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

You can find the latest backup here with the live data: https://github.com/FWAJL/FieldWorkAssistantMVC/blob/2e453ed69b7537dba82276e99542af26fc36e4ed/Database/Scripts/Online-backups/baiken_fwm_1_20150506.sql

Thank you.

FWAJL commented 9 years ago

@FWM-Team/owners

Please run the update script (as part of https://github.com/FWAJL/FieldWorkManager/issues/1102): https://github.com/FWAJL/FieldWorkManager/blob/bbe298d38767c0f5af221f391ec00bfdf1f1043c/Database/Scripts/Updates/2015-07-24.sql

Thank you.

bsaiken commented 9 years ago

I ran it on the server, too.

Brian

On 2015-07-24 13:51, FWAJL wrote:

@FWM-Team/owners [1]

Please run the update script (as part of FWAJL/FieldWorkManager#1102 [2]): https://github.com/FWAJL/FieldWorkManager/blob/bbe298d38767c0f5af221f391ec00bfdf1f1043c/Database/Scripts/Updates/2015-07-24.sql [3]

Thank you.

Reply to this email directly or view it on GitHub [4].

*

Links:

[1] https://github.com/orgs/FWM-Team/teams/owners [2] https://github.com/FWAJL/FieldWorkManager/issues/1102 [3] https://github.com/FWAJL/FieldWorkManager/blob/bbe298d38767c0f5af221f391ec00bfdf1f1043c/Database/Scripts/Updates/2015-07-24.sql [4] https://github.com/FWM-Team/FWM-Backlog-Issues/issues/10#issuecomment-124528256

FWAJL commented 9 years ago

​@bsaiken

Ok but I have not released the code for it. It will be in v1.7.3​. as I completed the task after releasing v1.7.2.

Jérémie Litzler

On 24 July 2015 at 16:14, bsaiken notifications@github.com wrote:

I ran it on the server, too.

Brian

On 2015-07-24 13:51, FWAJL wrote:

@FWM-Team/owners [1]

Please run the update script (as part of FWAJL/FieldWorkManager#1102 [2]):

https://github.com/FWAJL/FieldWorkManager/blob/bbe298d38767c0f5af221f391ec00bfdf1f1043c/Database/Scripts/Updates/2015-07-24.sql [3]

Thank you.

Reply to this email directly or view it on GitHub [4].

*

Links:

[1] https://github.com/orgs/FWM-Team/teams/owners [2] https://github.com/FWAJL/FieldWorkManager/issues/1102 [3]

https://github.com/FWAJL/FieldWorkManager/blob/bbe298d38767c0f5af221f391ec00bfdf1f1043c/Database/Scripts/Updates/2015-07-24.sql [4]

https://github.com/FWM-Team/FWM-Backlog-Issues/issues/10#issuecomment-124528256

— Reply to this email directly or view it on GitHub https://github.com/FWM-Team/FWM-Backlog-Issues/issues/10#issuecomment-124536967 .

FWAJL commented 9 years ago

@FWM-Team/owners

For https://github.com/FWAJL/FieldWorkManager/issues/1116, the following needs to be run into your local database: https://github.com/FWAJL/FieldWorkManager/blob/44a150706863e0f17e73ce2baa2cc4ba0cbea7d0/Database/Scripts/Updates/2015-07-27.sql

Thank you.

FWAJL commented 9 years ago

@bsaiken

Last update has been run on the server.