Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Support thread for JcM Product info date added+Info V1.1 CE


Recommended Posts

A simple add-on to let you display date added and other info on the product info page. A very simple box with all info makes layout very easy to keep tidy.

Date format and box color can be changed in admin. Some info only displayed if available. Again totally standalone with no core code change. Simply copy all files into relevant sections and go to admin modules /content and install.

image.png.ff472f440a960ed3f63757b35e3ac3ff.png

 

Link to comment
Share on other sites

  • 2 years later...

When I install the module and plug it in content
The following error occurs to me

1146 - Table '... .TABLE_PRODUCTS' doesn't exist

select p.products_id, pd.products_name, pd.products_seo_keywords, pd.products_seo_description, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_last_modified, p.manufacturers_id, p.products_gtin from TABLE_PRODUCTS p, TABLE_PRODUCTS_DESCRIPTION pd where p.products_status = '1' and p.products_id = '511' and pd.products_id = p.products_id and pd.language_id = '5'

[TEP STOP]

Link to comment
Share on other sites

42 minutes ago, kep@ said:

When I install the module and plug it in content
The following error occurs to me

1146 - Table '... .TABLE_PRODUCTS' doesn't exist

select p.products_id, pd.products_name, pd.products_seo_keywords, pd.products_seo_description, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_last_modified, p.manufacturers_id, p.products_gtin from TABLE_PRODUCTS p, TABLE_PRODUCTS_DESCRIPTION pd where p.products_status = '1' and p.products_id = '511' and pd.products_id = p.products_id and pd.language_id = '5'

[TEP STOP]

That could be due to the fact that you don't have a database.php with a definition for TABLE_PRODUCTS.

Link to comment
Share on other sites

8 minutes ago, kep@ said:

This is mine datebase.php

database.php

Assuming the definition is in there, you then to check application_top.php to see if the project is including database.php

You don't mention what version of osCommerce you're using but at some point the CE removed that from application_top.php

Link to comment
Share on other sites

7 minutes ago, Hotclutch said:

Assuming the definition is in there, you then to check application_top.php to see if the project is including database.php

You don't mention what version of osCommerce you're using but at some point the CE removed that from application_top.php

osCommerce Online Merchant v2.3.4.1 CE

Link to comment
Share on other sites

2 minutes ago, kep@ said:

osCommerce Online Merchant v2.3.4.1 CE

All the CEs are labelled like that. You need to check application_top.php, or alternative to that you can edit the code, replace TABLE_PRODUCTS with products. You will have to do the same for the other definitions.

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