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

[Johnnycopilot]

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

[DrByte]

Yes .

[Johnnycopilot]

Thank You.

[SilverHD]

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

[SilverHD]

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

[SilverHD]

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