PDA

View Full Version : MYSQL ERROR when I click SAVE on Admin Panel Configurations



Nguyen Dat tai
July 20, 2013, 01:35 AM
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)

Morgan Bohman
July 20, 2013, 06:10 AM
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

John
July 20, 2013, 09:57 AM
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

Nguyen Dat tai
July 21, 2013, 11:34 AM
Hello,

My site is ok now.
Thanks for your support!

Nguyen

Ammar Alkraidi
May 19, 2014, 08:10 AM
Hello,

My site is ok now.
Thanks for your support!

Nguyen

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

thank you,

Dmitry
May 20, 2014, 10:19 AM
Hello Ammar Alkraidi,

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


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

thank you,

Ammar Alkraidi
May 23, 2014, 07:54 AM
Hello Ammar Alkraidi,

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

Already checked and it is off.. still having the same issue

Ammar Alkraidi
May 23, 2014, 09:07 AM
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)

Dmitry
May 23, 2014, 11:02 AM
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.

Ammar Alkraidi
May 24, 2014, 06:17 AM
I sent you PM.. thanks in advance..

Ammar Alkraidi
May 26, 2014, 11:14 AM
Problem solved, thanks Dmitry ..

Amid Deilami
October 11, 2017, 05:48 PM
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

how can i set fl_login_attemps to zero ??? please help me

Viktor
October 12, 2017, 09:14 AM
Hello Amid,

I suggest you create new ticket with your question our tech department will help you.