Page 1 of 1

Error while importing database on fresh install.

Posted: Wed May 13, 2015 7:37 pm
by JamesH
I have gotten part way through the install now...

I get it far enough that it starts importing the database tables that it uses as the default start point.

It get's to 15/95 16% then gives a very general error that's of no help

Code: Select all

[an error occurred while processing this directive]
I went through and turned on debugging for every reference I could find and nothing comes up on the screen, but in the timetrex log file the following is showing at the end.

Code: Select all

INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1262332800, 10, 3800, 0, 0);
INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1262332800, 10, 36000, 1.84, 0);
DEBUG [L121] [43536ms]:	InstallSchema_Base::getSchemaSQLFileData(): Maximum debug buffer size of: 1000 reached. Writing out buffer before continuing... Buffer ID: 55540770b162e
---------------[ 13-May-2015 20:25:32 -0600 [1431570332.2525] (PID: 18394) ]---------------
I've tried finding any reference to a buffer in apache, mysql, and php, but nothing looked like it was right. I have access to all the settings and files needed to make changes to correct this, but I can't find what needs to be changed.

And before someone just says that TimeTrex doesn't support shared hosts, this is NOT a shared host...

Thank you in advance for your help.

Re: Error while importing database on fresh install.

Posted: Thu May 14, 2015 6:52 am
by shaunw

Re: Error while importing database on fresh install.

Posted: Thu May 14, 2015 12:31 pm
by JamesH
ok, my php version is 5.4.28

my database version is MySQL 5.5.42

I don't recall anything where it said the version number of TimeTrex, but I downloaded it from

Code: Select all

http://www.timetrex.com/onsite_community.php?step=download
four days ago.

The web server is Apache, Cpanel/WHM (Yes, i have root access when needed)

My php error log from the last time I tried to install is here:
https://healworldwide.com/timesheet/log/error_log

(it didn't want to let me attach the php log file, so i put it in the same folder on my server as the timetrex log)

The log file for timetrex is here:
https://healworldwide.com/timesheet/log/timetrex.log

This is with all the debugging code suggested.

Thank you and Mahalo,
--James

Re: Error while importing database on fresh install.

Posted: Fri May 15, 2015 7:33 am
by shaunw
The only error I'm seeing is with your timezones, see this FAQ for more information regarding timezones and MySQL:
http://forums.timetrex.com/viewtopic.php?f=6&t=40

Other than that, check your PHP error log, its possible your PHP memory limit or maximum execution time may be set too low.

Re: Error while importing database on fresh install.

Posted: Fri May 15, 2015 12:57 pm
by JamesH
The php error log was linked above because the forum wouldn't let me attach it here:

https://healworldwide.com/timesheet/log/error_log

The timeout is set to 60 seconds, and the memory it set to 800 meg... I can increase both of these but I would think both of those would be high enough?

I will look at the time setting of mysql and see if that makes any difference.

Thanks.

Re: Error while importing database on fresh install.

Posted: Fri May 15, 2015 4:11 pm
by shaunw
Unfortunately when trying to view your php error log it says the permissions are denied.

The execution time should probably be increased to 600 seconds, see if that makes any difference.