Lioelx Posted August 25, 2016 Share Posted August 25, 2016 When active tags mysql box displays this error 1146 - Table 'pruebaoscom.TABLE_PRODUCTS_TAGS' doesn't existselect 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 More sharing options...
Jack_mcs Posted August 25, 2016 Share Posted August 25, 2016 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 More sharing options...
Lioelx Posted August 25, 2016 Author Share Posted August 25, 2016 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 existselect 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 More sharing options...
Jack_mcs Posted August 25, 2016 Share Posted August 25, 2016 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 More sharing options...
Lioelx Posted August 25, 2016 Author Share Posted August 25, 2016 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 More sharing options...
Jack_mcs Posted August 25, 2016 Share Posted August 25, 2016 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. 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 More sharing options...
Lioelx Posted August 25, 2016 Author Share Posted August 25, 2016 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 More sharing options...
Jack_mcs Posted August 26, 2016 Share Posted August 26, 2016 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 More sharing options...
Lioelx Posted August 26, 2016 Author Share Posted August 26, 2016 thank you, inquire of the addons section. No external links here, thank you Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.