Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged drupal



« Prev 1 Next »
  1. FAV

    Login to Drupal while site in maintenance

    SQL 4 views posted 8 years ago by athome
  2. FAV

    Convert Drupal path_redirect to WordPress Plugin Redirection

    This SQL takes the redirects from Drupal 5.5 tables and converts them into a format the WordPress plugin Redirection can understand.
    SQL 0 views posted 9 years ago by ethicka
  3. FAV

    Drupal 6 - Fix Menu links you can\'t delete by reseting them to delete via 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.
    SQL 0 views posted 9 years ago by Onfire60
  4. FAV

    Set Drupal site online

    SQL saved by 3 people 0 views posted 9 years ago by titosemi
  5. FAV

    Set Drupal site offline

    SQL saved by 2 people 0 views posted 9 years ago by titosemi
  6. FAV

    Reset Drupal admin password

    SQL saved by 1 person 1 views posted 10 years ago by sennesaelium
  7. FAV

    move Drupal tags from one vocabulary into another

    I had several vocabularies but wanted to merge them into one. A simple query does this for you. The vocabulary_id where I wanted to merge all the tags into is 3 The vocabulary_id where the tags are to be merged from is 7, 8 and 12
    SQL saved by 4 people 2 views posted 10 years ago by berkes
  8. FAV

    MySQL Find and Replace Drupal filepaths in files table

    This is useful if you are changing a Drupal site's file upload path and/or changing from a private to a public file store.
    SQL saved by 6 people 4 views posted 11 years ago by shrop
  9. FAV

    Count amout of nodeviews in a year

    Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).
    SQL saved by 1 person 1 views posted 13 years ago by berkes
  10. FAV

    list of users that never logged in

    Grab all users that never logged in.
    SQL saved by 1 person 0 views posted 13 years ago by berkes
« Prev 1 Next »