advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.