Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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

Link to comment
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.

Link to comment
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.

Link to comment
Share on other sites

  • 3 months later...

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;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...