verano Posted April 24, 2004 Posted April 24, 2004 when i click Download Complete tab-delimited .txt file to edit i get this error 1054 - Unknown column 'p.products_master' 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_master as v_products_master, p.products_master_status as v_products_master_status, p.products_listing_status as v_products_listing_status, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id [TEP STOP] Quote
verano Posted April 24, 2004 Author Posted April 24, 2004 found out that i was working with a wrong version fixed that problem But still problems When i try anything to download to the temp dir ( that is chmod to 777) i get this error Warning: fopen(/home/tfhbe/public_html/shop/catalog//catalog/temp/EP2004apr24-1402.txt): failed to open stream: No such file or directory in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 597 Warning: fwrite(): supplied argument is not a valid stream resource in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 598 Warning: fclose(): supplied argument is not a valid stream resource in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 599 You can get your file in the Tools/Files under /catalog/temp/EPEP2004apr24-1402.txt Quote
Guest Posted April 24, 2004 Posted April 24, 2004 if you repost this into the main easy populate thread then it would probably get an answer. posting outside of the threads makes it hard for those of us who have it bookmarked. i know you have to search for it, but well worth it to read all the errors people have posted, you will find the majority of your answers Quote
verano Posted April 24, 2004 Author Posted April 24, 2004 i'm tryning to get my message in the main thread but it seems not to work Quote
241 Posted April 24, 2004 Posted April 24, 2004 (edited) have you the correct path to the temp folder that you are using. looks like the wrong path may be the issue check what is in easypopulate.php I have used the directory easypopulate for one of mine and so this is in easypopulate.php $tempdir = "easypopulate/"; $tempdir2 = "easypopulate/"; Edited April 24, 2004 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
verano Posted April 24, 2004 Author Posted April 24, 2004 i have it working now but i don't thrust it i edit the txt file that it makes in excell but the file seems to get smaller in bytes everytime i edit it The products i added does not seems to appear on the counter in the main catalog it screws up the dates that the products are added When i add 67 new products there seems only about 20 to get in the database do i do something wrong ? I don't want to loose any of the products that ive added manualy any hints Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.