Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by Cleo » Sat Mar 09, 2013 9:34 pm

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

Opencart v1.5.4.1 fr/en
Theme: Custom
vqmod-2.6.0
PHP: 7.3 (ea-php73)

User avatar
Cleo
Active Member
Posts
793
Joined
Wed Mar 09, 2011 5:19 am
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by OpenCart Addons » Tue May 28, 2013 1:08 am

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.

Canada's Leading Expert In OpenCart Development & Certified OpenCart Development Partner Image

User avatar
OpenCart Addons
Active Member
Posts
605
Joined
Thu Nov 24, 2011 10:51 am
Location - Canada
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by themannn » Fri Jun 07, 2013 7:55 am

Thank you for this, worked fine!
themannn
Newbie
Posts
11
Joined
Sat Sep 10, 2011 5:09 am
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by Qphoria » Mon Jun 10, 2013 10:50 pm

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.

Image

User avatar
Qphoria
Administrator
Posts
20056
Joined
Tue Jul 22, 2008 3:02 am
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by siteadvice » Tue Sep 17, 2013 2:04 am

Extremely useful script - thank you.

inframes.com Website Design with Opencart, Wordpress, Lucee and bespoke application design and development

User avatar
siteadvice
New member
Posts
70
Joined
Mon Oct 24, 2011 8:12 pm
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by ddowdall » Thu Sep 26, 2013 4:14 am

Qphoria Thank you for this fix! ;D
ddowdall
New member
Posts
32
Joined
Tue Dec 07, 2010 2:06 am
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by hoze » Wed Oct 16, 2013 2:43 am

Verry good script. Thank you!

http://www.winaliteserbia.com My OC Shop's http://www.mobilnimarket.com http://www.novimobilnitelefoni.com

hoze
New member
Posts
25
Joined
Sun Aug 28, 2011 11:23 pm
Location - Serbia
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by Vali_REK » Fri Nov 08, 2013 5:06 am

Thank you.
1.5.1.3 to 1.6
perfect
Vali_REK
Newbie
Posts
6
Joined
Fri May 18, 2012 3:50 am
Location - Oltenita
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by SystemTN » Sun Dec 08, 2013 3:13 am

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

Miệng luôn tươi cười, may mắn tự nhiên đến!

SystemTN
Newbie
Posts
1
Joined
Sun Dec 08, 2013 3:09 am
Location - Vietnam
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by labeshops » Fri May 02, 2014 10:31 pm

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.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.

User avatar
labeshops
Expert Member
Posts
4939
Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by ADD Creative » Sun May 04, 2014 11:58 pm

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.

www.add-creative.co.uk

ADD Creative
Guru Member
Posts
5199
Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by Qphoria » Fri May 09, 2014 10:07 pm

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.

Image

User avatar
Qphoria
Administrator
Posts
20056
Joined
Tue Jul 22, 2008 3:02 am
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by mutemancer » Sat Jul 12, 2014 8:22 pm

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 ?
mutemancer
Newbie
Posts
3
Joined
Sat Jul 12, 2014 3:42 pm
Top

Re: [TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI

Quote

Post by whmteam » Sat Apr 11, 2015 10:55 pm

Hello admin i have pm you so pplease check and add me on skype i need upgrade services
whmteam
Newbie
Posts
2
Joined
Fri Apr 10, 2015 7:39 pm
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 21 guests