Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / 1146 Table 'products_with_attributes_stock' doesn't exist

1146 Table 'products_with_attributes_stock' doesn't exist

Views: 9,379

Results 1 to 4 of 4
20 Feb 2013, 10:31 PM
#1
g6_distribution avatar

g6_distribution

New Zenner

Join Date:
Aug 2011
Location:
Texas
Posts:
22
Plugin Contributions:
0

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

20 Feb 2013, 11:19 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1146 Table 'products_with_attributes_stock' doesn't exist

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

How did you upgrade?

21 Feb 2013, 4:36 PM
#3
g6_distribution avatar

g6_distribution

New Zenner

Join Date:
Aug 2011
Location:
Texas
Posts:
22
Plugin Contributions:
0

Re: 1146 Table 'products_with_attributes_stock' doesn't exist

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

21 Feb 2013, 5:35 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1146 Table 'products_with_attributes_stock' doesn't exist

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

1146 Table 'g6d1123408030021.zen_products_with_attributes_stock' doesn't exist