Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1
    Join Date
    Mar 2008
    Location
    USA
    Posts
    560
    Plugin Contributions
    0

    Default Problem installing MSRP display

    Hi guys:

    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. This is the error I received:

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

    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???

    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 so much in advance for your help.

    Silver

  2. #2
    Join Date
    Mar 2008
    Location
    USA
    Posts
    560
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Hi again:

    Can someone please help with this. I had to take

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

    out because I couldn't add product or make an adjustment. I know that I must be doing something a bit wrong but I really do need help with this.

    Help!

    Thank you,

    Silver

  3. #3
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Problem installing MSRP display

    I just installed this mod in a clean installation of Zencart 1.5.1 and it seems to work as advertised.

    The SQL patch would go in the Admin - Tools - Install SQL Patches box, and click Send.

    There are no configuration settings I can see. It appears that if you add an MSRP price to the product, it will display on both the product listing and product info page:

    See the tester category and test product at stevesh.com/demo.

  4. #4
    Join Date
    Mar 2008
    Location
    USA
    Posts
    560
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Steve:

    Thank you so much for answering. I attempted to add:

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

    via SQL Patches. This is the error I received:

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

    Now when I added it again, I am getting "The website cannot display the page"

    Any ideas??

    Thanks again for helping me with this,

    Silver

  5. #5
    Join Date
    Mar 2008
    Location
    USA
    Posts
    560
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Steve:

    This does not make any sense whatsoever. Since I added the script via SQL Patches, even though I got the error "The website cannot display the page," it is working. I think I must have some kind of ghost in my computer! This is completely NUTS! Any idea of why something like this would happen? I fought with this for an entire night and part of the day. No Logic whatsoever???

    Please let me know if you have an idea of why this happened.

    Thanks again,

    Silver

  6. #6
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Problem installing MSRP display

    No idea, but if it's working now, it may have been some sort of cache thing.

  7. #7
    Join Date
    Mar 2008
    Location
    USA
    Posts
    560
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Steve:

    Thanks again. I really appreciate your help.

    Silver

  8. #8
    Join Date
    Aug 2017
    Location
    Toronto, Ontario, Canada
    Posts
    33
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Where would I be able to get this add on?
    Thanks

    Anthony

  9. #9
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Problem installing MSRP display

    Quote Originally Posted by AnthonyEnnis View Post
    Where would I be able to get this add on?
    Thanks

    Anthony
    You can find MSRP Display here

  10. #10
    Join Date
    Aug 2017
    Location
    Toronto, Ontario, Canada
    Posts
    33
    Plugin Contributions
    0

    Default Re: Problem installing MSRP display

    Thanks, found it. Download ans installed. SQL updated for new column 'product_msrp'. However, the CCS change. Where in the stylesheet does this go? I'm using 1.5.5 e

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 MSRP Display Mod
    By Larry0652 in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 26 Oct 2017, 12:36 PM
  2. Dual Pricing 2 and New MSRP Display together?
    By jfelix in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 15 Nov 2012, 05:32 PM
  3. v150 MSRP Display edit
    By timhersh in forum All Other Contributions/Addons
    Replies: 24
    Last Post: 1 Nov 2012, 05:32 AM
  4. MSRP Display Mod / phpMyAdmin edit problem
    By rdcast in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 10 Sep 2011, 09:11 PM
  5. Msrp display issue
    By CRYSTALDOLL in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 10 Aug 2009, 02:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR