Queries for upgrading from F 3.0.x to F 3.3.x

[dimoss]

Hi

Recently I decided to upgrade one of my apps from J! 2.5.28 & F 3.0.9 to J! 3.4.3 and F 3.3.2.
This app was a big one containing about 100+ lists, forms, groups etc so after the very helpful WiKi entry for upgrading I decided to create some sql scripts to run on db level via phpmyadmin to change the rest in "one shot".
So i decided to share with all of you my little scripts in case you need them:

1. Change all forms to bootstrap:
UPDATE yourdbprefix_fabrik_forms
SET form_template = 'bootstrap', view_only_template = 'bootstrap'

2. Change all lists admin template to bootstrap:
UPDATE yourdbprefix_fabrik_lists
SET params = REPLACE(params, '"admin_template":"admin"', '"admin_template":"bootstrap"')
WHERE params LIKE '%"admin_template":"admin"%';

UPDATE yourdbprefix_fabrik_lists
SET params = REPLACE(params, '"admin_template":""', '"admin_template":"bootstrap"')
WHERE params LIKE '%"admin_template":""%';

3. Add Back button to all forms:
UPDATE yourdbprefix_fabrik_forms
SET params = REPLACE(params, '"goback_button":"0","goback_button_label":""', '"goback_button":"1","goback_button_label":"Back"')
WHERE params LIKE '%"goback_button":"0","goback_button_label":""%';

UPDATE yourdbprefix_fabrik_forms
SET params = REPLACE(params, '"goback_button":"0","goback_button_label":"Go back"', '"goback_button":"1","goback_button_label":"Back"')
WHERE params LIKE '%"goback_button":"0","goback_button_label":"Go back"%';

4. Change all lists to bootstrap:
UPDATE yourdbprefix_fabrik_lists
SET template = 'bootstrap';

and finally if you want Ajaxify lists...

5. Change all lists Ajaxify to Yes:
UPDATE yourdbprefix_fabrik_lists
SET params = REPLACE(params, '"list_ajax":"0"', '"list_ajax":"1"')
WHERE params LIKE '%"list_ajax":"0"%';

Thanks!

 

[troester]

I've added a lin to the WIKI
http://fabrikar.com/forums/index.ph...k3-0-9-to-fabrik3-1-j-3-4/#example-db-queries