Announcement

Collapse
No announcement yet.

Bug in protec users logged.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bug in protec users logged.

    On security module, if you enable Protect Logged users, a table is created, but when you try to login, throws an error because seems the sc_session field is not enough in size for the value stored

    Error

    Code:
    (pdo-mysql): SELECT sc_session FROM sec_logged WHERE login = '' AND sc_session <> '_SC_FAIL_SC_'   (pdo-mysql): DELETE FROM sec_logged WHERE login = ''   (pdo-mysql): SELECT count(*) FROM sec_logged WHERE sc_session = '_SC_BLOCKED_SC_' AND ip = '::1' AND date_login > '1443544624'   (pdo-mysql): SELECT count(*) FROM sec_logged WHERE sc_session = '_SC_FAIL_SC_' AND ip = '::1' AND date_login > '1443544624'   (pdo-mysql): SELECT priv_admin, active, name, email FROM sec_users WHERE login = 'admin' AND pswd = '21232f297a57a5a743894a0e4a801fc3'   (pdo-mysql): SELECT date_login, ip FROM sec_logged WHERE login = 'admin' AND sc_session <> '_SC_FAIL_SC_'   (pdo-mysql): DELETE FROM sec_logged WHERE login = 'admin' AND sc_session = '_SC_FAIL_SC_' AND ip = '::1'   (pdo-mysql): INSERT INTO sec_logged(login, date_login, sc_session, ip) VALUES ('admin', '1443545224.8808', 'medch7llbrlrb106tnk3jntug6jqc9h8i57ns9ih0o3gb63epat0', '::1')   1406: Data too long for column 'sc_session' at row 1
    
                ADOConnection._Execute(INSERT INTO sec_logged(login, date_login, sc_session, ip) VALUES ('admin', '1443545224.8808', 'medch7llbrlrb106tnk3jntug6jqc9h8i..., false) % line 1085, file: adodb.inc.php
             ADOConnection.Execute(INSERT INTO sec_logged(login, date_login, sc_session, ip) VALUES ('admin', '1443545224.8808', 'medch7llbrlrb106tnk3jntug6jqc9h8i...) % line 2598, file: app_Login_apl.php
          app_Login_apl.sc_logged_in(admin, ::1) % line 2499, file: app_Login_apl.php
       app_Login_apl.sc_logged(admin) % line 1723, file: app_Login_apl.php
    app_Login_apl.Valida_campos(null, null, null) % line 1072, file: app_Login_apl.php
    
    	
    ERROR 	Cerrar
    Se produjo un error al acceder a la base de datos
    Data too long for column 'sc_session' at row 1
    
    View SQL
    Workaround until fixed.

    Change size of sc_session field, from 32 to 60 for example.
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions
Working...
X