QUESTION: Guide to Update Version 4.1.1 to Version 4.2.0

[uojorgensen]

Could someone explain this a little clearer please.

2. Database Modification

In the 'database_changes' folder you may find the '2007-11-28_add_column-pages.pass_parameters_via_uri.sql' file that you will have to apply. After applying this file the 'pass_parameters_via_uri' field will be added to the 'pages' table. Functional in the 'User Pages' section will not work without this field (the following error will be displayed during adding/saving a new user page: Unknown column 'pass_parameters_via_uri' in 'field list').
In the 'database_changes' folder you may find the '2007-11-28_add_user_page.sql' file that you will have to apply. After applying this file the '/browse_by_make_model/' and '/browse_by_body_style/' pages will be created. You will not be able to view the new functional without these pages.


Thanks,
Ken

[Smart Girl]

Ken,

You need to do the following:
1. open the *.sql file in a text editor, for ex., NotePad
2. open your phpMyAdmin
3. select the DB of your product
4. go to SQL tab
5. insert the text of the sql file from the NotePad to the textarea of the SQL tab
6. click the "Go" button

Please note that first you need to apply the '2007-11-28_add_column-pages.pass_parameters_via_uri.sql' file, and only then '2007-11-28_add_user_page.sql'.

Hope the above helped you.

[uojorgensen]

Extremely helpful, this was right to the point. Well explained.

Thank You,
Ken