Zen Cart Logo
Forums / General Questions / Problem at confirm checkout using stock by attribute

Problem at confirm checkout using stock by attribute

Locked

Views: 1,169

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
19 Apr 2008, 12:56 AM
#1
ausjohn avatar

ausjohn

New Zenner

Join Date:
Jan 2008
Posts:
12
Plugin Contributions:
0

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

19 Apr 2008, 1:30 AM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

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.

19 Apr 2008, 4:15 AM
#3
ausjohn avatar

ausjohn

New Zenner

Join Date:
Jan 2008
Posts:
12
Plugin Contributions:
0

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