unable to log in without error message

Ask your questions regarding TimeTrex installation here.
Post Reply
gunterzielke
Posts: 3
Joined: Sat Aug 15, 2015 11:21 pm

unable to log in without error message

Post by gunterzielke »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: unable to log in without error message

Post by shaunw »

The problem has nothing to do with TimeTrex, its your MySQL database that is having severe problems, here is the error from your post:
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 when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.]
Just one of the many reasons why we won't recommend using MySQL.
gunterzielke
Posts: 3
Joined: Sat Aug 15, 2015 11:21 pm

Re: unable to log in without error message

Post by gunterzielke »

That was very good info - thank you! Because between the initial install and the later try I did play with binary logging for replication on that server.
When I now disabled binary logging, things are started to look up and I could log in.
I would still say that the fault lies at timetrex, or you would have to say that it is not compatible and not tested with the standard LAMP installation on most linux distribution.
Breaking because binary logging is turned on is not the fault of the database.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: unable to log in without error message

Post by shaunw »

Its entirely a failure of MySQ's replication functionality, TimeTrex has no control over that whatsoever.
Post Reply