Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    4
    Plugin Contributions
    0

    Default error when checking out with stock by attribute mod

    I am using zencart 1.3.8a and just installed the stock by attribute mod v4.7ajax . I am playing with it and everything seemed to be ok until I completed checkout on an order for a product with stock attributes. I have the following eror and don't understand where to go from here:

    1146 Table 'ibelee_customers.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
    in:
    [select quantity from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK where products_id="211" and stock_attributes="1111"]

    I did not get any errors when I ran stock_attribute.sql and have done nothing else to the databases that I know of. Can anyone direct me as to what to fix here?

    If you need to try it yourself, the cart is at
    http://www.itsonlynaturalfarm.com/zencart/

    and the product I tried to purchase is :
    http://itsonlynaturalfarm.com/zencar...roducts_id=211

    Thanks to anyone who can help this newbie.

  2. #2
    Join Date
    May 2005
    Location
    Bath, Somerset
    Posts
    1,053
    Plugin Contributions
    3

    Default Re: error when checking out with stock by attribute mod

    You have a file missing - check your directories includes/extra_datafiles/. There should be one in there which includes the define for TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK

    It may be in the install file that you need to manually create this define, depending on the actual install files you have.

    Absolute
    Back, after a 4 year absence! Did you miss me?
    Absolute Web Solutions Ltd
    Interested in our work? Take a look at one of our sites - The Tech Store

  3. #3
    Join Date
    Jan 2010
    Posts
    4
    Plugin Contributions
    0

    Default Re: error when checking out with stock by attribute mod

    Thanks Absolute. Yep, the file was not uploaded correctly.
    -Zoa

  4. #4
    Join Date
    Jan 2010
    Location
    California, USA
    Posts
    1
    Plugin Contributions
    0

    Default Re: error when checking out with stock by attribute mod

    Hi. I'm having the same problem. My site is running fine, but when I go to check out and click "Add to Cart" or "Shopping Cart" I get the following message:
    Code:
    1146 Table 'aud1001602144692.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
    in:
    [select stock_id from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK where products_id = '48']
    I'm running ZC 1.3.8a. I have a few mods installed including Easy Populate from Langer and Cross Sell 1_3_0.

    I have gone through the install process step by step. I installed the mysql table and have verified it is in place through mysqladmin. I have also made sure that my file is properly place in "includes/extra_datafiles" and have checked the define for that. It appears to point to the proper place. I am really at a loss of why this is happening. It really concerns me though because my site is effectively down since no customers can complete an order.

    I would really appreciate any ideas anyone might have.

    Here is a link to my page so you can see yourself.

    www.audreysparks.com

 

 

Similar Threads

  1. v139d Error when checking out with Paypal
    By svetlae in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 13 Jan 2015, 07:26 PM
  2. Replies: 24
    Last Post: 8 Jun 2012, 08:37 AM
  3. Stock by Attribute setup and product has stock when added to card says out of stock
    By kwrosenzweig in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 9 Jun 2011, 06:18 PM
  4. Replies: 4
    Last Post: 22 Jan 2010, 10:43 PM
  5. Error when checking out with Paypal
    By Proverbs31 in forum PayPal Express Checkout support
    Replies: 3
    Last Post: 12 Nov 2007, 09:20 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