Return to previous page

Ajax search ar not working related to key words.

This topic has 7 replies, 4 voices, and was last updated 4 months ago ago by Andrew Mitchell

Martin

Participant

September 5, 2024 at 05:41

Error in the log file

[05-Sep-2024 04:22:46 UTC] WordPress database error Table ‘*****.wp_et_ajax_search_stats’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_et_ajax_search_stats made by do_action(‘wp_ajax_nopriv_etheme_ajax_search’), WP_Hook->do_action, WP_Hook->apply_filters, ETC\App\Models\Search\Engines\Ajax_Search->search_results, do_action(‘etheme_ajax_search_stats/analytics/after_searching’), WP_Hook->do_action, WP_Hook->apply_filters, ETC\App\Models\Search\Analytics\Recorder->listener, ETC\App\Models\Search\Analytics\Recorder->push

Files is visible for topic creator and
support staff only.

#413086 Copied Theme version: 9.4.1

6 Answers

Jack Richardson

Support staff

September 5, 2024 at 09:52

Hello @Martin
Could you please, direct us where did you see that errors as currently we don’t see any. Also, could you please, answer us if you made any other modifications on your web-site? Did the search work correctly before the update ? Did you make any optimization of your database previously ?
Kind regards, Jack Richardson

#413121 Copied

Martin

Participant

September 5, 2024 at 20:43

this is in the debug logs from WordPress when I tray to search a item.

the search is spinning and nothing happen but this line is comming in the debug log file.

after i got the error I run DB optimisation that is givving the same outcome. I don’t know where is coming from.

#413208 Copied

Jack Richardson

Support staff

September 6, 2024 at 08:25

Hello @Martin

We have found the reason of the issue and successfully fixed it on your web-site. This fix will be included in next theme update, so you should not worry about loosing the changes after the update.

Could you please, check if the issue was fixed on your side ?

Kind regards, Jack Richardson

#413244 Copied

Martin

Participant

September 6, 2024 at 14:07

What was the issues for my understanding ?

#413338 Copied

Rose Tyler

Support staff

September 6, 2024 at 15:58

Hello @Martin

We would like to inform you that we have addressed a recent issue concerning the search analytics that was previously discussed. It was discovered that search results were being recorded in the database even when analytics were not enabled, which led to the discrepancies mentioned.
We have now implemented a fix in the files to ensure that search results are only recorded in the database when analytics are enabled. If analytics are disabled (which is the default setting), the system will revert to its previous behavior. This resolves the error that occurred when there was an attempt to record data in a non-existent database, which some clients experienced. The issue was temporarily fixed by toggling the analytics option on and off, but we have now permanently resolved it.
Thank you for your attention to this matter. Please do not hesitate to reach out if you have any further questions or require additional information.

Warm Regards,
The 8Theme Team

#413361 Copied

Andrew Mitchell

Support staff

October 25, 2024 at 02:26

Dear Martin,

We hope you’re reveling in the experience our theme brings! Your enthusiasm is what fuels our passion. Would you be so kind as to channel that energy into a 5-star rating on ThemeForest? Your feedback is the spark that lights our way!

Click here to spread the love: https://themeforest.net/downloads

Thank you for being an integral part of our journey!

Best Regards,
The 8Theme Team

#420369 Copied
Tagged: ajax search issue, keyword search failure, troubleshooting ajax in woocommerce, woocommerce ajax fix, woocommerce themes, wordpress ajax problem, wordpress search solutions
Viewing 7 results - 1 through 7 (of 7 total)

The issue related to '‘ajax search ar not working related to key words.’' has been successfully resolved, and the topic is now closed for further responses

Ajax search ar not working related to key words.

Recent Topics

Helpful Topics

Useful links WooCommerce & WordPress

Browse by popular tags:

Explore our best WordPress WooCommerce Themes collection