AZWheeler Posted December 1, 2007 Posted December 1, 2007 Anyone know how to fix this error? 1054 - Unknown column 'p.products_group_access' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_parent_id as v_products_parent_id, p.products_image as v_products_image, p.products_image_med as v_products_image_med, p.products_image_lrg as v_products_image_lrg, p.products_image_sm_1 as v_products_image_sm_1, p.products_image_xl_1 as v_products_image_xl_1, p.products_image_sm_2 as v_products_image_sm_2, p.products_image_xl_2 as v_products_image_xl_2, p.products_image_sm_3 as v_products_image_sm_3, p.products_image_xl_3 as v_products_image_xl_3, p.products_image_sm_4 as v_products_image_sm_4, p.products_image_xl_4 as v_products_image_xl_4, p.products_image_sm_5 as v_products_image_sm_5, p.products_image_xl_5 as v_products_image_xl_5, p.products_image_sm_6 as v_products_image_sm_6, p.products_image_xl_6 as v_products_image_xl_6, p.products_price as v_products_price, p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price5 as v_products_price5, p.products_price6 as v_products_price6, p.products_price7 as v_products_price7, p.products_price8 as v_products_price8, p.products_price9 as v_products_price9, p.products_price10 as v_products_price10, p.products_price11 as v_products_price11, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_price5_qty as v_products_price5_qty, p.products_price6_qty as v_products_price6_qty, p.products_price7_qty as v_products_price7_qty, p.products_price8_qty as v_products_price8_qty, p.products_price9_qty as v_products_price9_qty, p.products_price10_qty as v_products_price10_qty, p.products_price11_qty as v_products_price11_qty, 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, subc.categories_id as v_categories_id, p.products_group_access as v_prod_products_group_access FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = '147' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id [TEP STOP] Thank you for your help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.