Jump to content
Sign in to follow this  
fabriccut100

Unknown column 'pd.short_desc' in 'field list'

Recommended Posts

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

Share this post


Link to post
Share on other sites

You've been over the install twice & missed the same part twice!!!!

 

############# ADD SQL #################

 

ALTER TABLE `products_description` ADD `short_desc` TEXT;


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.

Share this post


Link to post
Share on other sites
This is a known mySQL 5 issue.

Rename to:

 

p.short_desc

 

 

Pardon?? Its not in that table!!


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.

Share this post


Link to post
Share on other sites

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;

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×