Links will not add to top horizontal menu

[duster]

I cannot add new (custom) links to the top horizontal menu.

 

 

 

When I save, I get the green tick and "The link has been added." Above it though there's an exclamation mark and "Bad SQL query"

When I look under Available Items - Menu Top Links, there's nothing there.

 

v 1.6.0.5
 

[vekia]

hello

if you've got "bad sql query" message - please turn on error reporting, then you will see detailed information what exactly doesnt work with sql query.

 

open: config/defines.inc.php

 

find this line define('_PS_MODE_DEV_', false);

change to look like this: define('_PS_MODE_DEV_', true);

 

then try to add new link in your module configuration page.

[duster]

Thank you Vekia,

 

With error reporting on I get the messages in the attached file.

 

I cannot find the unknown column gs.name in the database for this site.

 

I also should mention that I have manually updated this site from v 1.4.4.1

error_reporting.pdf

[duster]

This problem was fixed by uninstalling and reinstalling the module!

Edited April 2, 2014 by duster (see edit history)

[duster]

Unfortunately, the problem isn't solved - just different.

 

Now I can add links, but the menu doesn't show at all. When I checked hooks there were none, so I transplanted the module to displayTop, but it still doesn't show up on the front of the site. It doesn't show when I run live edit either.

 

Also, I have payment logos and a cms block positioned in displayLeft Column. The left column space shows, but the modules don't. When I run live edit, the modules can be seen in the left column, but cannot be moved or deleted from within live edit. See attached

 

Website

 

 

[clpadmin]

Hi,

i've got the same problem with the bad sql query.

What I did was to "Reset" the module.

It "almost" worked as I no longer have the Bad SQL Query

 

BUT

 

Now, I have 2 bugs :

 

when I add links it says it's ok but the link doies not appear in the list.

AND

my Categories don't show at all.

 

(I'll make a topic for that anyway) but I plug in your thread in case a solution comes by...

[clpadmin]

finally I won't have to create a topic....

Here what did work for me to get the Menu working again and make it shows up the categories in the configuration.

1) went in php my admin and did a repair on all ps_categories tables (not sure it is needed)

 

2) Next went in categories (in Back Office)

-- then clicked on a parent category containing sub categories to show sub categories

-- then reorder subcategories with the cross or arrows.

 

3) Went back to Modules (entered Top Menu in the search form to show the Top Menu... faster than searching by scrolling)

-- Click on the reset option in the dropdown menu (next to configure button)

 

 

4) once reseted : back to the configure Top Menu

- my categories now all show up !

- I can create link and add it to the Menu.

maybe it can help others....

last note :

-- upgrading from 1.4.4.1 to 1.6.0.5 is not that easy

[clpadmin]

finally I won't have to create a topic....

 

Here what did work for me to get the Menu working again and make it shows up the categories in the configuration.

 

1) went in php my admin and did a repair on all ps_categories tables (not sure it is needed)

 

2) Next went in categories (in Back Office)

-- then clicked on a parent category containing sub categories to show sub categories

-- then reorder subcategories with the cross or arrows.

 

3) Went back to Modules (entered Top Menu in the search form to show the Top Menu... faster than searching by scrolling)

-- Click on the reset option in the dropdown menu (next to configure button)

 

 

4) once reseted : back to the configure Top Menu

- my categories now all show up !

- I can create link and add it to the Menu.

 

maybe it can help others....

 

 

A small update:

 

I've tried "again" to do update from 1.4.4.x to 1.6

 

since the time of writing it is now 1.6.0.6 and 1-click Upgrade module is v1.3.11.

 

I had more trouble this time.

 

(had to recreate many sub categories in images and recreate all images)

 

But this time just editing all categories, saving them and reordering them was a no go and did not show up in the Menu.

 

I did all I've wrote above.

 

- I first tried to create a new Category/ => no go.

 

- I then created Another new top category - with root as parent this time.

- I checked reset in the module pane to reset Top Menu Module.

 

=> Going back in the top menu : categories show up again.

 

Note : when first going in the Category tab, the categories list was starting with Number 0 to N.

After saving each list containing categories numbers were then starting from 1 to N

 

Beside creating a New top Cat,  I also went thru all sub-categories edited them (simply clicked saved) and list where then Starting from 1 to N.

 

I think this helped too to get Categories showing back in the Top Menu Module. 

[rossdavidh]

Just wanted to add for others who may read this thread, that I was having this problem, but uninstalling and re-installing the module did the trick for me.  So it's worth trying, even if it doesn't work for everyone it might work for you.

[MarysWebLab]

Just wanted to add for others who may read this thread, that I was having this problem, but uninstalling and re-installing the module did the trick for me.  So it's worth trying, even if it doesn't work for everyone it might work for you.

 

This solved the issue in my case too, Prestashop 1.6.0.6