Help with addon MSRP: Add a new field to the products table

I want to install MSRP Display. The install seems simple except I don't know how to make the following change...

1. Add a new field to the products table to hold the MSRP value.

ALTER TABLE products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;

Do I put that text in the "install SQL Patches" Box in the admin section, and hit send? Thanks :smile:

Yes .

Thank You.

Hello:

I am having difficulty installing the MSRP Display. I thought I did everything right, including installing:

```ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;

via SQL Patches. It said some kind of error at the point after I clicked send??? I have no idea what that meant. In the instructions it says:

Add a new field to the "products table" to hold the MSRP value. If I knew where the products table was, I would just install it there???

Any suggestions please?

Thank you,

Silver

Hi again:

I thought I would give an update on the error I am getting when I go to SQL patches. I just tried to send the file again and this is what I got:

"Error: Nothing to do - no query or query-file specified." (without quotation marks)

Any idea of what I am doing wrong?

Thank you,

Silver

Hello again:

This is another update. I went to: <your_admin/includes/modules/update_product.php> and placed the code:

<ALTER TABLE products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ; > there.

Here is what happened. I couldn't find the module in the Configuration or in the Modules area in admin, so I went to a product in the catalog and the MSRP was there. I placed a figure in there and clicked on preview. When I clicked "Update" this is what I got:

The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.
What you can try:

Refresh the page.	etc.

I obviously did something wrong. I am not going to touch this without help for fear that I'll really screw things up, if I haven't already. The site is : http://www.petluxuryboutique.com

Thanks in advance,

Silver