Advanced Search

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

/ Published in: SQL
Save to your folder(s)
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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.