Jump to content
Latest News: (loading..)
Lioelx

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

Share this post


Link to post
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');

Share this post


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

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

That's not a standard function and I can't guess at what it should be. You'll need to locate the addon or template that added it.

Share this post


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

Share this post


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

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

×