unable to log in without error message
Posted: Wed Sep 02, 2015 6:07 pm
I installed version 8.0.9 on an ubuntu 14.04 manually and I got it to work.
I needed to transfer this to a different machine - same setup with
mysql Ver 14.14 Distrib 5.5.44 and
PHP 5.5.9-1ubuntu4.11 (cli)
by saving the database and taring the installation directory, copying it over and installing both in the same places as the original version.
That did not work - don't quite know why, as I don't see what might be different - salt in the ini file should match the database. But I could not investigate and installed from scratch on the new machine and that worked.
But now coming back to the first machine, I could not get in any more. Very curious because nothing had changed, the only thing out of the ordinary was that I typed in the wrong password, did not notice the popup and entered a new password and tried again while the popup telling me about the wrong password was still displayed. After that I could not log in any more, but also did not get any error message any more. When I click the login button, just nothing happens.
I tried many thing (short of completely reinstalling) with the last one being to remove all the tables of the database, setting the ini file to allow the install and running through the install process again (checking the requirements - all ok, setting up the table - all done, entering the company details and admin user - all done.
When I try to log in - nothing - and no error message.
I then, according to your instruction, I set the debugging parameters in the ini file and get the error output below in a popup window.
Any idea how I could save the installation? - Oh yes, one of the tests was to delete the cached files, without a difference.
Thanks,
Gunter
Debug Buffer ================================================================
Memory Usage: 765328 Buffer Size: 21
----------------------------------------------------------------------------
DEBUG [L0438] [11ms]: [Function]():
URI: /timetrex/api/json/api.php?Class=APICurrency&Method=getCurrency&v=2&MessageID=fe76bf62-4e1d-b31d-f9f3-09b08e6489a2
IP Address: 192.168.0.101
DEBUG [L0441] [11ms]: [Function]():
USER-AGENT: Mozilla/5.0 (Windows NT 6.3; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36 DEBUG [L0445] [11ms]:
[Function](): Version: 8.0.9 Edition: 10 Production: 1 Database: Type: mysqli
Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php
Demo Mode: 0 DEBUG [L0163] [19ms]: TTDate::setTimeZone():
Setting TimeZone: America/Los_Angeles DEBUG [L0224] [20ms]:
[Function](): Handling JSON Call To API Factory: APICurrency Method: getCurrency
Message ID: fe76bf62-4e1d-b31d-f9f3-09b08e6489a2 DEBUG [L0259] [20ms] Array:
[Function](): Arguments: (Size: 104) array(1) { [0]=> array(2) { ["filter_data"]=>
array(1) { ["user_id"]=> int(2) } ["filter_columns"]=> array(1) { ["symbol"]=> bool(true) } } }
DEBUG [L0268] [26ms]: [Function](): Session ID: ff5d3944fc14b8b8d43b15b26002f59ad840b048
Source IP: 192.168.0.101 DEBUG [L0734] [26ms]: Authentication::Check():
Session ID: ff5d3944fc14b8b8d43b15b26002f59ad840b048 IP Address: 192.168.0.101
URL: /timetrex/api/json/api.php?Class=APICurrency&Method=getCurrency&v=2&MessageID=fe76bf62-4e1d-b31d-f9f3-09b08e6489a2
T DEBUG [L0734] [26ms]: Authentication::Check(): ouch Updated Date: 1
DEBUG [L0057] [32ms]: DBError::__construct(): Begin Exception... DEBUG
[L0058] [32ms] Array: DBError::__construct(): BackTrace: string(166) "#0.Debug::backTrace()
#1.DBError->__construct(Object(ADODB_Exception)) #2.Authentication->Update()
#3.Authentication->Check(ff5d3944fc14b8b8d43b15b26002f59ad840b048) " DEBUG
[L0065] [32ms]: DBError::__construct(): mysqli error: [1665: Cannot execute
statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT
and at least one table uses a storage engine limited to row-based logging.
InnoDB is li DEBUG [L0065] [32ms]: DBError::__construct(): mited to row-logging
when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.]
in EXECUTE("update authentication set updated_date = 1441239931 DEBUG
[L0065] [32ms]: DBError::__construct(): where session_id = 'ff5d3944fc14b8b8d43b15b26002f59ad840b048'
DEBUG [L0065] [32ms]: DBError::__construct(): ") DEBUG [L0065] [32ms]:
DBError::__construct(): DEBUG [L0073] [32ms]: DBError::__construct():
End Exception... ===============================================================
Fatal
error: Call to a member function returnHandler() on a non-object in
/var/www/html/timetrex/classes/modules/core/Exception.class.php
on line 112
ErrorClose
I needed to transfer this to a different machine - same setup with
mysql Ver 14.14 Distrib 5.5.44 and
PHP 5.5.9-1ubuntu4.11 (cli)
by saving the database and taring the installation directory, copying it over and installing both in the same places as the original version.
That did not work - don't quite know why, as I don't see what might be different - salt in the ini file should match the database. But I could not investigate and installed from scratch on the new machine and that worked.
But now coming back to the first machine, I could not get in any more. Very curious because nothing had changed, the only thing out of the ordinary was that I typed in the wrong password, did not notice the popup and entered a new password and tried again while the popup telling me about the wrong password was still displayed. After that I could not log in any more, but also did not get any error message any more. When I click the login button, just nothing happens.
I tried many thing (short of completely reinstalling) with the last one being to remove all the tables of the database, setting the ini file to allow the install and running through the install process again (checking the requirements - all ok, setting up the table - all done, entering the company details and admin user - all done.
When I try to log in - nothing - and no error message.
I then, according to your instruction, I set the debugging parameters in the ini file and get the error output below in a popup window.
Any idea how I could save the installation? - Oh yes, one of the tests was to delete the cached files, without a difference.
Thanks,
Gunter
Debug Buffer ================================================================
Memory Usage: 765328 Buffer Size: 21
----------------------------------------------------------------------------
DEBUG [L0438] [11ms]: [Function]():
URI: /timetrex/api/json/api.php?Class=APICurrency&Method=getCurrency&v=2&MessageID=fe76bf62-4e1d-b31d-f9f3-09b08e6489a2
IP Address: 192.168.0.101
DEBUG [L0441] [11ms]: [Function]():
USER-AGENT: Mozilla/5.0 (Windows NT 6.3; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36 DEBUG [L0445] [11ms]:
[Function](): Version: 8.0.9 Edition: 10 Production: 1 Database: Type: mysqli
Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php
Demo Mode: 0 DEBUG [L0163] [19ms]: TTDate::setTimeZone():
Setting TimeZone: America/Los_Angeles DEBUG [L0224] [20ms]:
[Function](): Handling JSON Call To API Factory: APICurrency Method: getCurrency
Message ID: fe76bf62-4e1d-b31d-f9f3-09b08e6489a2 DEBUG [L0259] [20ms] Array:
[Function](): Arguments: (Size: 104) array(1) { [0]=> array(2) { ["filter_data"]=>
array(1) { ["user_id"]=> int(2) } ["filter_columns"]=> array(1) { ["symbol"]=> bool(true) } } }
DEBUG [L0268] [26ms]: [Function](): Session ID: ff5d3944fc14b8b8d43b15b26002f59ad840b048
Source IP: 192.168.0.101 DEBUG [L0734] [26ms]: Authentication::Check():
Session ID: ff5d3944fc14b8b8d43b15b26002f59ad840b048 IP Address: 192.168.0.101
URL: /timetrex/api/json/api.php?Class=APICurrency&Method=getCurrency&v=2&MessageID=fe76bf62-4e1d-b31d-f9f3-09b08e6489a2
T DEBUG [L0734] [26ms]: Authentication::Check(): ouch Updated Date: 1
DEBUG [L0057] [32ms]: DBError::__construct(): Begin Exception... DEBUG
[L0058] [32ms] Array: DBError::__construct(): BackTrace: string(166) "#0.Debug::backTrace()
#1.DBError->__construct(Object(ADODB_Exception)) #2.Authentication->Update()
#3.Authentication->Check(ff5d3944fc14b8b8d43b15b26002f59ad840b048) " DEBUG
[L0065] [32ms]: DBError::__construct(): mysqli error: [1665: Cannot execute
statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT
and at least one table uses a storage engine limited to row-based logging.
InnoDB is li DEBUG [L0065] [32ms]: DBError::__construct(): mited to row-logging
when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.]
in EXECUTE("update authentication set updated_date = 1441239931 DEBUG
[L0065] [32ms]: DBError::__construct(): where session_id = 'ff5d3944fc14b8b8d43b15b26002f59ad840b048'
DEBUG [L0065] [32ms]: DBError::__construct(): ") DEBUG [L0065] [32ms]:
DBError::__construct(): DEBUG [L0073] [32ms]: DBError::__construct():
End Exception... ===============================================================
Fatal
error: Call to a member function returnHandler() on a non-object in
/var/www/html/timetrex/classes/modules/core/Exception.class.php
on line 112
ErrorClose