EASY POPULATE

[glamourfish]

anybody know what this means?

 

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

[realhotstuff]

anybody know what this means?

 

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

 

You need to give out more information so others can help you. e.g. your url and which php caused the problem..... More information will give us more hints, not just a question like this.

[ozcsys]

My guess is you installed a contribution and did not bother running the sql file or commands.

[glamourfish]

Thanks all got this sorted eventually!.

 

had to delete 'p.products_hide_from_groups' from my easypopulate.php file. works fine now.

[vsonline]

Thanks all got this sorted eventually!.

 

had to delete 'p.products_hide_from_groups' from my easypopulate.php file. works fine now.

 

Ohh man, I'm really not looking forward to messing around with EasyPopulate, but no choice, need to insert 999+ products, *sigh* its gonna be a long couple of days lol

[glamourfish]

I felt the same - took me a day or 2 to figure it out, but it works like a charm. let us know if you really get stuck....

But if you carefully read all the instructions you should be fine.!

 

I git stuck in a few places but managed to get some help from some guys here so mabe I could help you if you get stuck!

[241]

so you removed these from the easypopulate.php

 

'v_products_hide_from_groups'

 'v_products_hide_from_groups' => $iii++,

 p.products_hide_from_groups as v_products_hide_from_groups,

 products_hide_from_groups,

 '$v_products_hide_from_groups',

 

If not then that is why the error

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