Hi @harald-b
I sent a private message for you.
Please check.
Let me know if you still have any issues. Thanks!
Hi @harald-b
I sent a private message for you.
Please check.
Let me know if you still have any issues. Thanks!
Hi @Graham
Thanks for your question. Let me ask you one more clarifying question before I can offer a solution.
You plan to use the widget for general site-wide search, right? If so, and in this case, if the information is found in one of these files that are listed in your example, then what exactly should be displayed on the search results page? And in this case, where should the user go when he clicks on the title of the search results element?
@guarani23 Can you send me access to your website to the private messages? I can make a code, it's really simple.
Hi @guarani23
So, you want these buttons to be an alternative way to enter respective letters into the search string, right?
For example, if I want to enter the word “NIÑO”, but I have no such letters on the keyboard, I can enter “NI” and then press the “Ñ” button above and it appears in the search box. Is it correct?
In this case you could add a very simple javascript to the page that will catch button clicks and copy letters to the input text.
Do you need me to help you with this js code?
Thanks.
Hi @e-bouf
Definitely something goes wrong. I feel like this is a conflict between 3rd party search-related plugin and WPFTS. Sometimes this happens. Could you please check if you have some other search-related plugins enabled and try to disable them temporarily?
If it does not help I would like to ask you if we can contact with Anydesk to let me check your WP admin to solve this problem or you can send me wp admin access to private message please?
Thanks!
Hi @e-bouf
It looks like there is a conflict with the theme settings or 3rd-party plugin. Which theme you are using? I think the theme uses it's own search-related code to order search results and create excerpts.
I have tried different words and may be I found one that displays not only files, check please https://www.franceparkinson.fr/?s=parkinson
Also could you try Sandbox search, does it search for titles/posts?
Thanks!
Hi @e-bouf
It's pretty strange. Do you have your website online so I can make some checks please? You can answer me in private messages here in case you don't want to share website URL.
Thanks!
The main problem is that WPFTS basically works with database entries in the wp_posts table, not with physical files. The files are the source of the search text only at the time of the indexing procedure, and thereafter the index only references the rows in the database table. It works this way because WPFTS is essentially an extension of the standard WordPress function, WP_Query, which searches wp_posts records.
What I might suggest in your case?
Since Simple File List Pro does not save information to WP Media Library, we need another plugin that will populate wp_posts with information about each file. In this case, with a small addon, the WPFTS plugin can index each file and display it in the search results (every file).
Another option is to index files that are embedded in the page using the [eeFSL] shotcode. But in this case it will be impossible to highlight a single file in the search results - instead a link to the page itself, where the list of files is embedded, will be displayed.
I need to understand exactly what you need in order to give further instructions or advice. Please let me know.
Hi @e-bouf
Some additional tests needs to be done. There are some reason why search does not search "page" or "post" posts. For example there is a conflict with 3rd party plugin or theme.
Could you try to disable all plugins that can make search and try again?
Also please try to make the same search in the WPFTS Settings / Search & Output / Sandbox, page 2.
Let me know what happen, thanks!
@Qville I have tried with the Pen theme, tried to activate and deactivate WPFTS Pro on my dev machine, but unfortunately I can not repeat the issue that you faced with. The posts on the main page are always ordered by "Publication Date (descending order)" does not matter whether WPFTS active or not.
Could you please try once more to activate WPFTS and deactivate it on your website and see if there any differences? Could you make a screenshot or give me a link to your website?
Hi @Qville
Actually, WPFTS plugin should only affect post order on search results. And it's okay, you can change the search results post order in the WPFTS settings.
In case you meant post order on the main page / blog page (not search) please let me know if you need it to be "revision date" or "publication date" and where you can set it?
Also I would ask you to copy of the paid theme you're using (you can put it to the private message or to info@fulltextsearch.org) please.
Thanks!
Hi @cantuaria
I found a bug in the new version and I made an update of the plugin to 1.59.211. Please update it.
This should guarantee the _tp table to be empty (actually it's a temporary table that ONLY used for search queries and did not used for CRON jobs or indexing).
After this update the plugin will not give an additional load for the server.
Thanks. Please let me know if it works fine or not now.
Hi @ALG1970
Yes, it was another bug.
I've just updated the plugin to version 1.59.211 that should fix the issue.
The "_tp" table should not grow anymore.
Also this should not make any additional load to the server.
Please update WPFTS and give it another chance.
Thank you, let me know if this goes fine now.
Hi, @cantuaria
Thank you for this report. We have added "ts < <date>" part in the last plugin update and that is good that you found this issue and reported!
Could you please tell me some more information before we develop a fix for this?
This table should be normally empty and should contain only some rows related to the latest search.
After doing points 1-3 could you also truncate this table (in case there are a lot of records) and tell me if this fixed the performance issue?
After truncating, do this table grows constantly with each new search query request?
Thank you for this report and your help!
Hello, @ALG1970
Thank you for your question! It seems you found a bug in the plugin!
The "tp" table is actually a temporary table for document IDs, used only for searching and not used when building the index. Normally this table should not grow, on the contrary, its normal size is 0 records.
This made me think that there might be an error in the code and this table is not cleared in a timely manner. Indeed, the error was found and corrected. I've poured the new version into the Wordpress repository, so I recommend updating now (version 1.59.209).
https://wordpress.org/plugins/fulltext-search/
Immediately after installation, do any search query and the "tp" table should be automatically cleaned up (due to its size, this process may take a long time).
As for the table "vectors", together with the tables "words", "docs" and "index", it represents the search index. All your documents are encoded in these tables in the form of numbers and ratios, and the structure of the tables is such that it allows you to find documents with the specified words in milliseconds, even if the size of the tables is tens of gigabytes. This is the point of indexed search.
So the answer is no. You can't shrink the "vectors" table.
If you are concerned about the database size, I can offer you to disable index optimisation (there is such an option on the main page of the plugin settings).
The index optimiser essentially creates a compressed version of the main index and stores it in the "vc" table, which can also take up a large size.
If you turn off optimisation, the "vc" table will be cleaned up (or you can clean it up manually with the "truncate table wpftsi_vc" query.
Hope this helps.
Please let me know if new WPFTS version solved you problem.
Thank you!
Hi @cantuaria
Please tell me which version of the plugin do you use? Could you tell me if you have activated Deeper Search option and do you use an Index Optimizer (latest option on the Main Page).
Thanks!
@CarloPerni Hi, I have sent you the pre-release version of the WPFTS. According to front-end issues: could you tell me please, which theme you are currently using? It does matter.
Also please check if you have any other search-related plugin(s) enabled and try to temporary disable them. It should help.
Thanks!
@Rainer Hi, I answered you in the private message. Thanks!
@kotatsuhal Thank you. I am checking the problem right now. Very interesting case!