Home
Welcome, Guest
Please Login or Register.    Lost Password?
Please take a couple of minutes to search previous discussions and documentation for solutions before starting new threads.

not searching if only 2 characters
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: not searching if only 2 characters
#28164
not searching if only 2 characters 4 Months, 3 Weeks ago Karma: 0
Hi,
I have seen it on this forum somewhere but can't find it ...
I am looking for the fix to tweek the hwdvideo search to be able to search numbers like e.g. 50
cheers
richiebee
Gold Boarder
Posts: 216
graphgraph
User Offline Click here to see the profile of this user
Gender: Male
The administrator has disabled public write access.
 
#28183
Re:not searching if only 2 characters 4 Months, 3 Weeks ago Karma: 189
Davros
Administrator
Posts: 13078
graph
User Online Now Click here to see the profile of this user
If you like hwdVideoShare please consider rating it in the Joomla Extensions Directory
The administrator has disabled public write access.
 
#28252
Re:not searching if only 2 characters 4 Months, 3 Weeks ago Karma: 0
Thanks for that Davros,

however on Linux
I looked at my.cnf for ft_min_word_len = 3
it is not there...
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
richiebee
Gold Boarder
Posts: 216
graphgraph
User Offline Click here to see the profile of this user
Gender: Male
The administrator has disabled public write access.
 
#28305
Re:not searching if only 2 characters 4 Months, 3 Weeks ago Karma: 63
It's ok that it's not the my.cnf file, just add the ft_min_word_len in the [mysql] section.

After restarting MySQL you'll need to rebuild the FULLTEXT indexes (I think that an optimize of the tables is enough, but check the MySQL documentation about it).
marpada
Admin
Posts: 2039
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male
The administrator has disabled public write access.
 
#28507
Re:not searching if only 2 characters 4 Months, 2 Weeks ago Karma: 0
Hi marpada,

do I need to add the jos_ as all my other tables have that?
e.g. jos_ft_min_word_len

cheers
richiebee
Gold Boarder
Posts: 216
graphgraph
User Offline Click here to see the profile of this user
Gender: Male
The administrator has disabled public write access.
 
Go to topPage: 12
get the latest posts directly to your desktop

Copyright © 2007-2010 Highwood Design | Your Details | Terms of Use | About