Whoops - Need to reset positions to default

[swhost]

Hello,

While playing about I thought that I didn't need stuff in the header so I deleted them out of positions, I now realise it was't on about the actual header, just the head of the page.

Is there anyway to restore Back OfficeModules

Positions

to the default without having to reinstall all of the thing again?

I hope so, thanks in advance.

Dave

[phrasespot]

Here is a screen capture from 1.4.6.2. default install. For each module showing there hook it to header if is in deleted ones (Back Office > Modules > Positions > Transplant a module > Module > select module, select hook into = header of pages)

[Carlsen]

Run this query in MySQL, it will replace existing data with 1.4.7 positions, should be default.

 

-- --------------------------------------------------------
-- This should reset your module positions to normal.
-- Positions copied from Prestashop 1.4.7.0
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=[spam-filter]CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
/*!40000 ALTER TABLE `ps_hook_module` DISABLE KEYS */;
REPLACE INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES
(1, 8, 2),
(3, 1, 1),
(3, 4, 1),
(4, 1, 3),
(4, 4, 3),
(5, 8, 1),
(5, 9, 6),
(6, 1, 2),
(6, 4, 2),
(7, 7, 7),
(7, 9, 16),
(8, 2, 1),
(8, 6, 3),
(8, 9, 7),
(8, 19, 1),
(9, 6, 1),
(9, 9, 4),
(10, 7, 3),
(10, 9, 8),
(10, 60, 1),
(10, 61, 1),
(10, 62, 1),
(10, 66, 1),
(11, 9, 10),
(11, 14, 1),
(12, 6, 5),
(12, 7, 6),
(12, 9, 15),
(12, 21, 1),
(13, 9, 13),
(13, 14, 2),
(14, 7, 5),
(14, 9, 14),
(15, 7, 1),
(15, 9, 5),
(16, 6, 2),
(16, 9, 11),
(17, 7, 8),
(17, 9, 1),
(18, 9, 2),
(18, 14, 3),
(19, 9, 19),
(19, 14, 4),
(20, 6, 4),
(20, 9, 9),
(21, 7, 2),
(21, 9, 17),
(22, 9, 12),
(22, 14, 5),
(24, 7, 4),
(24, 9, 3),
(25, 11, 1),
(25, 21, 2),
(25, 25, 1),
(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),
(39, 37, 1),
(40, 32, 8),
(41, 20, 1),
(41, 32, 9),
(42, 14, 6),
(42, 32, 10),
(42, 95, 1),
(43, 14, 7),
(43, 32, 11),
(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),
(52, 32, 20),
(53, 32, 21),
(54, 6, 6),
(54, 9, 18),
(55, 32, 22),
(56, 2, 2),
(56, 15, 1),
(56, 19, 2),
(56, 23, 1),
(56, 26, 1),
(56, 30, 1),
(56, 34, 1),
(56, 39, 1),
(56, 96, 1),
(57, 8, 3),
(58, 2, 3),
(58, 5, 1),
(58, 13, 1),
(58, 16, 1),
(58, 26, 2),
(58, 41, 1),
(58, 42, 1),
(58, 53, 1),
(58, 96, 2),
(59, 7, 9),
(59, 9, 20),
(60, 9, 21),
(60, 17, 1),
(61, 9, 22),
(61, 17, 2),
(62, 40, 1),
(63, 1, 4),
(63, 4, 4),
(63, 6, 7),
(63, 20, 2),
(63, 21, 3),
(64, 6, 8),
(64, 9, 23),
(64, 10, 1),
(64, 23, 2),
(64, 26, 3),
(64, 35, 1),
(64, 96, 3),
(66, 7, 10),
(67, 7, 11),
(67, 9, 24),
(67, 21, 4),
(67, 60, 2),
(67, 61, 2),
(67, 62, 2),
(67, 67, 1),
(67, 68, 1),
(67, 69, 1),
(67, 70, 1),
(67, 71, 1),
(67, 72, 1),
(67, 73, 1),
(67, 74, 1),
(67, 75, 1),
(67, 76, 1),
(67, 77, 1),
(67, 78, 1),
(67, 79, 1),
(67, 90, 1),
(67, 91, 1),
(67, 92, 1),
(67, 93, 1),
(67, 94, 1),
(68, 63, 1);
/*!40000 ALTER TABLE `ps_hook_module` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[oldlock]

Hi

 

Will this query work for 1.4.8.3 ?

 

Thanks

 

Update -

 

I backed up the database and tried it, worked fine.

Edited August 22, 2012 by oldlock (see edit history)

[taoufiqaitali]

Run this query in MySQL, it will replace existing data with 1.4.7 positions, should be default.

 

-- --------------------------------------------------------
-- This should reset your module positions to normal.
-- Positions copied from Prestashop 1.4.7.0
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=[spam-filter]CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
/*!40000 ALTER TABLE `ps_hook_module` DISABLE KEYS */;
REPLACE INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES
(1, 8, 2),
(3, 1, 1),
(3, 4, 1),
(4, 1, 3),
(4, 4, 3),
(5, 8, 1),
(5, 9, 6),
(6, 1, 2),
(6, 4, 2),
(7, 7, 7),
(7, 9, 16),
(8, 2, 1),
(8, 6, 3),
(8, 9, 7),
(8, 19, 1),
(9, 6, 1),
(9, 9, 4),
(10, 7, 3),
(10, 9, 8),
(10, 60, 1),
(10, 61, 1),
(10, 62, 1),
(10, 66, 1),
(11, 9, 10),
(11, 14, 1),
(12, 6, 5),
(12, 7, 6),
(12, 9, 15),
(12, 21, 1),
(13, 9, 13),
(13, 14, 2),
(14, 7, 5),
(14, 9, 14),
(15, 7, 1),
(15, 9, 5),
(16, 6, 2),
(16, 9, 11),
(17, 7, 8),
(17, 9, 1),
(18, 9, 2),
(18, 14, 3),
(19, 9, 19),
(19, 14, 4),
(20, 6, 4),
(20, 9, 9),
(21, 7, 2),
(21, 9, 17),
(22, 9, 12),
(22, 14, 5),
(24, 7, 4),
(24, 9, 3),
(25, 11, 1),
(25, 21, 2),
(25, 25, 1),
(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),
(39, 37, 1),
(40, 32, 8),
(41, 20, 1),
(41, 32, 9),
(42, 14, 6),
(42, 32, 10),
(42, 95, 1),
(43, 14, 7),
(43, 32, 11),
(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),
(52, 32, 20),
(53, 32, 21),
(54, 6, 6),
(54, 9, 18),
(55, 32, 22),
(56, 2, 2),
(56, 15, 1),
(56, 19, 2),
(56, 23, 1),
(56, 26, 1),
(56, 30, 1),
(56, 34, 1),
(56, 39, 1),
(56, 96, 1),
(57, 8, 3),
(58, 2, 3),
(58, 5, 1),
(58, 13, 1),
(58, 16, 1),
(58, 26, 2),
(58, 41, 1),
(58, 42, 1),
(58, 53, 1),
(58, 96, 2),
(59, 7, 9),
(59, 9, 20),
(60, 9, 21),
(60, 17, 1),
(61, 9, 22),
(61, 17, 2),
(62, 40, 1),
(63, 1, 4),
(63, 4, 4),
(63, 6, 7),
(63, 20, 2),
(63, 21, 3),
(64, 6, 8),
(64, 9, 23),
(64, 10, 1),
(64, 23, 2),
(64, 26, 3),
(64, 35, 1),
(64, 96, 3),
(66, 7, 10),
(67, 7, 11),
(67, 9, 24),
(67, 21, 4),
(67, 60, 2),
(67, 61, 2),
(67, 62, 2),
(67, 67, 1),
(67, 68, 1),
(67, 69, 1),
(67, 70, 1),
(67, 71, 1),
(67, 72, 1),
(67, 73, 1),
(67, 74, 1),
(67, 75, 1),
(67, 76, 1),
(67, 77, 1),
(67, 78, 1),
(67, 79, 1),
(67, 90, 1),
(67, 91, 1),
(67, 92, 1),
(67, 93, 1),
(67, 94, 1),
(68, 63, 1);
/*!40000 ALTER TABLE `ps_hook_module` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Hi

i there a way to do this in ps 1.5.6.2