+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: MYSQL ERROR when I click SAVE on Admin Panel Configurations

  1. #1
    Senior Member
    Join Date
    Jun 2013
    Location
    Vietnam
    Posts
    157

    MYSQL ERROR when I click SAVE on Admin Panel Configurations

    MYSQL ERROR
    Error: Unknown column 'Array' in 'having clause'
    Query: SELECT `IP` AS `Count` FROM `fl_login_attempts` WHERE `IP` = '118.69.151.41' AND `Status` = 'fail' AND `Interface` = 'admin' GROUP BY `Date` HAVING TIMESTAMPDIFF(HOUR, `Date`, NOW()) < Array
    Function: error
    Class: rlDb
    File: /home/abc/public_html/abcd/domain.com/includes/classes/rlDb.class.php (line# 116)

  2. #2
    Goto fl_login_attempts in your MySql and set the number to zero. The default value for the fl_login_attempts you can find in admin panel and if you succeed this value with a number of login attempts, it will no longer permit that you infact are logged in.
    But then you can not see the record of the login attempt if you wanted to get history out until the db is filled again.

    //Morgan
    Free Advertising at Fyndklippet.se


  3. #3
    Flynax developer John's Avatar
    Join Date
    Oct 2009
    Posts
    585
    Hello, make sure the "register_globals" PHP option is disabled in your php.ini file.
    Disable this option if is is enabled and restart apache server.

    John

  4. #4
    Senior Member
    Join Date
    Jun 2013
    Location
    Vietnam
    Posts
    157
    Hello,

    My site is ok now.
    Thanks for your support!

    Nguyen

  5. #5
    Quote Originally Posted by Nguyen Dat tai View Post
    Hello,

    My site is ok now.
    Thanks for your support!

    Nguyen
    Hi..
    What did you do to solve this problem?

    thank you,

  6. #6
    Hello Ammar Alkraidi,

    Please check John post about "register_globals" PHP option,
    Thanks.

    Quote Originally Posted by Ammar Alkraidi View Post
    Hi..
    What did you do to solve this problem?

    thank you,

  7. #7
    Quote Originally Posted by Dmitry View Post
    Hello Ammar Alkraidi,

    Please check John post about "register_globals" PHP option,
    Thanks.
    Already checked and it is off.. still having the same issue

  8. #8
    MYSQL ERROR
    Error: Unknown column 'Array' in 'having clause'
    Query: SELECT `IP` AS `Count` FROM `fl_login_attempts` WHERE `IP` = '37.238.140.125' AND `Status` = 'fail' AND `Interface` = 'admin' GROUP BY `Date` HAVING TIMESTAMPDIFF(HOUR, `Date`, NOW()) < Array
    Function: error
    Class: rlDb
    File: /home1/ammar/public_html/includes/classes/rlDb.class.php (line# 116)

  9. #9
    Hello Ammar Alkraidi,

    Please submit ticket with your problem and login details on your site.
    Then our staff will be check it or send me PM.
    Thanks.

  10. #10
    I sent you PM.. thanks in advance..

+ Reply to Thread