OpenCart Community

Hello

I noticed lately that for all the new product I am adding the tags are not showing.

So I ran this script, got the message tags converted and..... tags for new products still not showing, but it copied all my French tags over the English ones!!!!!!!!!!

Around 400 product to go though one more time to fix those but that won't make the missing ones appear!!!

So I believe that it's not a good idea to run the script on a bilingual site!!!!

Anything else I should do to get the tags show?

tks
Cleo

Just used this on a client's site after upgrading, awesome work thanks!


Just one quick tidbit. She was using multi-language and I found the script wasn't adding the tags to the correct language. I change this line: To this: and it worked perfectly.



Cheers,
Joel.

Thank you for this, worked fine!

OpenCart Addons wrote:Just used this on a client's site after upgrading, awesome work thanks!


Just one quick tidbit. She was using multi-language and I found the script wasn't adding the tags to the correct language. I change this line:

Code: Select all

$db->query("UPDATE " . DB_PREFIX . "product_description SET tag = '" . $db->escape(strtolower($row['xtags'])) . "' WHERE product_id = '" . (int)$row['product_id'] . "'");

To this:

Code: Select all

$db->query("UPDATE " . DB_PREFIX . "product_description SET tag = '" . $db->escape(strtolower($row['xtags'])) . "' WHERE product_id = '" . (int)$row['product_id'] . "' AND language_id = '" . (int)$result['language_id'] . "'");

and it worked perfectly.



Cheers,
Joel.

Thanks for the update.... Yea I don't often think in multilingual terms.

Extremely useful script - thank you.

Qphoria Thank you for this fix!

Verry good script. Thank you!

Thank you.
1.5.1.3 to 1.6
perfect

Works great! Thanks. Good work! I bad English, sorry!

Just wondering if anyone knows if I need to run this from and update from 1.5.2.2 to 1.5.6.4 or has it been incorporated now? My tag fields seem to be blank on all products, but from the sounds of it, Q was going to include it in the upgrade script??

I can't see it in the 1.5.6.4 code, so it looks like it's still needed. Remember to backup your database first.

labeshops wrote:Just wondering if anyone knows if I need to run this from and update from 1.5.2.2 to 1.5.6.4 or has it been incorporated now? My tag fields seem to be blank on all products, but from the sounds of it, Q was going to include it in the upgrade script??

It will never be part of the upgrade system. You will need it whenever coming from a 15x version prior to 1.5.4, regardless of what version you eventually use.

I have 1.5.2.1 It doesn't work. There is white page If I write http://www.verdtoneshop.com/tags-v154v2.php on browser. How can I do it ?

Hello admin i have pm you so pplease check and add me on skype i need upgrade services