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
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.
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.
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.
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.
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.
I changed it to what you suggest but it is still the same.
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.
Remember to backup your database before making any changes.
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 (63.51 KiB) Viewed 2016 times
oc_product_description is the important on for search. All those tables should be utf8_general_ci.
I have updated the collation as mentioned but it still doesn't work. I have attached 2 screen shots.
Attachments
Product Keeword 3.jpg (41.77 KiB) Viewed 1970 times
Product Keeword 2.jpg (53.48 KiB) Viewed 1970 times
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
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
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
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
Who is online
Users browsing this forum: No registered users and 43 guests