Jump to content
Sign in to follow this  
jannieballiett

1146 - Table 'oscommerce.TABLE_PRODUCTS_STOCK' doesn't exist

Recommended Posts

I've just installed EP, etc.

 

When I click on:

 

Create Complete tab-delimited .txt file in temp dir

 

I get the error page:

 

 

1146 - Table 'oscommerce.TABLE_PRODUCTS_STOCK' doesn't exist

 

select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '31' and products_stock_attributes = '2-13'

 

[TEP STOP]

 

I haven't been able to upload my products yet.

 

I have one saved as products.txt and one as products.cvs

 

Help!

Share this post


Link to post
Share on other sites

Hi

 

1) "TABLE_PRODUCTS_STOCK' doesn't exist" in your database have a look and see?

 

2) can you give a url


Thanks Simon

 

osCommerce Version: Online Merchant v2.2 RC 2a - Test Site with: oscommerce-2.2ms2-060817

cPanel Version: 11.23.4-RELEASE - Apache version: 2.0.63 - PHP version: 5.2.5 - MySQL version: 5.0.51a-community - Operating system: Linux

========================================================================

Share this post


Link to post
Share on other sites
Hi

 

1) "TABLE_PRODUCTS_STOCK' doesn't exist" in your database have a look and see?

 

2) can you give a url

 

 

No, I looked in MySQL and the TABLE_PRODUCTS_STOCK isn't in my DB...

 

I don't understand why--

 

What url do you want?

Share this post


Link to post
Share on other sites

your site url

 

what add-on with stock have you installed ie attributes with stock??

 

or the last addon you added to your site?

Edited by West One Hosting

Thanks Simon

 

osCommerce Version: Online Merchant v2.2 RC 2a - Test Site with: oscommerce-2.2ms2-060817

cPanel Version: 11.23.4-RELEASE - Apache version: 2.0.63 - PHP version: 5.2.5 - MySQL version: 5.0.51a-community - Operating system: Linux

========================================================================

Share this post


Link to post
Share on other sites

did you install this Easy Populate & QTpro ( http://addons.oscommerce.com/info/5411 )

 

and if so have you got this installed QTpro v1.0 - Quantity Tracking Professional ( http://addons.oscommerce.com/info/888 )

 

as you need both installed for it to work.

 

if you have both then you need to run a SQL file which was in the addon download you did.

Edited by West One Hosting

Thanks Simon

 

osCommerce Version: Online Merchant v2.2 RC 2a - Test Site with: oscommerce-2.2ms2-060817

cPanel Version: 11.23.4-RELEASE - Apache version: 2.0.63 - PHP version: 5.2.5 - MySQL version: 5.0.51a-community - Operating system: Linux

========================================================================

Share this post


Link to post
Share on other sites

products_stock is not a part of osCommerce(2.2 MS2 or any of the RC versions), and it's not part of any offshoot of osCommerce that I know of.

 

So it looks as though the version of Easy Populate you've installed is bugged.

 

Vger

Share this post


Link to post
Share on other sites
did you install this Easy Populate & QTpro ( http://addons.oscommerce.com/info/5411 )

 

and if so have you got this installed QTpro v1.0 - Quantity Tracking Professional ( http://addons.oscommerce.com/info/888 )

 

as you need both installed for it to work.

 

if you have both then you need to run a SQL file which was in the addon download you did.

 

 

Then that's the problem. I didn't get and instll the QTpro v.1.0

 

So I'll go get it and install it--

 

Thanks BUNCHES!

Share this post


Link to post
Share on other sites
Then that's the problem. I didn't get and instll the QTpro v.1.0

 

So I'll go get it and install it--

 

Thanks BUNCHES!

 

 

I saw Viger's post:

 

I got the latest EP 3.0 (I think it is the newest version)

 

And I've gone through the easypopulate.php (and all of them) and can not find reference to TABLE_PRODUCTS_STOCK anywhere!

 

I might have to delete it out and research this before installing EP again- but I've read praises and no problems like mine.

Edited by jannieballiett

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×