Reset Default Modules and Positions

[imoran]

I've been experimenting changing the positions of various modules, but wondered if there was a way to revert back them to their default positions or if there is a list so I can manually put things back to how they were?

Many thanks,

Iain.

[rocky]

No, there isn't an option in PrestaShop to do that. The only way I can think of to do that is to make a backup of your ps_hook_module table, then run the following SQL query using phpMyAdmin:

TRUNCATE `ps_hook_module`;
INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES (3, 1, 1),(6, 1, 2),(4, 1, 3),(8, 2, 1),(3, 4, 1),(6, 4, 2),(9, 6, 1),(16, 6, 2),(8, 6, 3),
(20, 6, 4),(15, 7, 1),(21, 7, 2),(10, 7, 3),(24, 7, 4),(14, 7, 5),(12, 7, 6),(7, 7, 7),(17, 7, 8),(5, 8, 1),(1, 8, 2),(19, 9, 1),(11, 14, 1),(13, 14, 2),(18, 14, 3),
(19, 14, 4),(22, 14, 5),(8, 19, 1),(23, 21, 1),(25, 11, 1),(25, 21, 2),(26, 32, 1),(27, 32, 2),(28, 32, 3),(30, 32, 4),(31, 32, 5),(32, 32, 6),(33, 32, 7),(34, 33, 1),
(35, 33, 2),(36, 33, 3),(37, 33, 4),(38, 36, 1),(39, 37, 1),(40, 32, 8),(41, 32, 9),(42, 32, 10),(43, 32, 11),(42, 14, 6),(43, 14, 7),(44, 32, 12),(45, 32, 13),(46, 32, 15),
(47, 32, 14),(48, 32, 16),(49, 32, 17),(50, 32, 18),(51, 32, 19),(51, 45, 1),(25, 25, 1),(41, 20, 2),(52, 32, 20);

Change ps_ to your database prefix. This will delete the module hook associations and then run the original query from the PrestaShop v1.3.1 installer. Note that you will lose all third-party module hook associations, so you will need to reinstall your third-party modules to restore them.

[mehnihma]

Can I do this in PS 1.5.1?

[taoufiqaitali]

HI 

 

No, there isn't an option in PrestaShop to do that. The only way I can think of to do that is to make a backup of your ps_hook_module table, then run the following SQL query using phpMyAdmin:
 

TRUNCATE `ps_hook_module`;INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES (3, 1, 1),(6, 1, 2),(4, 1, 3),(8, 2, 1),(3, 4, 1),(6, 4, 2),(9, 6, 1),(16, 6, 2),(8, 6, 3),(20, 6, 4),(15, 7, 1),(21, 7, 2),(10, 7, 3),(24, 7, 4),(14, 7, 5),(12, 7, 6),(7, 7, 7),(17, 7, 8),(5, 8, 1),(1, 8, 2),(19, 9, 1),(11, 14, 1),(13, 14, 2),(18, 14, 3),(19, 14, 4),(22, 14, 5),(8, 19, 1),(23, 21, 1),(25, 11, 1),(25, 21, 2),(26, 32, 1),(27, 32, 2),(28, 32, 3),(30, 32, 4),(31, 32, 5),(32, 32, 6),(33, 32, 7),(34, 33, 1),(35, 33, 2),(36, 33, 3),(37, 33, 4),(38, 36, 1),(39, 37, 1),(40, 32, 8),(41, 32, 9),(42, 32, 10),(43, 32, 11),(42, 14, 6),(43, 14, 7),(44, 32, 12),(45, 32, 13),(46, 32, 15),(47, 32, 14),(48, 32, 16),(49, 32, 17),(50, 32, 18),(51, 32, 19),(51, 45, 1),(25, 25, 1),(41, 20, 2),(52, 32, 20);

Change ps_ to your database prefix. This will delete the module hook associations and then run the original query from the PrestaShop v1.3.1 installer. Note that you will lose all third-party module hook associations, so you will need to reinstall your third-party modules to restore them.

 

 

 

Hi can you update this sql query to be used with prestashop 1.5.6.2 plz

[vekia]

http://www.prestashop.com/forums/topic/188370-reset-to-default-activated-positions-for-modules/

[satkauskas]

Just keep doing backups for your SQL base. Then you can easily restore all hooks from table PS_HOOK_MODULE. I just restored a crashed situation with hooks. Then adding some text to header, just crushed the order of logo, menu and search bar. No way to restore. And no need to extra restores. Just taking older SQL for table PS_HOOK_MODULE, and rewriting data with PHP my admin. Thanks.