Jump to content
JcMagpie

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


 

Share this post


Link to post
Share on other sites

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]

Share this post


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

Share this post


Link to post
Share on other sites
5 hours ago, Hotclutch said:

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

This is mine datebase.php

database.php

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


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

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

×