Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    12
    Plugin Contributions
    0

    Default Problem at confirm checkout using stock by attribute

    I am having trouble at confirm checkout.
    My customers get this message when they click confirm (3 of 3):

    1146 Table 'shazzas_clothes08.sc_products_ratio' doesn't exist
    in:
    [SELECT ratio FROM sc_products_ratio WHERE products_id=116 LIMIT 1]

    and the rest of the page is blank.


    Is there anything I can do to fix this as they keep clicking and refreshing page which duplicates the orders

    I have a feeling i need to run the sql again with stock by attributes, but if I do, will it stuff all my work up to date??


    Any help will be appreciated./

    Using Zen Cart 3.8 stock with attributes

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Problem at confirm checkout using stock by attribute

    You are missing a table called sc_products_ratio. However, Stock by Attributes doesn't have a table called this, so you must have code from another mod installed without the table that goes with it.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Jan 2008
    Posts
    12
    Plugin Contributions
    0

    Default Re: Problem at confirm checkout using stock by attribute

    Kuroi
    Thanks for your fast reply.
    And of course, you are right. It was another mod.
    At this point, I would like to thank you for your mod which works perfect for my clothing store.
    It is really easy to use and I can see a lot of work went into it.

    Cheers
    ausjohn

 

 

Similar Threads

  1. can stock by attribute work using only one attribute?
    By simwombat in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 8 Dec 2011, 03:34 PM
  2. problem with Stock By Attribute -- Manage Attributes Stock tool
    By abran1984 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 10 Nov 2011, 06:23 AM
  3. Change Confirm Terms to Confirm Returns Policy on Checkout
    By ScriptJunkie in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 8 Feb 2011, 04:11 AM
  4. Checkout Confirm Blank Page Can't confirm order
    By gump47371 in forum General Questions
    Replies: 1
    Last Post: 24 Oct 2010, 11:35 PM
  5. Using actual stock as an attribute.....
    By LRS in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 13 Jan 2010, 05:57 AM

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