Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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]

Posted

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

Posted

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

Posted (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 by 241

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...