![]() FROM users Users WHERE (ername = 'admin' AND Users.status = 1 AND lete_flag = 0) LIMIT 1` 11:59:43 Debug: duration=1 rows=1 SELECT er_id AS \Users_user_id`. ![]() 11:59:43 Debug: duration=2 rows=1 SHOW TABLE STATUS WHERE Name = 'users' 11:59:43 Debug: duration=7 rows=0 SELECT * FROM information_schema.key_column_usage AS kcu INNER JOIN information_schema.referential_constraints AS rc ON (kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME AND kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA ) WHERE kcu.TABLE_SCHEMA = 'test_db' AND kcu.TABLE_NAME = 'users' AND rc.TABLE_NAME = 'users' 11:59:43 Debug: duration=2 rows=7 SHOW INDEXES FROM \users`` 11:59:43 Debug: duration=6 rows=36 SHOW FULL COLUMNS FROM \users`` Snippet of how it's supposed to look - Current working server SQL log: ("." implies other 20 fields I cropped) Here are two short snippets of the sql logs of me just opening the login page, entering credentials (in our case, username "admin") and trying to sign in. ![]() But what needs to be done if that's the case? I enabled SQL logging and check out the only lead I've found. I'm primarily suspect it is not connecting properly/configured with the database. Hence, the database connection seems fine as far as I can tell. If I enter the wrong credentials, I properly get the error msg saying so. None of my remaining controller code executes or proceeds further. Entering valid credentials just results in it redirecting back as if nothing happened. Didn't even know how to describe it in the title. I've been trying to set up my web application (Cakephp3, php5.6, MySQL 5.7) on another server and I've stumbled across this.rather odd.problem.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |