Errors uploading file with Easy populate

[Guest]

Hi I am getting this error I have build 3.0 adding to a brand new site install.

 

Easy Populate 3.00-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: /localservices/phpupload/phpCoHgYR

User filename: webmod.txt

Size: 67774

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 = 'PWA110' AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

 

Any help would be great!

 

Thanks

 

Fletch

[red03]

Hi,

 

Im having a similar problem to that above when I try to upload a product file even if it's blank. I have been through the authors instructions but to no avail.

 

I have also searched the internet before posting a request because I know how many stupid questions get posted on boards sometimes. (I just hope this is not one)

 

I used to have the old version of easy populate and it worked great but the new release must work differently! I have also reloaded the Easy Populate files just to be sure! I'm using the latest release of OS Commerce 2.2.

 

The error I recieve is:

 

File uploaded.

Temporary filename: C:\WINDOWS\TEMP\php12C4.tmp

User filename: EP2006Apr25-1402.txt

Size: 83

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 = '' AND ptoc.categories_id = subc.categories_id

[bfchris]

I too, am having the exact same prob..there HAS to be a fix for this you know??

 

-bf

 

Hi,

 

Im having a similar problem to that above when I try to upload a product file even if it's blank. I have been through the authors instructions but to no avail.

 

I have also searched the internet before posting a request because I know how many stupid questions get posted on boards sometimes. (I just hope this is not one)

 

I used to have the old version of easy populate and it worked great but the new release must work differently! I have also reloaded the Easy Populate files just to be sure! I'm using the latest release of OS Commerce 2.2.

 

The error I recieve is:

 

File uploaded.

Temporary filename: C:\WINDOWS\TEMP\php12C4.tmp

User filename: EP2006Apr25-1402.txt

Size: 83

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 = '' AND ptoc.categories_id = subc.categories_id

[red03]

I reposed my question in the main Easy populate forum above this one as it seems to get more attention...

[bfchris]

hopefully we get some responses..there was a fix on that forum, but it didn't work.

 

-bf

[nosajix]

Me to!

[red03]

Me to!

 

 

Jason,

 

Check out the other forum and the fix does work, after my post you will see a conversation involving "bfchris" on the same topic and if you combine all the steps it does resolve the problem.