ps_tab_module_preference doen't exist

[riz55]

version 1.5

 

set the PS_MODE_DEV to true and set the display errors to on

when I tried to login in the admin this is what i got

 

[PrestaShopDatabaseException]

 

Table 'koosko_db1.ps_tab_module_preference' doesn't exist

 

SELECT module

FROM ps_tab_module_preference

WHERE `id_tab` = 1

AND `id_employee` = 1

 

at line 607 in file classes/db/Db.php

 

601. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

602. }

603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

604. {

605. if ($sql)

606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**

[vekia]

this is "fresh" prestashop installation? if so, you how you installed it?

 

try to run query:

 

CREATE TABLE `ps_tab_module_preference` (
`id_tab_module_preference` INT(11) NOT NULL AUTO_INCREMENT,
`id_employee` INT(11) NOT NULL,
`id_tab` INT(11) NOT NULL,
`module` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id_tab_module_preference`),
UNIQUE INDEX `employee_module` (`id_employee`, `id_tab`, `module`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;