Title: Search functionality has some problems
Last modified: February 22, 2024

---

# Search functionality has some problems

 *  Resolved [edudude](https://wordpress.org/support/users/edudude/)
 * (@edudude)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/)
 * Hi! Sorry to ask your advice again, because I’m not sure if this is a bug or 
   not.
 * The search functionality doesn’t seem to work that well with Google Sheets table.
   First of all it seems to take a long time from pressing the ‘search’ button and
   it actually finding it or not. This may be due to it being a Google Sheets table
   and not locally imported file. This also affects so that real-time search is 
   out of the question unfortunately.
 * The second thing is that it doesn’t seem to search from all the columns in the
   table, only the first column. So when I, for example, search for the ‘2023’ in
   the ‘Vuosi’ (year in Finnish), it doesn’t find anything, even though there are
   rows that contain ‘2023’.
 * Third and more crucial is that the search functionality doesn’t seem to work 
   when not logged in as a site/wordpress admin (e.g. in incognito mode)
 * I don’t have cache add-on installed any more, so it shouldn’t be because of that.
 * Thanks again. Even though I’ve had problems with it, I think it’s a great add-
   on!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsearch-functionality-has-some-problems%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [edudude](https://wordpress.org/support/users/edudude/)
 * (@edudude)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/#post-17446017)
 * Update:
 * I noticed the search function works when using my Iphone SE. It doesn’t however
   work when using my family’s old PC regardless of browser (tried Edge, Chrome,
   Mozilla).
 * Using Mozilla, the dev tools console displayed this error message:
 *     ```wp-block-code
       Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://vselokuvakeskus.fi/wp-admin/admin-ajax.php. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.
   
       failed searchTable wibergsweb188.js:1074:21
   
       Object { readyState: 0, getResponseHeader: getResponseHeader(e), getAllResponseHeaders: getAllResponseHeaders(), setRequestHeader: setRequestHeader(e, t), overrideMimeType: overrideMimeType(e), statusCode: statusCode(e), abort: abort(e), state: state(), always: always(), catch: catch(e), … }
       wibergsweb188.js:1075:21
       ```
   
 * When reloading the page:
 *     ```wp-block-code
       Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://vselokuvakeskus.fi/wp-admin/admin-ajax.php?action=getdefaults. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.
   
       failed getdefaults wibergsweb188.js:21:17
   
       Object { readyState: 0, getResponseHeader: getResponseHeader(e), getAllResponseHeaders: getAllResponseHeaders(), setRequestHeader: setRequestHeader(e, t), overrideMimeType: overrideMimeType(e), statusCode: statusCode(e), abort: abort(e), state: state(), always: always(), catch: catch(e), … }
       wibergsweb188.js:22:17
       ```
   
 * Here’s the whole message when using Edge dev tools:
 *     ```wp-block-code
       jquery-migrate.min.js?ver=3.4.1:2 JQMIGRATE: Migrate is installed, version 3.4.1
       elokuvakerhopalvelu/:1  Access to XMLHttpRequest at 'https://vselokuvakeskus.fi/wp-admin/admin-ajax.php?action=getdefaults' from origin 'https://vselokuvakeskus.net' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
       wibergsweb188.js?ver=6.4.3:21 failed getdefaults
       wibergsweb188.js?ver=6.4.3:22 {readyState: 0, getResponseHeader: ƒ, getAllResponseHeaders: ƒ, setRequestHeader: ƒ, overrideMimeType: ƒ, …}
       jquery.min.js?ver=3.7.1:2 
   
   
               GET https://vselokuvakeskus.fi/wp-admin/admin-ajax.php?action=getdefaults net::ERR_FAILED 200 (OK)
       send @ jquery.min.js?ver=3.7.1:2
       ajax @ jquery.min.js?ver=3.7.1:2
       (anonymous) @ jquery-migrate.min.js?ver=3.4.1:2
       e.<computed> @ jquery-migrate.min.js?ver=3.4.1:2
       (anonymous) @ wibergsweb188.js?ver=6.4.3:9
       e @ jquery.min.js?ver=3.7.1:2
       t @ jquery.min.js?ver=3.7.1:2
       setTimeout (async)
       (anonymous) @ jquery.min.js?ver=3.7.1:2
       c @ jquery.min.js?ver=3.7.1:2
       fireWith @ jquery.min.js?ver=3.7.1:2
       fire @ jquery.min.js?ver=3.7.1:2
       c @ jquery.min.js?ver=3.7.1:2
       fireWith @ jquery.min.js?ver=3.7.1:2
       ready @ jquery.min.js?ver=3.7.1:2
       P @ jquery.min.js?ver=3.7.1:2
       elokuvakerhopalvelu/:1  Access to XMLHttpRequest at 'https://vselokuvakeskus.fi/wp-admin/admin-ajax.php' from origin 'https://vselokuvakeskus.net' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
       wibergsweb188.js?ver=6.4.3:1074 failed searchTable
       wibergsweb188.js?ver=6.4.3:1075 {readyState: 0, getResponseHeader: ƒ, getAllResponseHeaders: ƒ, setRequestHeader: ƒ, overrideMimeType: ƒ, …}
       jquery.min.js?ver=3.7.1:2 
   
   
               POST https://vselokuvakeskus.fi/wp-admin/admin-ajax.php net::ERR_FAILED 200 (OK)
       send @ jquery.min.js?ver=3.7.1:2
       ajax @ jquery.min.js?ver=3.7.1:2
       (anonymous) @ jquery-migrate.min.js?ver=3.4.1:2
       e.<computed> @ jquery-migrate.min.js?ver=3.4.1:2
       searchTable @ wibergsweb188.js?ver=6.4.3:1014
       (anonymous) @ wibergsweb188.js?ver=6.4.3:843
       dispatch @ jquery.min.js?ver=3.7.1:2
       v.handle @ jquery.min.js?ver=3.7.1:2
       ```
   
    -  This reply was modified 2 years, 3 months ago by [edudude](https://wordpress.org/support/users/edudude/).
 *  Plugin Author [wibergsweb](https://wordpress.org/support/users/wibergsweb/)
 * (@wibergsweb)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/#post-17449635)
 * Hi there!
   The main issue is that your server is not allowing requests from other
   domains. This is a “security”-feature that means not anyone should be able to
   access your data just by sending a “fetch my data command” (from javascript which
   is used to fetch data without reloading page). This feature/rule is called “Cross-
   Origin Requests (also known as CORS).You have status 200 which means you can 
   reach the domain/site but Cross-Origin-Requests Blocked means you’re not allowed
   to fetch data from an external source:**_Cross-Origin Request Blocked: _**The
   Same Origin Policy disallows reading the remote resource at [https://vselokuvakeskus.fi/wp-admin/admin-ajax.php](https://vselokuvakeskus.fi/wp-admin/admin-ajax.php).(
   Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.
   It’s possible to open this, but this has to be done on the server where your 
   page is hosted, so it’s your hosting company you need to talk to.Because you 
   get above error, you get an error in searching. If you fix this in collaboration
   with your host, the search-functionality will hopefully work as expected.
    -  This reply was modified 2 years, 3 months ago by [wibergsweb](https://wordpress.org/support/users/wibergsweb/).
    -  This reply was modified 2 years, 3 months ago by [wibergsweb](https://wordpress.org/support/users/wibergsweb/).
    -  This reply was modified 2 years, 3 months ago by [wibergsweb](https://wordpress.org/support/users/wibergsweb/).
 *  Plugin Author [wibergsweb](https://wordpress.org/support/users/wibergsweb/)
 * (@wibergsweb)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/#post-17449647)
 * If you want to speed up things (when you get it work as expected) you could use
   a setting/attribute called fetch_inteval.
 * As default the plugin fetches content (from your googlesheet) in realtime, converts
   it a csv-file and then renders it to a html-table.
 * But there is a setting created for fetching within certain intervals and it’s`
   fetch_interval`:
 * **fetch_interval** – Set to daily, hourly or weekly. This is how often the actual
   fetch from source is done. so if you add fetch_interval=”hourly” it would only
   fetch once an hour. You **MUST **have html_id_ _set for the table because a local
   file based on it’s html-id is stored to keep the cached file. If one hour hasn’t
   elapsed, then it renders the table directly from your local cached file. This
   locally (on the server where you host your site) cached file is stored in a folder
   called csvtohtml-arrs within your uploads-folder.
 *  Plugin Author [wibergsweb](https://wordpress.org/support/users/wibergsweb/)
 * (@wibergsweb)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/#post-17480882)
 * Because I didn’t hear anything from you for almost two weeks I guess the issue
   is solved, so I set this question as resolved.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Search functionality has some problems’ is closed to new replies.

 * ![](https://ps.w.org/csv-to-html/assets/icon-128x128.png?rev=1397040)
 * [CSV to HTML](https://wordpress.org/plugins/csv-to-html/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/csv-to-html/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/csv-to-html/)
 * [Active Topics](https://wordpress.org/support/plugin/csv-to-html/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/csv-to-html/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/csv-to-html/reviews/)

## Tags

 * [columns](https://wordpress.org/support/topic-tag/columns/)
 * [wordpress admin](https://wordpress.org/support/topic-tag/wordpress-admin/)

 * 4 replies
 * 2 participants
 * Last reply from: [wibergsweb](https://wordpress.org/support/users/wibergsweb/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/search-functionality-has-some-problems/#post-17480882)
 * Status: resolved