Easy Populate 3.00 MS2 getting 1146 Errors

[mmontalbano]

I've installed Easy Populate 3.00 for MS2 to a site and it appears to have installed just fine. The only problems I am seeing is that the links inside the Admin>Catalouge>Easy Populate ares for the text files are coming up with errors such as this when I try to download:

 

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

 

select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '33' and products_stock_attributes = '1-1'

 

[TEP STOP]

 

 

The link for this works fine:

 

Download Model/Category tab-delimited .txt file to edit

 

And the link for this works fine - Download Froogle tab-delimited .txt file to edit

 

When I click on this Create Model/Category tab-delimited .txt file in temp dir under the temp area I get this message -

You can get your file in the Tools/Files under /temp/EPEP2007Nov17-1212.txt

 

Have I missed something on the install or is this correct? How do I get the other text files to be available?

 

Any help would be appreciated.

[♥geoffreywalton]

1146 error means a table called TABLE_PRODUCTS_STOCK does not exist in the database called customto_customto.

 

What is your database called?

 

Does it contain a table called TABLE_PRODUCTS_STOCK?

 

google gave this http://forums.oscss.org/viewtopic.php?pid=3376

 

Ma base est oscss

les prefixes des tables sont : osc

 

dans mon fichier admin\includes\configure.php j'ai bien

Code:

 

define('DB_DATABASE', 'oscss');

define('DB_TABLE_PREFIX', 'osc_');

 

Dans mon fichier admin\includes\database_table.php, j'ai ajouté ceci

 

Code:

 

//++++ QT Pro: Begin Changed code

define('TABLE_PRODUCTS_STOCK', DB_TABLE_PREFIX . 'products_stock');

//++++ QT Pro: End Changed Code

 

This seems to indicate you have added the QT Pro contribution but have not added the above section to the config file.

[mmontalbano]

1146 error means a table called TABLE_PRODUCTS_STOCK does not exist in the database called customto_customto.

 

What is your database called?

 

Does it contain a table called TABLE_PRODUCTS_STOCK?

 

google gave this http://forums.oscss.org/viewtopic.php?pid=3376

 

Ma base est oscss

les prefixes des tables sont : osc

 

dans mon fichier admin\includes\configure.php j'ai bien

Code:

 

define('DB_DATABASE', 'oscss');

define('DB_TABLE_PREFIX', 'osc_');

 

Dans mon fichier admin\includes\database_table.php, j'ai ajouté ceci

 

Code:

 

//++++ QT Pro: Begin Changed code

define('TABLE_PRODUCTS_STOCK', DB_TABLE_PREFIX . 'products_stock');

//++++ QT Pro: End Changed Code

 

This seems to indicate you have added the QT Pro contribution but have not added the above section to the config file.

 

All I did was add the contribution to a 2.2 MS2 template. It had no additions to be made to the database. This table does not exist. What am I missing?

[mmontalbano]

All I did was add the contribution to a 2.2 MS2 template. It had no additions to be made to the database. This table does not exist. What am I missing?

 

customto_customto is my database. Here are the instructions I followed to add the contribution. It says nothing about changing the config.php file or adding anything to the DB

 

Installation and Configuration Instructions

 

1. The files in the EasyPopulate contribution are:

easypopulate.php - the code

easypopulate_functions.php - some functions that Pre-Nov-01-2002 2.2 OSC snapshots will need

easypopulate_functions-oldersnaps.php - if you get failed functions and have a MS1 2.2 version that is pre-May 2003 or is the Loaded 5 from phesis.co.uk, then reanme this file to easypopulate_functions.php

license.txt - the GPL license text that EasyPopulate (EP) is released under.

readmeFIRTS.txt - you are reading this now :)

and the instruction manual in various formats.

 

2. Copy file easypopulate.php and easypopulate_functions into admin/.

 

3. For adding link to the Admin, edit file admin/includes/boxes/catalog.php by adding this line:

 

// Easy populate

'<a href="' . tep_href_link(FILENAME_IMP_EXP_CATALOG, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_IMP_EXP . '</a><br>' .

// END Easy populate

 

After:

'<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '"

class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES .

'</a><br>' .

 

 

5. Create a directory called catalog/temp, (see below if your catalog isn't in a 'catalog' directory) and that it's permissions are set to allow writes to that directory, that would be 777 or rwxrwxrwx (in shell access - while you're in the catalog directory, execute "chmod 777 temp").

 

If you have changed the directory structure of your OSC install (i.e. you don't have /catalog/temp/ in your document root anymore), then you'll need to go into easypopulate.php and change the setting of "$tempdir". It is located right after the version history.

 

 

6. Edit file \admin\includes\filenames.php and add in bottom before ?> :

 

// Easy polulate //

define('FILENAME_IMP_EXP_CATALOG', 'easypopulate.php');

// END

 

7. Edit files \admin\includes\languages\english.php and \admin\includes\languages\italian.php and add in bottom before ?> :

 

// Easy polulate

define('BOX_CATALOG_IMP_EXP', 'Easy Populate');

// END

 

8. Copy file \admin\includes\languages\italian\easypopulate.php and \admin\includes\languages\english\easypopulate.php

 

 

9. Open easypopulate.php and read the section marked "Configuration Variables". It will allow you to adjust EP's operation for your store. I meant what I said, Please, Pretty please, do read the entire configuration stuff. Really. You'll be glad you did. You'll find all kinds of neat configurable stuff there. The instructions for using the various image mods and other supported contribtion variables are in there.

 

Support is available at http://www.oscommerce.com/forums in the Contribs section or at http://phesis.co.uk (separate forum for EP to be created by August 10, 2003)

 

Remember that this was written by volunteers, if you have questions, post in the forums, don't email any of the authors involved, since they may not be supporting the script any longer! Lives change and people contribute and move on :)

 

EP does a lot, but it doesn't do everything! If you update or add to the code, please email changes to [email protected] so they can be included in the next version for everyone to enjoy.

 

Thanks to Tim Wasson and those before him that made EP what it is today.

[♥geoffreywalton]

Dans mon fichier admin\includes\database_table.php, j'ai ajouté ceci

 

Code:

 

//++++ QT Pro: Begin Changed code

define('TABLE_PRODUCTS_STOCK', DB_TABLE_PREFIX . 'products_stock');

//++++ QT Pro: End Changed Code

 

This seems to indicate you have added the QT Pro contribution but have not added the above section to the config file.

 

----------------------

 

OK if you are convinced you didn't add this contribution search you site for the string/ths word

 

TABLE_PRODUCTS_STOCK

 

in the php files.

 

It must be there somewhere.

 

Which file is it in?