Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 - Table 'pruebaoscom.TABLE_PRODUCTS_TAGS'


Recommended Posts

When active tags mysql box displays this error
 

1146 - Table 'pruebaoscom.TABLE_PRODUCTS_TAGS' doesn't exist

select p.tag_id, t.tag_text, count(*) from TABLE_PRODUCTS_TAGS p, TABLE_TAGS t where p.tag_id = t.tag_id group by p.tag_id order by count(*) desc limit 15

I searched the table on fresh oscommerce bd botstrap gold and can not find it ...

tanks

No external links here, thank you

Link to comment
Share on other sites

Add the following to the the includes/database_tables.php file (on the shop and or admin side, as needed).

define('TABLE_PRODUCTS_TAGS', 'products_tags');

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hi, thx for your help, now apache log show this

mod_fcgid: stderr: PHP Fatal error: Call to undefined function tep_cfg_select_pages() in /var/www/vhosts/nukua.es/prueba.nukua.es/admin/modules.php(244) : eval()'d code on line 1, referer: http://prueba.nukua.es/admin/modules.php?set=boxes&module=bm_tag

And mysql this:

1146 - Table 'pruebaoscom.TABLE_TAGS' doesn't exist

select p.tag_id, t.tag_text, count(*) from products_tags p, TABLE_TAGS t where p.tag_id = t.tag_id group by p.tag_id order by count(*) desc limit 15

No external links here, thank you

Link to comment
Share on other sites

You can make another entry like before but remove the products_. But this is happening because something isn't installed correctly so you should find the cause of it. If you installed an addon prior to this happening, then that is probably the cause.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

It works, tanks so much!!!! but banner box not :blush:

Apache log show:

mod_fcgid: stderr: PHP Fatal error: Call to undefined function tep_build_banners_group() in /var/www/vhosts/nukua.es/prueba.nukua.es/includes/modules/boxes/bm_banner_box.php on line 36, referer: http://prueba.nukua.es/admin/modules.php?set=boxes&module=bm_tag

 

When ennable banner box the web page its blank and not view mysql error.

No external links here, thank you

Link to comment
Share on other sites

hi, i know de addon name, they have 2 files: bm_banner_box.php and bm_banner_content.php, i dont make any change on the banner's box.

Regards

No external links here, thank you

Link to comment
Share on other sites

You should post questions relating to an addon in that addons support thread since that is where the people that use it are more likely to see your problem.

 

With that said, be sure you download a full version of the addon. Some people only upload partial updates and it causes problems like this.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...