Easy Populate 3.00-MS2

[andrew40]

Installed Ok and running but on a few of the links I am getting some sql errors.eg

 

Download customized tab delimited gives me

 

"1054 - Unknown column 'sp.customers_group_id' 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, sp.specials_new_products_price as v_specials_new_products_price, sp.customers_group_id as v_customers_group_id, 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.products_hide_from_groups as v_products_hide_from_groups, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p left join specials as sp on p.products_id = sp.products_id, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]"

 

Download Model Price Qty gives me

 

1146 - Table 'ok50.TABLE_PRODUCTS_GROUPS' doesn't exist

 

SELECT customers_group_price, customers_group_id FROM TABLE_PRODUCTS_GROUPS WHERE products_id = 1 ORDER BY customers_group_id

 

[TEP STOP]

 

 

am I missing something blindingly obvious here as everything else seems to work..

[selmaboyd]

Installed Ok and running but on a few of the links I am getting some sql errors.eg

 

Download customized tab delimited gives me

 

"1054 - Unknown column 'sp.customers_group_id' 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, sp.specials_new_products_price as v_specials_new_products_price, sp.customers_group_id as v_customers_group_id, 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.products_hide_from_groups as v_products_hide_from_groups, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p left join specials as sp on p.products_id = sp.products_id, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]"

 

Download Model Price Qty gives me

 

1146 - Table 'ok50.TABLE_PRODUCTS_GROUPS' doesn't exist

 

SELECT customers_group_price, customers_group_id FROM TABLE_PRODUCTS_GROUPS WHERE products_id = 1 ORDER BY customers_group_id

 

[TEP STOP]

am I missing something blindingly obvious here as everything else seems to work..

 

Hi Andrew,

 

I think what you are missing is the message where the creator of contribution 3.0 said "DO NOT USE" there are issues that he is working out. Check the latest contribution for EP dated Apr 26 2006