Posted By

Onfire60 on 12/09/10


Tagged

menu sql links drupal 6


Versions (?)

Drupal 6 - Fix Menu links you can't delete by reseting them to delete via SQL


 / Published in: SQL
 

Used the first sql statement to find your menu item. (Replace menu-% with the name of your menu eg. "primary-links" .

Then using the menu item id fix the items you want to regain the good old delete button on the menu item.

  1. /*Step 1 replace menu-% with your menu name*/
  2.  
  3. SELECT *
  4. FROM `menu_links`
  5. WHERE menu_name LIKE 'menu-%'
  6. AND module <> 'menu';
  7.  
  8. /*Step 2 - replace mlid number with number of your item*/
  9.  
  10. UPDATE menu_links SET module = 'menu' WHERE mlid LIKE '4078';

Report this snippet  

You need to login to post a comment.