Post by cdamianou » Tue Jun 02, 2020 4:54 pm

Hi

At the moment when I do a search you can only search using the exact format of the word. For example, if the product in the store is called [Dice] the search will only bring a result if you search for [Dice] with a capital letter at the beginning and not [dice].

I have tried looking with no success. does anyone know of a module etc that can allow the store to do this? I am using OC 2.3.0.2

Thanks in advance
Last edited by cdamianou on Wed Jun 03, 2020 3:17 am, edited 1 time in total.

http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by ADD Creative » Tue Jun 02, 2020 7:55 pm

It should work. It could be an extension or even your theme that is causing the problem. Also check your database tables are using a case insensitive collation such as utf8_general_ci.

www.add-creative.co.uk


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by cdamianou » Tue Jun 02, 2020 8:56 pm

I have a multi store setup both using different themes and it is the same for both themes which is making me believe that it isn't the theme.

Where do I look in PHPmyadmin to check the Collation? Sorry, I can manuvure around phpmyadmin but not knowledgeable enough to know where that is.

http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by cdamianou » Tue Jun 02, 2020 9:01 pm

Doh, its the first page when you log in. It is currently set as utf8mb4_unicode_ci

I changed it to what you suggest but it is still the same.

http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by ADD Creative » Tue Jun 02, 2020 9:24 pm

utf8mb4_unicode_ci would be OK as the _ci indicates it's case insensitive. However, you need to check all the individual tables. The one on the front page in just for the connection. You need to select Databases from the top menu, then click on the database for your OpenCart installation. You should then get a list of tables. Look for the Collation column. utf8_general_ci is the default for OpenCart, but any ending in _ci should work. If you need to change it, look in Operations in the top menu, for either one table of the whole database.

Remember to backup your database before making any changes.

www.add-creative.co.uk


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by cdamianou » Tue Jun 02, 2020 9:39 pm

I had a look. Theys eem to be mostly utf8_general_ci

http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by cdamianou » Tue Jun 02, 2020 9:49 pm

Looked a little deeper. I have attached a screenshot and found some no Case insensitive. I'm wondering what specific line would be related to the Opencart search functionality.

Attachments

Products Case Incensitive.png

Products Case Incensitive.png (63.51 KiB) Viewed 994 times


http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by ADD Creative » Tue Jun 02, 2020 10:25 pm

oc_product_description is the important on for search. All those tables should be utf8_general_ci.

www.add-creative.co.uk


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by cdamianou » Wed Jun 03, 2020 2:45 am

I have updated the collation as mentioned but it still doesn't work. I have attached 2 screen shots.

Attachments

Product Keeword 3.jpg

Product Keeword 3.jpg (41.77 KiB) Viewed 948 times

Product Keeword 2.jpg

Product Keeword 2.jpg (53.48 KiB) Viewed 948 times


http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by cdamianou » Wed Jun 03, 2020 3:16 am

OMG, found the solution. I followed this link

viewtopic.php?t=132329

Its actually the last sentence that fixed the issue.

People test your search if you are not getting results due to case sensitive search the solution is to alter both name and description fields in the product_description table to utf8_general_ci -- good luck! ex

http://www.magictao.co.uk


Active Member

Posts

Joined
Tue Aug 09, 2011 2:13 pm

Post by Caroline_97 » Fri Oct 16, 2020 6:45 pm

follow this link it has solution to your query

viewtopic.php?t=132329

read it till the last sentence ,
try it by searching , if it doesn't work due to case sensitive search the solution should be alter both name and description field in the table myprepaidcenter login

Newbie

Posts

Joined
Tue Oct 13, 2020 2:06 pm
Who is online

Users browsing this forum: No registered users and 4 guests