Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Extra Fields Problem


ianric

Recommended Posts

Hi

 

I have installed it (2.0j with no earlier version and used the code in the bug fix doc) and in my Admin I see it and I can add the extra fields to the products but when I refresh my product page I get

 

1146 - Table 'icr_records_oscommerce.table_products_extra_fields' doesn't exist

 

SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value ,pef.products_extra_fields_status as status FROM TABLE_PRODUCTS_EXTRA_FIELDS pef LEFT JOIN TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=30 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order

 

[TEP STOP]

 

I can see it in myPHP Admin so it DOES exist and there is data. Have I missed something.

 

TIA

 

Ian

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...