Как САМОСТОЯТЕЛЬНО обновиться до версии OkayCMS 2*

ATTENTION! The instruction is intended for sites that did not have individual modifications and changes in the template.

To update OkayCMS to version 2. * you will need:

• empty subdomain for work;
• file manager;
• access to the admin panel of your website hosting.

Step by step guide:

1. Download the current version of OkayCMS and install it on a subdomain.
2. We go into the database of the newly installed site on the subdomain and delete it.
3. We import the database from the updated site (from the old site to OkayCMS).
4. We export this database to a new OkayCMS on a subdomain.
5. We go to https://github.com/OkayCMS/Okay .
6. Go to the 1DB_changes folder and find the SQL query files starting with the next version of OkayCMS, after which we update.
7. For example, if you are using version 1.1.6 - you need to execute SQL queries to the database on the new OkayCMS from all folders of subsequent versions one by one, starting from version 1.2.0, 1.2.1 ... to the latest version of OkayCMS
   

Additionally, be sure to execute the following SQL queries:

8. To save order statuses:

INSERT INTO `ok_orders_status` (` id`, `name`,` is_close`, `position`) VALUES

(1, 'New', 0, 1),

(2, 'Accepted', 1, 2),

(3, 'At the courier', 1, 3),

(4, 'Done', 1, 4),

(5, 'Deleted', 0, 5);

INSERT INTO `ok_lang_orders_status` (` lang_id`, `order_status_id`,` name`) VALUES

(1, 1, 'New'),

(2, 1, 'New'),

(3, 1, 'New'),

(1, 2, 'Accepted'),

(2, 2, 'Accepted'),

(3, 2, 'Accepted'),

(1, 3, 'At the courier'),

(2, 3, 'At the courier'),

(3, 3, 'At the courier'),

(1, 4, 'Done'),

(2, 4, 'Done'),

(3, 4, 'Done'),

(1, 5, 'Deleted'),

(2, 5, 'Deleted'),

(3, 5, 'Removed');

9. To add   order tags (if the site has other tags besides the standard ones, they will also need to be added):

INSERT INTO `ok_lang_orders_labels` (` lang_id`, `order_labels_id`,` name`) VALUES

(1, 1, 'call back'),

(2, 1, 'call back'),

(3, 1, 'call back'),

(1, 2, 'goods expected'),

(2, 2, 'goods expected'),

(3, 2, 'goods expected');

10. Change the id_status of order statuses in ok_orders (from 3 to 5, 2 to 4, 1 to 2, 0 to 1).

Execute requests one by one in this sequence:

UPDATE `ok_orders` SET` status_id` = 5 WHERE `status_id` = 3

UPDATE `ok_orders` SET` status_id` = 4 WHERE `status_id` = 2

UPDATE `ok_orders` SET` status_id` = 2 WHERE `status_id` = 1

UPDATE `ok_orders` SET` status_id` = 1 WHERE `status_id` = 0

After that, check if the site updated correctly on the subdomain.

If all is well, the site can be transferred to the main domain.

If you have any problems - contact technical support [email protected] and we will definitely help you!

In the next article, we will describe how to update your online store template.