Custom Field Resetting

[insightcreative]

Hi

I've got a very annoying problem with VM 2.26d

I add a custom field:

Generic cart variant
Is a cart varian
Is a list

I've hacked the MySQL for the Default value to make it text instead of 255 chars as I'm putting in a ; separated string and 255 characters doesn't cover it.  So I add my list straight into phpmyadmin

So then I add the custom field for Colours to the product.  I add it in 50 times as there are 50 colours to chose from.

Then I select each colour from the drop downs.  So I start with:

Red
Red
Red
Red...

And end up with:

Red
Green
Blue
Black

Save the product, go to the front end and all is well.

Edit the product again and look at the custom fields

All the drop downs are now back to:

Red
Red
Red
Red

So even if I change the price, all my colours are messed up and I have to select them again.

Any ideas would be gratefully received.  It's a little inconvenient at this stage but it's going to get a whole lot worse as I add more products!

regards
Andy

[insightcreative]

As usual, you spend ages trying to work something out, post into the forum and then find the answer 10 seconds later!

When I put the values straight into the MySQL table there were new lines where I'd copied from a text doc.

Remove the new lines and voila!  no more resetting!

Cheers
Andy