Error while importing database on fresh install.

Ask your questions regarding TimeTrex installation here.
Post Reply
JamesH
Posts: 7
Joined: Tue May 12, 2015 5:56 pm

Error while importing database on fresh install.

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

Re: Error while importing database on fresh install.

Post by shaunw »

JamesH
Posts: 7
Joined: Tue May 12, 2015 5:56 pm

Re: Error while importing database on fresh install.

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

Re: Error while importing database on fresh install.

Post 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.
JamesH
Posts: 7
Joined: Tue May 12, 2015 5:56 pm

Re: Error while importing database on fresh install.

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

Re: Error while importing database on fresh install.

Post 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.
Post Reply