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
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
Opencart v1.5.4.1 fr/en
Theme: Custom
vqmod-2.6.0
PHP: 7.3 (ea-php73)
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.
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'] . "'");
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'] . "'");
Cheers,
Joel.
Thanks for the update.... Yea I don't often think in multilingual terms.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: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 it worked perfectly.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'] . "'");
Cheers,
Joel.
Extremely useful script - thank you.
inframes.com Website Design with Opencart, Wordpress, Lucee and bespoke application design and development
Verry good script. Thank you!
http://www.winaliteserbia.com My OC Shop's http://www.mobilnimarket.com http://www.novimobilnitelefoni.com
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??
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
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.
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.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??
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 ?
Who is online
Users browsing this forum: No registered users and 137 guests