fabriccut100 Posted July 22, 2008 Share Posted July 22, 2008 I've installed the product short description and now all I get is this error 1054 - Unknown column 'pd.short_desc' in 'field list' select p.products_image, pd.products_name, pd.short_desc, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '10' order by pd.products_name limit 0, 20 [TEP STOP] anyone have a clue why, I've been all over the code re-installed it twice and still get this!! any help would be greatly appreciated Quote Link to comment Share on other sites More sharing options...
DataMouse Posted July 22, 2008 Share Posted July 22, 2008 This is a known mySQL 5 issue. Rename to: p.short_desc Quote I had a blind date last night. Her name was ..:. :.: :: .. ::. :. ::. Black Web 2.0 Buttons Blue Orb Web 2.0 Buttons Mac "Aqua" Buttons Black Gloss Buttons Red Gloss Buttons (with metal edging) Link to comment Share on other sites More sharing options...
spooks Posted July 22, 2008 Share Posted July 22, 2008 You've been over the install twice & missed the same part twice!!!! ############# ADD SQL ################# ALTER TABLE `products_description` ADD `short_desc` TEXT; Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
spooks Posted July 22, 2008 Share Posted July 22, 2008 This is a known mySQL 5 issue.Rename to: p.short_desc Pardon?? Its not in that table!! Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2008 Share Posted November 6, 2008 I installed this contribution and appear to be working fine, but now when any product is edited, it clears out the product description field (retaining the short description field)...it displays it on the product preview page, but once I hit update it dissapears. I have checked my install and everything else over...any help would be greatly appreciated! Nikki You've been over the install twice & missed the same part twice!!!! ############# ADD SQL ################# ALTER TABLE `products_description` ADD `short_desc` TEXT; 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.