Dashboard Access Denied

[gabiatti]

I'm having problem accessing the back office.

 

My home page (Dashboard) is not working. All other tabs are ok, except the logs, that shows me:

• Bad SQL query
  Unknown column 'a.id_employee' in 'on clause'

 

I'm already create a new SuperAdmin and delete the old one, check all permissions, check the tables ps_access and ps_employee, but did not find anything helpful.

 

There's one or two posts about that here in the forum as solved, but none worked for me

 

PS vs 1.5.4.1, default theme

[vekia]

can you turn on error reporting and paste here detailed information about query where the problem occurs?

[gabiatti]

Tks Vekia

 

Dashboard: no errors, only the message "access denied"

 

Advanced Parameters/Logs:

[PrestaShopDatabaseException]

Unknown column 'a.id_employee' in 'on clause'
 

        SELECT SQL_CALC_FOUND_ROWS
         a.*
        , CONCAT(LEFT(e.firstname, 1), '. ', e.lastname) employee
        FROM `ps_log` a
        
         LEFT JOIN ps_employee e ON (a.id_employee = e.id_employee)
        
        WHERE 1
        
        
        ORDER BY a.id_log ASC LIMIT 0,50
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.     /**

• DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 2200 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->getList - [line 1533 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->renderList - [line 1442 - classes/controller/AdminController.php] - [0 Argument]
• AdminControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 50 - admin5027/index.php] - [0 Argument]

[El Patron]

do you have a module that logs information about back office employee installed?

 

the ps_log table 'native 1.5.4.1' does not have id_employee, i.e. it does not write out prestashop log with id of employe.

[gabiatti]

I don't think I have a module like that, except for the Zopim Chat, that I uninstalled.

[El Patron]

I don't think I have a module like that, except for the Zopim Chat, that I uninstalled.

 

my money is that you at some point installed an employee tracker, maybe from carolina design possibly. 

[gabiatti]

Tried to disable all non-native plug-ins, no success.

 

Take a look at another store, I saw that I don't have the field HOME in Administration/Permissions, The first field is CMS Pages.

 

The other site is in Portuguese, but its easy to conclude that the permissions for HOME (Inicio) is missing on the site that does not show the Dashboard.  

 

The following message:

• blockinfos module is installed in the database but its files are missing/incompatible.

 

Any tip to fix? 

Edited May 9, 2014 by gabiatti (see edit history)

[gabiatti]

I've upload ps_access from an old database, and now it works to the Administrators profile, but not to the SuperAdministrator. Weird!!!

 

Controller not found

The controller AdminDashboard is missing or invalid.

• Go to the dashboard.
• Back to the previous page.

 

If AdminDashboard is a file, I don't have it here in any backup.

 

The Tab Permissions does not have the item HOME (as post # 7) and shows: blockinfos module is installed in the database but its files are missing/incompatible