Adding Descriptions To Invoices

[Jeff Finn]

Hi All;
Dr. Byte posted a set of instructions quite awhile ago for putting descriptions on Zen Cart Invoices. I figured out all of the required changes but I'm not sure about one thing. He says:

And add an additional field in your orders_products table:
Code:
alter table orders_products add column products_description text NOT NULL;


Do I run this piece of code in the Install Sql Patches box or am I supposed to do something else with it?
Thanks!

[Jeff Finn]

Hi All;
Dr. Byte posted a set of instructions quite awhile ago for putting descriptions on Zen Cart Invoices. I figured out all of the required changes but I'm not sure about one thing. He says:

And add an additional field in your orders_products table:
Code:
alter table orders_products add column products_description text NOT NULL;


Do I run this piece of code in the Install Sql Patches box or am I supposed to do something else with it?
Thanks!

[Jeff Finn]

Okay, So I guess I'll skip that modification.
Thanks anyway.

[Ajeh]

You can run that in the Install SQL Patches ... and it would add the new field so that you can store the information during the order process ...

[Jeff Finn]

You can run that in the Install SQL Patches ... and it would add the new field so that you can store the information during the order process ...

Sorry I've been away so long. I get an error when I try to run that piece of code from the Install SQL Patches application. Am I missing something?
Thanks.

[yellow1912]

It think it goes without saying, but shouldn't you post the exact error you get so people can know what's going on and can help you?