xiu Posted November 6, 2005 Share Posted November 6, 2005 I got this when uploading EP file: File uploaded. Temporary filename: /tmp/phpDiLcbn User filename: EP2005Nov06-1604.txt Size: 3394 1054 - Unknown column 'p.products_image_med' 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_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_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.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 = 'ck001' AND ptoc.categories_id = subc.categories_id [TEP STOP] Is it UltraPics additional code? I think I don't need that fields. What should I do? Really desperate about it since I have to online my store soon. Thanks in advance, Xiu Quote Link to comment Share on other sites More sharing options...
John Pagan Posted February 15, 2006 Share Posted February 15, 2006 I've just hit the same problem - anyone any ideas? Quote Link to comment Share on other sites More sharing options...
methodprobiz Posted February 19, 2006 Share Posted February 19, 2006 I got this when uploading EP file: File uploaded. Temporary filename: /tmp/phpDiLcbn User filename: EP2005Nov06-1604.txt Size: 3394 1054 - Unknown column 'p.products_image_med' 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_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_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.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 = 'ck001' AND ptoc.categories_id = subc.categories_id [TEP STOP] Is it UltraPics additional code? I think I don't need that fields. What should I do? Really desperate about it since I have to online my store soon. Thanks in advance, Xiu This is most likely being caused by something other than EP but just the same... your database table (products) is missing entry for image_med in the field list. If you have phpMyAdmin, view your products table Make sure you are in correct table by finding one of the other entries in the list that seem to be working - do you see image_med in there? If not, you will need to insert that ...best way is to check the install instructions of contribution using this (UltraPics?), and verify that you have followed any SQL query instructions for adding tables to your database. Good luck! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.