user warning:

I get this exact same error. I do not have a table called munu_links in my database all of my tables are prefixed with drup_ so in my database the table is drup_menu_links so I changed line 228 to reflect this and the error went away. However I still get an error when trying to create a "nolink" menu item or a "separator" menu item. The error says "The path '"nolink"' is either invalid or you do not have access to it". So I still cannot use this module. I really need this functionality so please post any thoughts.

I am curious to know weather this is just an oversight or is that the default name of the table and for some reason all of my tables are prefixed but this is not normal. I only ask because there have been other modules and instructions online for things like manually turning off a module through an SOL query that have not matched up and I have had to add this prefix to make things work. I installed Drupal on my site via simple-scripts which was provided by my host and perhaps this is something they added.

I would still like to know how to fix this because this seems like it could be a great module. For now I have stumbled upon DHTML Menus module which works great. Just enable it and and your done, it just works! While the end result is just what I want and it has some great added benefits to it you still have to have a landing page for the link. It just does not do anything but expand the menu. It does this great but I am not thrilled about still having to create either a blank page or what I do is just point it to the first child.

Anyway psc give it a try at least you will have something till this module can be fixed.

Unfortunately it doesn't support table name prefixes.

Here is my solution, until the patch releases, update special_menu_items.module
From:

 // line 228
db_query("UPDATE menu_links SET link_path=CONCAT(CONCAT(link_path,'/'),mlid) WHERE (link_path='nolink' OR link_path='separator') AND hidden!=-1");

To:

db_query("UPDATE {menu_links} SET link_path=CONCAT(CONCAT(link_path,'/'),mlid) WHERE (link_path='nolink' OR link_path='separator') AND hidden!=-1");

Hi all,

Yes, somehow I missed adding the curly braces in that SQL statment. The new version is out now (with the curlies included!).

Khaled Zaidan

I'm seeing the same error on version 7.x-2.0