Nothing happens when creating any search instance

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 Ernest Marcinko 6 years, 3 months ago.

Viewing 3 posts - 16 through 18 (of 18 total)
  • Author
    Posts
  • #16571
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    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,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


    #16940
    findelahistoria
    findelahistoria
    Participant
    You cannot access this content.
    #16943
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    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,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic.