Post by Cleo » Sun Mar 10, 2013 2:04 am

Hello

I have noticed that for all the new product I added lately the tags are not showing, only the tags for the product I had before the update to 1.5.4.1 are showing. So as usual instead of posting in the forum and ask for help I searched for my problem and found this:

Code: Select all

[TAGS] 1.5.x to 1.5.4 Product Tag Conversion Script - FI
on this thread:http://forum.opencart.com/viewtopic.php?f=19&t=82463


So I read the whole thread before doing anything and because it seems to be what I needed I ran that script, got the message tags converted so I went to check some products in the store and..... tags for the new products are still not showing, and the script copied all my French tags over the English ones for the old products! :'(

Now I have around 400 product to go though one by one to fix those tags but that won't make the missing ones showing!!!

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 to show on all the products that I added lately?


tks
Cleo
Last edited by Cleo on Wed Mar 27, 2013 9:09 pm, edited 2 times in total.

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by Cleo » Tue Mar 12, 2013 11:31 am

I requested help in that other thread but it looks like nobody's reading it anymore :(

Anyone know how I can get my tags to show since that script didn't work is there anything else I can do or should change in my product.php file?

tks
Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by Cleo » Sat Mar 16, 2013 9:01 am

If nobody can/want to help at least can someone tell me if the "right" answer is somewhere in the forums and "how" I should search for it?

I tried different search query but was unable to find a real solution probably because I am not using the right expression and maybe there is no solution because my site is bilingual!

tks
Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by Cleo » Wed Mar 27, 2013 11:31 am

Looks like there is no solution for my problem! :(

Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by butte » Wed Mar 27, 2013 1:01 pm

It may be simplest to use OC's admin panel (Settings / Backup [/] Restore) to download a fresh database backup, make a safety copy, edit and then likewise Restore the database. There are several ways to edit it. One is to rename a copy of the file .csv, pull it up as a spreadsheet, edit the columns (fields) for the changes you need, export as .csv, rename as .sql, and use that. You can also use a pure text editor or something like Oracle's Workbench. Those three means will differ in how much you can "zoom" to see how much text per grid cell (grid box) or per line at once.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Cleo » Wed Mar 27, 2013 1:17 pm

@butte

Thank you very much for your reply, I really appreciate!

Apparently I have a few more issue with my database because I can't create a new user either and probably others that I am not aware yet :(

It looks like the person I paid to do the upgrade didn't do it the right way or not completely I don't know!

I'm not even sure which version I have!

I had 1.5.2.2 before the upgrade and now it is showing 1.5.3.1 in my index.php file, 1.5.4 in my admin/index file and when he did the upgrade he said I was having "his" 1.5.4.1 version!!!!

I also have problem with my Grid view (posted in another thread) and I am unable to add any new rewrite rule in my .htaccess

I tried to contact him many times but he doesn't answer anymore so I'm on my own.

See I am not a programmer, know nothing about coding etc. but I'm trying really hard to fix all those problem by reading the forums, I think I have already read as far as 2008 now :(

If I could find someone (cheap) to fix all those problem for me I would be in heaven!

Ok I will try to understand what you wrote/explain and see if I can do it! French old blond here!

Thank you very much for your support.

Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by butte » Wed Mar 27, 2013 1:31 pm

I had already looked, http://www.lesbricollesdecleo.com/ is active, http://www.cleosfleamarket.com/ is in Maintenance, so I gather that the latter has the problems and the former may have escaped harm's way. [PM . . .]

[Addendum:] If you first get the backup .sql file and open it in even Notepad or the like just to glance at it, you'll see comma-delimited rows. Those commas when it's renamed to .csv force columns in a spreadsheet. That'll tell you whether you feel overwhelmed.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Cleo » Wed Mar 27, 2013 9:18 pm

I finally been able to fix the problem on my own :)

What I did is:

Open the catalog/controller/product/product.php file from OC v.1.5.4.1 and open the same one from my store/backup and compare them one line at a time.

Around line 355 in my backup file I had:

Code: Select all

$this->data['tags'] = array();
					
			$results = $this->model_catalog_product->getProductTags($this->request->get['product_id']);
			
			foreach ($results as $result) {
				$this->data['tags'][] = array(
					'tag'  => $result['tag'],
					'href' => $this->url->link('product/search', 'filter_tag=' . $result['tag'])
and in the OC file it was:

Code: Select all

$this->data['tags'] = array();
					
			$tags = explode(',', $product_info['tag']);
			
			foreach ($tags as $tag) {
				$this->data['tags'][] = array(
					'tag'  => trim($tag),
					'href' => $this->url->link('product/search', 'filter_tag=' . trim($tag))	
So I replaced the code of MY file with the one from OC and uploaded it to the store and.... MY TAGS ARE SHOWING!!!!

I couldn't believe it because I've been trying to fix this problem for many weeks now!
So I posted my solution in case it could help someone else!

Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by butte » Thu Mar 28, 2013 6:59 am

There's an additional aspect of filter_tag. The other one is search.php,
http://forum.opencart.com/posting.php?m ... 61&t=98421

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by butte » Thu Mar 28, 2013 7:03 am

That seems to leave new users (who can be manually added to the database itself if need be), rewrite rules, and the already threaded grid view [which now, a few hours later, is also cured] . . .

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Cleo » Thu Mar 28, 2013 10:41 am

@butte

Yes tags are fix!
Search on tags is working ok too, I tried a few and they are working perfectly!
Grids view fixed! And base on what that member told me I then was also able to move the description lower from the title
Rewrite rules (.htaccess) for the new module I bought fixed! This one fixed itself after I fixed the tags problem!
New user fixed!(kind of)

So Life is good! :)

Regards
Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by kurta » Tue Apr 02, 2013 12:36 am

Congratulations!
I've solved a big problem.
Thank you :dance:
Cleo wrote:I finally been able to fix the problem on my own.....

New member

Posts

Joined
Wed Oct 31, 2012 7:30 pm
Location - Italy

Post by Cleo » Tue Apr 02, 2013 12:51 am

You mean you had the same problem and you've been able to fix them too?

Cleo

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


User avatar
Active Member

Posts

Joined
Wed Mar 09, 2011 5:19 am

Post by reginamor » Tue Apr 02, 2013 6:25 am

i have a problem whit the tags, and i look the file that you said, but it's ok.

My problem is that i have no results on the search of tags, when i have many products with that tag =(

User avatar
Active Member

Posts

Joined
Wed Sep 21, 2011 4:44 am
Location - GB
Who is online

Users browsing this forum: Google [Bot], Semrush [Bot] and 34 guests