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,655
    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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. Stock by Attribute - Out of Stock Error Message
    By genxian in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 27 May 2011, 06:37 PM
  2. Stock by Attribute not working - allows checkout?
    By bodybangles in forum All Other Contributions/Addons
    Replies: 8
    Last Post: 20 Mar 2008, 06:12 PM
  3. Stock by Attribute 4.7 & ZC 1.3.8 - check stock before adding to cart
    By dsswanson in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 22 Jan 2008, 09:36 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
  •