Advanced Top Menu problem

[vansrv7]

I just installed Advanced Top Menu in my PS 1.5.6.1 

 

I have a problem configuring it: I created a simple "Home" tab with a link to index.php, but the tab is not shown in the menu on Home page nor in the "menu configuration" window in module back office, so I can't edit or delete it. Made a few try with other tabs with same result.

 

The menu informations are stored in the DB, so I can't see where is the problem.

 

Any help?

Edited April 26, 2014 by vansrv7 (see edit history)

[vekia]

 

 

I created a simple "Home" tab with a link to index.php, but the tab is not shown in the menu on Home page nor in the "menu configuration" window in module back office

it is visible on menu items available to add to the menu? or it isn't visible there too?

[vansrv7]

Hi Vekia,

it isn't visible anywhere.

If I try to add a column to that tab (or other created tabs like a category type), in the drop-down menu when I have to choose the parent tab, the created tabs are not visible either.

[vansrv7]

Activated error reporting and this is what is shown:   [PrestaShopDatabaseException]

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 '= c. AND c_shop.id_shop IN (8) LEFT JOIN ps_cms_lang cl ON (c.id_cm' at line 13

 

 

SELECT atp.*, atpl.*,

                cl.link_rewrite, cl.meta_title,

                cal.link_rewrite as category_link_rewrite, cal.name as category_name,

                m.name as manufacturer_name,

                s.name as supplier_name

                FROM `ps_pm_advancedtopmenu` atp

                 INNER JOIN `ps_pm_advancedtopmenu_shop` atp_shop

                        ON atp_shop.id_menu = atp.id_menu

                        AND atp_shop.id_shop IN (8)

                LEFT JOIN `ps_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 1)

                LEFT JOIN ps_cms c ON (c.id_cms = atp.`id_cms`)

                 INNER JOIN `ps_cms_shop` c_shop

                        ON c_shop. = c.

                        AND c_shop.id_shop IN (8)

                LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)

                LEFT JOIN ps_category ca ON (ca.id_category = atp.`id_category`)

                LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = ca.`id_category`)

                LEFT JOIN ps_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 1 AND cal.id_shop = 8 )

                LEFT JOIN `ps_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)

                 INNER JOIN `ps_manufacturer_shop` m_shop

                        ON m_shop. = m.

                        AND m_shop.id_shop IN (8)

                LEFT JOIN `ps_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)

                 INNER JOIN `ps_supplier_shop` s_shop

                        ON s_shop. = s.

                        AND s_shop.id_shop IN (8)

                

                WHERE atp.`active` = 1

                AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0)

                OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)

                AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1))

                

                ORDER BY atp.`position`

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

 

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

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

608.         }

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

610.         {

611.             if ($sql)

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

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

614.         }

615.     }

616.

617.     /**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 278 - modules/pm_advancedtopmenu/AdvancedTopMenuClass.php] - [1 Arguments]
• AdvancedTopMenuClass::getMenus - [line 3162 - modules/pm_advancedtopmenu/pm_advancedtopmenu.php] - [4 Arguments]
• PM_AdvancedTopMenu->hookTop - [line 475 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 429 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php] - [0 Argument]
• IndexControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

[studiobike.it]

Ciao Vekia, volevo chiederti una cosa, è da più di 15 giorni che sto impazzendo a cercare la soluzione online senza trovare la soluzione, in pratica ho acquistato un template per prestashop v1.6.0.14 (specialdev206-bootstrap) l'ho istallato e all'inizio era tutto ok, dopo circa una settimana ho dovuto reinstallare nuovamente prestashop per altri problemi facendo un'istallazione ex novo sempre con la stessa versione, ed ecco che esce il problema, il top menu orizzontale praticamente scende verso il basso diventando alto quanto tutte le voci delle categorie, (vedi allegato)

sai per caso come posso risolvere? perchè sono costretto a tenere il modulo disattivato, ah, premesso che sono pochissimo pratico, grazie 1000 anticipatamente.

[Bumbe86]

Hello everyone,

I have a problem with advanced top menu module when I insert a new menu item.

The last inserted item is entered with an id_item equal to 0.

This item can not be deleted but can be edited.

The error I see on video is: "An error occurred while update data"

 

Thanks in advance.