Hello, I'm in big big trouble...

I had a node reference field with a select list widget and 1,000 nodes in reference.

Since, I moved it in a multigroup and now I have 10,000 nodes in the select list widget...

So I would like to change the widget and have the autocomplete text field widget instead, but impossible:

The widget type cannot be changed because the field already has data created and this widget stores data differently in a Standard group than in a Multigroup. Allowing this change could result in the loss of data.

I'm using mutiple of rows/values in this multigroup, and some nodes has 30, 40 rows...

The problems are:

- The select list is so long... it's so boring to looking for nodes with so much values...
and it's only the beginning, I should have 500,000 valuess, even millions perhap, in a few years.

- The other reason I have to change the widget style is a problem with Javascipt. With 15, 20 rows, I can't add rows anymore. I can, but it's very difficult, it takes 5 10 minutes to have a row more.

Message browser (from Firefox):

Un script sur cette page est peut-être occupé ou ne répond plus. Vous pouvez arrêter le script maintenant ou attendre pour voir si le script se terminera.

Script : .../sites/default/files/js/js_0f481b4be2337a17de88a69377950c79.js:13

I've got others multigroups with node reference fields and autocomplete text field widgets and lot of rows/values and it works so well...

But the multigroup I was talking about, with the select list widget is , so far, the most importante one... and I really should to be able to choose the autocomplete list widget...

I really need help on this...

Thanks

Comments

lejonsson’s picture

I am having the same problem. I do not know the technical issues behind the restriction imposed, but I strongly agree there should be a way to change the widget type.

danzsmith’s picture

If I were you, I would just create a new field with the widget type you want and then use the Drupal migrate module to take the data from the internal Drupal node table and migrate it in to your new content type field (the one with the new widget). You have lots of records so I would look into using Drush to run the migration. I don't have time to to into all the details as I am fighting a deadline myself but you can get started be searching for Drupal Migrate module and Drush (Drupal shell) in Google.

Now if for some reason Migrate is not compatible with CCK 3.x than just forget everything I say above...but it is worth researching...

Hope this helps!

junro’s picture

Thanks for your help but it's not possible I think.

My field is a node referrence field and 20,000 nodes are using it. So I will lost all this, don't you?