Return to previous page

Ajax search ar not working related to key words.

This topic has 6 replies, 3 voices, and was last updated 2 weeks ago ago by Rose Tyler

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

5 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
Tagged: ajax search issue, keyword search failure, troubleshooting ajax in woocommerce, woocommerce ajax fix, woocommerce themes, wordpress ajax problem, wordpress search solutions
Viewing 6 results - 1 through 6 (of 6 total)