How to change product attribute for order placed?

[Ajeh]

If you backup your database ...

Go to phpMyAdmin ...

Look at the structure of the orders_products_attributes table ...

Edit the field products_options_values and change from BLOB to TEXT ...

NOTE: I have not tested this 100% but at the moment I am not seeing any reason that this would not work for you so that you have a large field capable of holding anything that the products_options_values could hold before but this lets you view it in phpMyAdmin ...

I have to chew on this a bit and consider if there is any reason why this couldn't be changed this way ...

NOTE: you may wish to use a test site and test database and make the change on there and then conduct a lot of tests and examin your old data and see if you see anything obvious that might be moofed up ...

But, like I say, I don't think this will be an issue ... but again I have not tested it 100% ...

[barco57]

what was the reasoning for changing it in the first place from text to blob? Just curious, trying to learn.

[Ajeh]

It was way too small original because of all that field has to manage ... varchar(64)

So some "bright elf" got the idea that making it a BLOB was ideal so that "anything and everything" we may want to do with that field not and in the future would work and not have to be changed again and again ...

Unfortunately ... I didn't think about the fact you guys might want to browse the raw database and look at the raw data via phpMyAdmin ...

Gonna have to rethink the BLOBs ... I should of know after watching the movie ... you don't want to go there ...

[barco57]

Thanks for the explanation......also i'm now gonna have nightmares like I did when I was 5 (when the BLOB was colorized) Thanks

[Ajeh]

See? and you wonder why I work late at night ... I saw the black and white then colorized the same night ...

[barco57]

shivers, turns on all of the lights and locks the doors

[monkey_boy]

You've scared my monkey, but answered my question. Thanks!

[webomat]

If you backup your database ...

Go to phpMyAdmin ...

Look at the structure of the orders_products_attributes table ...

Edit the field products_options_values and change from BLOB to TEXT ...

NOTE: I have not tested this 100% but at the moment I am not seeing any reason that this would not work for you so that you have a large field capable of holding anything that the products_options_values could hold before but this lets you view it in phpMyAdmin ...

I have to chew on this a bit and consider if there is any reason why this couldn't be changed this way ...

NOTE: you may wish to use a test site and test database and make the change on there and then conduct a lot of tests and examin your old data and see if you see anything obvious that might be moofed up ...

But, like I say, I don't think this will be an issue ... but again I have not tested it 100% ...

A Question for Linda or Anyone "-)

I've been testing this -- changed it to text, edited, then changed it back. No problems that I've been able to ferret out.

Any reason not to do this? I could leave it as text always, but because they can upload files (with potentially longer names) and leave longer comments in a text box (no one has as yet) thought maybe better to put it back the way it was?

Basically I'm confused and just need a quick way to fix an order -- don't want to install Edit Orders or Super Orders until such a time as the functions I need are available. I'm comfortable using phpMyAdmin to mess things up. hehe.

Thanks for your input!

Becky

[monkey_boy]

I change it to text in phpMyAdmin, and it worked fine.

[Ajeh]

I have not broken it yet ... but I have more testing for this for future releases to do ...