Carl Charles Gale Posted April 22, 2006 Posted April 22, 2006 Have searched thru the forums yet icant seem to find a solution to this. I have installed easy pop 3 as per instructions, everything in right place etc, however when i try and export some data i get this message 1146 - Table 'd60226202.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '70' and products_stock_attributes = '3-5' [TEP STOP] any ideas? thanks
stevennickelby Posted April 22, 2006 Posted April 22, 2006 Have searched thru the forums yet icant seem to find a solution to this. I have installed easy pop 3 as per instructions, everything in right place etc, however when i try and export some data i get this message 1146 - Table 'd60226202.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '70' and products_stock_attributes = '3-5' [TEP STOP] any ideas? thanks did you have any prblem with the download and create tabs not working when you clicked on them. I can not seem to get them to work, no matter which version i try...i'm sorry i can't help you with your problem I just don't know. could you help?....http://www.oscommerce.com/forums/index.php?showtopic=205454&hl=
ekh Posted April 22, 2006 Posted April 22, 2006 :( I'm having the same problem with 3.0. After I wipe the database to start over, "Download complete tab-delimited ..." link works fine. However, when I uploaded the test file, it has the following error message, and no product were added. File uploaded. Temporary filename: /tmp/phpHeO2SE User filename: EP2006Apr22-1705-a.txt Size: 8319 1054 - Unknown column 'p.products_hide_from_groups' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.products_hide_from_groups as v_products_hide_from_groups, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = '81200-S' AND ptoc.categories_id = subc.categories_id [TEP STOP] After I add one item in the product, all in the sudden the "Download complete..." stop working and gives me the following error: 1146 - Table 'scriptserv.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '29' and products_stock_attributes = '3-5' [TEP STOP]
Recommended Posts
Archived
This topic is now archived and is closed to further replies.