Web Development and Design

How to update "changed" date for all nodes in Drupal 7 - the fastest way

The goal is to update ALL nodes "changed" or "updated" date with one SQL command. The reason behind this is called xmlsitemap. If you don't have any update on a node, you'll get something like "yearly" frequency in your sitemap for older nodes. What I really wanted was to refresh all nodes in a sitemap so that bots will see your nodes as fresh content. You can even fake it by adding something generic to all your nodes, and if you're lucky it won't look like spam. It's actually not spam, if we're talking about a new website. 

I hate this template!

One more thing. I really hate this website theme (TB Sirate). It's such a pain in the a$$! I'm so keen to migrate the entire website completely to a more user friendly Drupal 8!

Yeah, I said it!

PS: Does this make me a hater?

Drupal 8, a love - hate relationship

Drupal 8

I just started to get my hands dirty with Drupal 8, after almost 3 years of Drupal 7. 

Whoa! I was shocked at first impression. Every f*** thing is bloody different. It's like learning Drupal again and again. The shock from D6 to D7 wasn't that big though I hated Drupal when I first saw it.

Pages

Subscribe to RSS - Web Development and Design
 

Portfolio

Samples of work done for me or my customers, for free or not, like websites, repairs, photography etc.
View all my recent work

 

Tutorials

I'm giving away some knowledge in my areas of expertise. Did you like something here? Share it please!
View all tutorials

 

Snippets

Useful Linux commands or other code snippets I often use.
View my useful shortcuts

 

Resources

Few bookmarks I find useful. Do you want website here? Give me a good reason and I can help you.
View my favourite web resources

About me

Hi there! My name is Marius Cârneală.

About me?

Loving husband, dad of two, drone pilot, web designer and administrator, SEO specialist, IT support guy, electronic hobbyist and content writer. This list is open.