Error on the order.php while procesing order

[Kalpesh]

Hello ,

 

Can anyone help me out :

 

I am recieving an \error while client processes the order .I get the following error :

Table 'visionpu_new.ps_carrier_group' doesn't exist

 

 

SELECT c.*, cl.delay

FROM `ps_carrier` c

LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1)

LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `ps_zone` z ON (z.`id_zone` = 3)

WHERE c.`deleted` = 0 AND c.`active` = 1 AND cz.`id_zone` = 3

AND z.`active` = 1

AND c.`is_module` = 0

AND c.id_carrier IN (SELECT id_carrier FROM ps_carrier_group WHERE id_group IN (1))

GROUP BY c.`id_carrier`

Cannot resolve the issue. I am using 1.3.2 version of prestashop. Please help me out.....................

[tomerg3]

It looks like someone deleted that DB table.

 

I would try to see if you have a backup and restore it from there (in case other things got deleted).

 

If you don't have a backup (shame on you...), you can create the table in your database (use phpMyAdmin)

 

CREATE TABLE IF NOT EXISTS `ps_carrier_group` (
 `id_carrier` int(10) unsigned NOT NULL,
 `id_group` int(10) unsigned NOT NULL,
 UNIQUE KEY `id_carrier` (`id_carrier`,`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;