Top horizontal menu disappears when logging in

[Maria Gonzalez]

Hi,

I have a multistore prestashop installation, they are an exact copy just another language and different configurations.

 

I have modified the css from the top horizontal menu (but both shops are the same, in fact they use the same theme so is exactly the same).

 

In one of them I have no problem at all. But in the other (I just creating it), the top horizontal menu disappears, but only when the user is logged in, works well if the user is not logged in!!. 

 

When debug is activated I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category' at line 10

                SELECT c.*, cl.*
                FROM `ps_category` c
                 INNER JOIN ps_category_shop category_shop
        ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
                LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2
                LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
                RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 14 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
                WHERE 1 AND `id_lang` = 2
                
                 AND cg.`id_group` IN ()
                 GROUP BY c.`id_category`
                 ORDER BY c.`level_depth` ASC
                , category_shop.`position` ASC
                
at line 791 in file classes/db/Db.php

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }

DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 585 - classes/Category.php] - [1 Arguments]
CategoryCore::getNestedCategories - [line 480 - modules/blocktopmenu/blocktopmenu.php] - [4 Arguments]
Blocktopmenu->makeMenu - [line 730 - modules/blocktopmenu/blocktopmenu.php]
Blocktopmenu->hookDisplayTop - [line 587 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 580 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
IndexControllerCore->initContent - [line 189 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Any ideas of what is happening?

 

Thanks

Edited October 31, 2016 by Maria Gonzalez (see edit history)

[NemoPS]

AND cg.`id_group` IN ()

That's your issue. Is the logged customer belonging to any customer group?

[Maria Gonzalez]

Hi,

yes my customer is id_customer => 8

and on ps_customer_group It seems that id_customer (8) is in id_group (3) all the users are on id_group (3)

[Maria Gonzalez]

No , OK. You are right. I was looking that user in the another shop!!! 

The user hasn't any group, I added it and now it works!!!

 

Thanks

Edited October 31, 2016 by Maria Gonzalez (see edit history)