I'm now using 1.5.6.4
in 1.5.2 It didn't seem to matter if the product titles or descriptions were in upper or lowercase, but now if i search for "product name" and the actual product name is "PRODUCT NAME" opencart will return no results.
Is there anyway of ignoring the case?
As an update, this was caused by importing data from an earlier version of OC. Post v1.5 uses utf8_ci.
Updating the collation in my database resolved the issue.
Updating the collation in my database resolved the issue.
I had the same issue when i upgraded recently from 1.5.4.1 to 1.5.6.4. Changing the collation of database to utf8_general_ci wasn't sufficient. I've had to change the collation of 'model' field of 'product' table and description,meta_description,meta_keyword,tag fields of 'product_description' table. Both utf8_general_ci.
Everything works perfect now.
Hope this will helps .
Everything works perfect now.
Hope this will helps .
this is rather frustrating. I also have 1.5.6.4 -- Spent 10 minutes with a customer who was looking at a product page "ProEcza" and I couldn't find it because i typed "Proecza" or "proecza".
Anyway i tried to change product_description.name to utf8_general_ci - no change in the results.
Any thoughts? It seems to be working for the p.model which doesn't care about the case.
Do i need to restart mysql? thanks ex
Anyway i tried to change product_description.name to utf8_general_ci - no change in the results.
Any thoughts? It seems to be working for the p.model which doesn't care about the case.
Do i need to restart mysql? thanks ex
UPDATE! apparently the change did not take root due to Error 1283 "Column 'description' cannot be part of FULLTEXT index". I had to change both name and description field to utf8_general_ci and now the search is no longer case sensitive.
I am guessing that this failed during the upgrade from an earlier version and I did not notice any errors.
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
I am guessing that this failed during the upgrade from an earlier version and I did not notice any errors.
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
Who is online
Users browsing this forum: Amazon [Bot] and 84 guests