This topic contains a post which is marked as Best Answer. Press here if you would like to see it.
*

BabyDunk

  • ****
  • 161 posts
**Backoffice Manager** added search function
« on: August 19, 2016, 12:26:03 PM »
Hello Frosticek

i dont even know if this thought is possible but no harm in asking,

you know the way to include shorter words in the Full-Text Search is to do followhttps://doc.osclass.org/Fine-Tuning_MySQL_Full-Text_Search_-_Improving_search

but this will also index all words like "and, the, is, me, we and so on"

is their a way to add your own list to this index without having to index all these words that have no relevance to the actual search term?

i would like to have the likes of "tv, s6, s5, 5c, 6s, car and so on"  but to get this with the general way of indexing all words with 2 characters seems abit harsh.

i dont know if this is possible but if it were it could be an nice added feature to backoffice manager or even a new plugin altogether :D


Cheers
Chris
« Last Edit: August 19, 2016, 11:14:17 PM by BabyDunk »
I Am A Noob But I Am Here To Learn.
Please be patient ;) ;D

*

MB Themes

Re: **Backoffice Manager** added search function
« Reply #1 on: August 19, 2016, 08:07:37 PM »
@BabyDunk
Plugin use latest searches table of osclass, it is not possible to go through all the listings.
3 letters are minimum as it might get slow...
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

BabyDunk

  • ****
  • 161 posts
Re: **Backoffice Manager** added search function
« Reply #2 on: August 19, 2016, 09:27:30 PM »
no problem :) the only way to get these search terms is to change the minimum index then .

i hope to upgrade to a server with ssd. which from what i see by reading reviews, it makes mysql reads alot faster. its just a pitty all unimportant words need to be indexed   :-\


« Last Edit: August 19, 2016, 11:15:16 PM by BabyDunk »
I Am A Noob But I Am Here To Learn.
Please be patient ;) ;D

*

MB Themes

Re: **Backoffice Manager** added search function
« Reply #3 on: August 20, 2016, 03:46:03 PM »
@BabyDunk
I am not sure but my server allows me to search by 1 letter as well.

http://zara.mb-themes.com/search/pattern,E
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

BabyDunk

  • ****
  • 161 posts
Re: **Backoffice Manager** added search function
« Reply #4 on: August 21, 2016, 09:42:49 PM »
so i take it that means your server indexes every single letter? :-/ or do you have a special hack you're not sharing lol i am on patricia and i see your patricia demo searches is the same :) Excellent, i need to get it

are you on a dedicated server?? and do you manage you're own ?

i have a dedicated server and self-managed. was the only way to afford a machine with decent power and root access :D
« Last Edit: August 21, 2016, 09:50:15 PM by BabyDunk »
I Am A Noob But I Am Here To Learn.
Please be patient ;) ;D

*

MB Themes

Re: **Backoffice Manager** added search function
« Reply #5 on: August 22, 2016, 08:55:21 AM »
@BabyDunk
I did not do any change on database, running on normal hosting for 30$ per year.
It might be limitation of your MySQL configuration.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

BabyDunk

  • ****
  • 161 posts
Re: **Backoffice Manager** added search function
« Reply #6 on: August 22, 2016, 12:55:49 PM »
i changed the limits last night :D i now have search terms for 2 characters :D
I Am A Noob But I Am Here To Learn.
Please be patient ;) ;D

*

MB Themes

Re: **Backoffice Manager** added search function
« Reply #7 on: August 22, 2016, 01:20:05 PM »
@BabyDunk
Can you give here for other people how you did it?
Someone might get it useful ;)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

Marked as best answer by frosticek on August 22, 2016, 03:59:21 PM
*

BabyDunk

  • ****
  • 161 posts
Re: **Backoffice Manager** added search function
« Reply #8 on: August 22, 2016, 02:56:31 PM »
@frosticek no probs

to start you must have access to /etc/mysql/my.cnf via ssh

edit my.cnf
Code: [Select]
nano /etc/mysql/my.cnf
add this line under [mysqld] place the minimum value you would like to index, i chose 2 characters
Code: [Select]
ft_min_word_len = 2

now key ctrl and x will give you option to save and y to overwrite then enter

then restart mysql for settings to take effect
Code: [Select]
service mysql restart
now to re-index

login to mysql
Code: [Select]
mysql -u yourusername -p input your password

find your database name
Code: [Select]
mysql>show databases;
select your database
Code: [Select]
mysql>use yourdatabasename;
find your table name (most likely oc_t_item_description)
Code: [Select]
mysql>show tables;
now if your table is oc_t_item_description if not then change your prefix for this next part

Code: [Select]
mysql>REPAIR TABLE oc_t_item_description QUICK
now to login out of mysql
Code: [Select]
mysql> quit
now refresh your site and do a search :D

Big thanks to byteGator for posting this on osclass forum.
« Last Edit: August 22, 2016, 04:54:42 PM by BabyDunk »
I Am A Noob But I Am Here To Learn.
Please be patient ;) ;D