how to make search look for the Item Name

hi,

can anyone help me in telling me how to modify the search function
so that it looks for the Item Name / product name instead in the description of the product ??

been looking on this site but can't seem to find the answer

thx

patrik

The search already searches the products_name field ...

Have you an URL to your site where you are having this problem and examples of what you cannot find?

hi

if u go to http://www.gezelschapsspelen.be/

and do a search for Runebound

then u see that for dutch it finds 8 games but only 7 for english and for french 6
happends to be the games only with the word runabound in the description

for example a search in english for the product "alles of niets" will not locate this product

http://www.gezelschapsspelen.be/alles-of-niets-p-105.html?language=en

however the name is "alles of niets"

thx
patrik

i quickly uploaded a clean zen-cart
on my own server and added a product "Runabound" with no description

if u do a search for Runebound search results are empty

http://trikke.homelinux.net/shop/

greetz
patrik

Go to your phpMyAdmin and do a query on your products_description table ...

SELECT * FROM products_description WHERE language_id = 1 AND products_name  LIKE '%Runabound%';

SELECT * FROM products_description WHERE language_id = 2 AND products_name  LIKE '%Runabound%';

SELECT * FROM products_description WHERE language_id = 3 AND products_name  LIKE '%Runabound%';

This assumes your language_id are 1, 2 and 3 ...

What we are looking for is that you actually have these products with matching products_description records ...

NOTE: I cannot break this in v1.3.6 or v1.3.7 or v1.3.7.1 using Runebound for the Product name ...

Showing rows 0 - 27 (28 total, Query took 0.0066 sec)
SQL query: SELECT *
FROM zen_products_description
WHERE language_id =4
AND products_name LIKE '%Runebound%'
LIMIT 0 , 30;

this is working for my language files 2,3 & 4

so the table is ok on https://www.gezelschapsspelen.be

i have the same results on my new clean install on my home server

hi,

anyone an idea what the problem can be ?

the problem is still there and it is a clean install on
http://trikke.homelinux.net/shop/

so its not a modification

db is in utf 8

hi

i found the problem

when i create a db with DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

the search function fucks up

when using latin1_swedish_ci it works perfect

problem is when using latin1_swedish_ci french characters like à dont work anymore

anyone an idea how to fix this ?

ok problem solved

i created a new db on my server with clean structure
and did an import of the data in utf8_general_ci

now the search function works fine :clap:

i dont think this is normal behaviour for a search function

better have some developer looking into it :shocking:

Glad you got your problem sorted out.

trikke:

the search function ########## upIn the future, please refrain from using profanities on this forum.
Your post has been censored.