Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Is EasyPopulate 2.60 supposed to work with 2.2-MS2-CVS? I just created a fresh install of both EasyPopulate and osCommerce but get the following error when I try to download or create a complete txt file.

 

1054 - Unknown column 'p.products_caratweight' 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_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, p.products_caratweight as v_products_caratweight, p.products_gemlength as v_products_gemlength, p.products_gemwidth as v_products_gemwidth, p.products_gemheight as v_products_gemheight, p.products_dim_type as v_products_dim_type, p.products_length as v_products_length, p.products_width as v_products_width, p.products_height as v_products_height, 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
Is EasyPopulate 2.60 supposed to work with 2.2-MS2-CVS? I just created a fresh install of both EasyPopulate and osCommerce but get the following error when I try to download or create a complete txt file.

 

1054 - Unknown column 'p.products_caratweight' in 'field list'

 

It looks like you have created some special product fields and they are causing problems.

 

Also. 2.6 won't necessarily work with the current MS2, if you do a search you can find a message where it specifies that changes made in MS2 make a large number of the existing contributions incompatible. Apparently Easy Populate is one of them.

[no external urls in signatures please, kthanks]

Posted

I haven't created any fields, it;s just a basic install. I guess the version I have is too new, any idea where I can get an older copy of OSC?

Posted

The product fields you have listed above are NOT stock osc. This whole section:

 

p.products_caratweight as v_products_caratweight, p.products_gemlength as v_products_gemlength, p.products_gemwidth as v_products_gemwidth, p.products_gemheight as v_products_gemheight, p.products_dim_type as v_products_dim_type,

 

is not stock osc. Where did you get your download?

[no external urls in signatures please, kthanks]

Posted

interesting... that's my customized code. I didn't post it on the contrib section but had a link to it on another thread for others to see how to add custom fields... hope it didn't get folded back into the main release.

 

-al

Posted

I'm afraid it must be stock code since I downloaded my copy from the downloads section of this site.

Posted

You need to email the team about this because that is specialized code that should not be or is not in the base code. Go to the team page and click on Harald's email address. He does not read all the forum messages.

[no external urls in signatures please, kthanks]

Posted
I'm afraid it must be stock code since I downloaded my copy from the downloads section of this site.

 

I can confirm that this code is not part of the download included from this site. You can see the fields included in cvs by looking on sourceforge

 

http://cvs.sourceforge.net/cgi-bin/viewcvs.../oscommerce.sql

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

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

Software is like sex: It's better when it's free. (Linus Torvalds)

Posted

I'll try downloading it again but like I say, I downloaded it from here and didn't change a thing.

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...