Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Location
    Texas
    Posts
    22
    Plugin Contributions
    0

    Default 1146 Table 'products_with_attributes_stock' doesn't exist

    I've been trying to figure out how I messed up or what I did wrong to bring it to this point. I keep getting this error when adding items to my cart -
    1146 Table 'g6d1123408030021.zen_products_with_attributes_stock' doesn't exist
    in:
    [select stock_id from zen_products_with_attributes_stock where products_id = '17']

    I've checked both my configure.php and they are the same

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', 'zen_');
    define('DB_SERVER', 'g6d1123408030021.db.8258795.hostedresource.com');
    define('DB_SERVER_USERNAME', 'g6d1123408030021');
    define('DB_SERVER_PASSWORD', '');
    define('DB_DATABASE', 'g6d1123408030021');
    define('USE_PCONNECT', 'false');
    define('STORE_SESSIONS', 'db');
    // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

    I've noted elsewhere that i should be changing my Database_tables.php to fix the solution, I'm just unsure what line item I need to change to direct it to the correct checkout database...

    My website is my screen name .com

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 1146 Table Error

    zen_products_with_attributes_stock is a db table from the plugin "stock by attributes"
    It is apparently missing

    How did you upgrade?
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2011
    Location
    Texas
    Posts
    22
    Plugin Contributions
    0

    Default Re: 1146 Table Error

    Hmm, I don't recall upgrading. I know where the file Products_with_attributes_stock.php is located though.

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 1146 Table Error

    I know where the file Products_with_attributes_stock.php is located though
    Thats the file but the error is stating the table(database) is missing
    Code:
    1146 Table 'g6d1123408030021.zen_products_with_attributes_stock' doesn't exist
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. 1146 Table doesnīt exist...
    By ppsoyal in forum General Questions
    Replies: 0
    Last Post: 29 Jan 2011, 10:37 PM
  2. 1146 Table 'XXXX.zen_configuration' doesn't exist in: [db_cache table]
    By CheapStairParts in forum General Questions
    Replies: 1
    Last Post: 4 Jan 2011, 12:39 AM
  3. 1146, table doesn't exist
    By swanriver in forum General Questions
    Replies: 4
    Last Post: 11 Dec 2010, 07:27 PM
  4. Replies: 5
    Last Post: 10 Jun 2010, 06:56 AM
  5. 1146 Table Doesn't Exist
    By pazdar in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 3 Jan 2008, 07:44 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