Is there an easy way to change a node's language from 'Language neutral' to the default language (English in this case) without individually updating each node? When the nodes were inputted initially Language neutral was the default instead of English. Bad planning on my part I know, but I'm hoping there is a batch process to save me some time.

Any help appreciated. Thanks.

Comments

brucepearson’s picture

brucepearson commented

You can run a database query to do this.

UPDATE node SET language="en" where language=""

Make sure you do a DB backup before doing this.

louisx20’s picture

louisx20 commented

perfect. Thanks.

kars-t’s picture

kars-t commented
Status: Active » Closed (fixed)
revnoah’s picture

revnoah commented
Version: 6.x-1.7 » 7.x-1.8

A small adjustment is needed for this to work in Drupal 7

UPDATE node SET language = 'en' WHERE language = 'und';

outlaw82’s picture

outlaw82 commented

when I change the language i need to change the data body to in order to be able to modify the text already written

UPDATE field_data_body SET language = 'en' WHERE language = 'und';