Guest Posted December 10, 2004 Share Posted December 10, 2004 This Error has been really hard to figure out. But I'm not the only one. Another person with this problem said the scipt was missing a few decimals. visit the forum for more info http://www.oscommerce.com/community/contributions,1242 Need Help Please I get this error and I can't figure it out. Does anyone know why this is happening? If the field names are incorrect, where do I change them. Included is the readme from the patch any help would be great [email protected] 1054 - Unknown column 'p.products_price5' in 'field list' select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name [TEP STOP] :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2004 Share Posted December 10, 2004 unknown column means the field did not get inserted with the sql file, take a look at the contribution and see if that column is listed anywhere, or you may need to look for updates in the contribution area Quote Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2004 Share Posted December 10, 2004 unknown column means the field did not get inserted with the sql file, take a look at the contribution and see if that column is listed anywhere, or you may need to look for updates in the contribution area <{POST_SNAPBACK}> I will look. Thank you for replying. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2004 Share Posted December 10, 2004 I will look. Thank you for replying. <{POST_SNAPBACK}> Thank you, Your advise worked very well. It was a simple matter of adding the missing fields Quote Link to comment Share on other sites More sharing options...
Guest Posted December 10, 2004 Share Posted December 10, 2004 no problem, just a matter of reading the error message and then following through what the error message says Quote Link to comment Share on other sites More sharing options...
New 
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.