SQL error and duplicate function name

  • Hi,

    My log is full of the same error coming from IP Base Login. Here it is:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEENstartANDendANDstatus= 1' at line 1 for the request SELECT * FROM wp_ip_based_login WHERE BETWEENstartANDendANDstatus= 1 done by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, triger_login, selectquery

    It seems the WHERE clause is empty, but I can’t figure out why. Could you please investigate ?

    Also, the function getip() is already registered by another plugin that I have installed. Could you please change its name ?

    Many thanks,
    Romain

    https://www.ads-software.com/plugins/ip-based-login/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author brijeshk89

    (@brijeshk89)

    Hi Romain,

    Extremely sorry for the delay.

    We will add a prefix for the function name in the next version so it should resolve the redeclare issue.

    Also the empty values in the SELECT query is because of the same issue the WHERE clause should have the IP but since getip() function failed the variable has empty value causing the syntax error in SELECT query.

    Thread Starter phillylovepark

    (@jjacques529)

    Hi brijeshk89,

    Thanks for your answer. I’ll wait for the update.

    Have a good day.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL error and duplicate function name’ is closed to new replies.