This topic contains 17 replies, has 2 voices, and was last updated by Ernest Marcinko 5 years, 3 months ago.
You must be logged in to reply to this topic.
Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Nothing happens when creating any search instance
This topic contains 17 replies, has 2 voices, and was last updated by Ernest Marcinko 5 years, 3 months ago.
Great, then I think I know why 🙂
To check if a table exists, the ‘SHOW’ mySQL command needs to be executed. It is failry common, most of the plugins/theme use this command to check if their tables exist.
I think the database user that is assigned to your WordPress installation does not have the permission to run the ‘SHOW VIEW’ command. On your server cPanel/Plex/phpMyAdmin or via command line you should be able to grant this permission to that user.
I highly recommend doing so, as there is no better way of checking if a table exists.
Let me know about the overlap issue later.
Best,Hi Jordi,
I would rather suggest staying with the current version. If the ‘SHOW’ command is not allowed to the database user still, then the error will come back.
I did some research on the topic to check if there is any way to bypass this method, but unfortunately there is no other way around it.
Best,You must be logged in to reply to this topic.
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |