Search found 86 matches

by pribis
Fri Jul 27, 2018 12:37 pm
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

Well, I ran sed over the file and replaced the \' with ''. That got me pretty far. But now \r\n is causing problems.

I'll wait to hear back. Maybe you have a more convenient solution than what I am doing.
by pribis
Fri Jul 27, 2018 11:38 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

I'm using mysql 5.7.22 and psql 9.5.13.
by pribis
Fri Jul 27, 2018 11:25 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

I just grepped the sql file and found: SET standard_conforming_strings = 'off';SET backslash_quote = 'on';SET escape_string_warning = 'off';

So technically this should work. But again...it ain't.
by pribis
Fri Jul 27, 2018 11:16 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

I verified that standard_conforming_strings is on. So it would seem that this should not be happening. But it is.
by pribis
Fri Jul 27, 2018 9:50 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

So close: psql:timetrex_mysql.sql:1089984: invalid command \'t brian@bxp(bxp):12:41:/var/www/time2/db/timetrex $ sed -n 1089984p timetrex_mysql.sql INSERT INTO message (id, parent_id, object_type_id, object_id, priority_id, status_id, status_date, subject, body, require_ack, ack, ack_date, ack_by, c...
by pribis
Fri Jul 27, 2018 9:11 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

Gah! Brain fart. I knew that! Thanks.
by pribis
Fri Jul 27, 2018 8:55 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

This is what is on that line: 766876:INSERT INTO remittance_source_account (id, legal_entity_id, status_id, type_id, country, name, description, data_format_id, currency_id, last_transaction_number, value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, va...
by pribis
Fri Jul 27, 2018 5:37 am
Forum: Installation Help
Topic: system_log
Replies: 2
Views: 513

Re: system_log

Sigh, ok. Starting to really loath MySQL. It took 1hr and 12min to complete :) But at least it completed.
by pribis
Fri Jul 27, 2018 5:35 am
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

Re: report_schedule does not exist

This was a TRUNCATE. I simply removed it and moved on. Before that line was: TRUNCATE recurring_schedule_template_control; TRUNCATE recurring_schedule_user; TRUNCATE regular_time_policy; TRUNCATE remittance_destination_account; TRUNCATE remittance_source_account; --- But now I get: psql:timetrex_mys...
by pribis
Thu Jul 26, 2018 12:31 pm
Forum: Installation Help
Topic: report_schedule does not exist
Replies: 23
Views: 1443

report_schedule does not exist

Upgrading from mysql to postgres. The upgrade to the last mysql capable version appeared to go without a hitch (although it took a really long time - but no errors in the log). I've done everything listed at https://forums.timetrex.com/viewtopic.php?t=7519 up to the last step: putting the data back ...
by pribis
Thu Jul 26, 2018 11:05 am
Forum: Installation Help
Topic: system_log
Replies: 2
Views: 513

system_log

I'm converting our mysql install to postgres. As part of the process we are upgrading from 10.6.2 to 11.0.2. The upgrade is taking a looooong time (like working on forty minutes now). The longest part is the upgrade of the system_log table. It has over 2.5 million records. Can we truncate this to sp...
by pribis
Fri Jun 08, 2018 12:22 pm
Forum: Help
Topic: Another daylight saving issue
Replies: 25
Views: 3105

Re: Another daylight saving issue

nm, found it: EST5EDT Not EDT.
by pribis
Fri Jun 08, 2018 12:12 pm
Forum: Help
Topic: Another daylight saving issue
Replies: 25
Views: 3105

Re: Another daylight saving issue

Same issue I think. I am on 11.0.2 using php 5.6. Timezone is correct on the server, but all of the dates for pay periods is set to GMT and are thus four hours off. I tried setting the ssytem_timezone in the timetrex.ini, but the only option it appears to accept is EST. Which is only right for half ...
by pribis
Fri Jun 08, 2018 6:08 am
Forum: General Discussion
Topic: pay period off by four hours
Replies: 2
Views: 560

Re: pay period off by four hours

I set it manually in the timetrex.ini.php and that fixed it.

system_timezone = EST

Not sure if that is what I was supposed to do or not. I didn't see this option in the linux example config.
by pribis
Fri Jun 08, 2018 5:41 am
Forum: General Discussion
Topic: pay period off by four hours
Replies: 2
Views: 560

pay period off by four hours

I upgraded our system (a test system with 10.6.x installed) to 11.0.2 in preparation for moving to postgresql. But all of our pay periods have jumped into the future four hours. I've checked the server and it is set to the correct timezone, so is PHP. I am not sure where to look next.
by pribis
Thu May 17, 2018 9:49 am
Forum: Installation Help
Topic: Permissions (again again again...)
Replies: 2
Views: 663

Re: Permissions (again again again...)

Sorry. The above post relates to the installation checks. This is an upgrade.
by pribis
Thu May 17, 2018 9:38 am
Forum: Installation Help
Topic: Permissions (again again again...)
Replies: 2
Views: 663

Permissions (again again again...)

I realize this has been asked before, but after reading a few posts I still can't see the problem. /var/ww/timetrex/logs not writable. My logs directory is set to the owner and group of the webserver (nginx). Permissions are set to 755 and 644 for the dir and files. This is the way my current instal...
by pribis
Thu May 17, 2018 9:34 am
Forum: Installation Help
Topic: Not enough disk space available
Replies: 7
Views: 4324

Re: Not enough disk space available

You are right. I am the IT manager for our systems and I get regular reports and notices about the state of my servers. I guess most people installing this aren't in the same position I am. But then again...if it is really mission critical you would think that having qualified people managing their ...
by pribis
Thu May 17, 2018 7:15 am
Forum: Installation Help
Topic: Not enough disk space available
Replies: 7
Views: 4324

Re: Not enough disk space available

Wow! Six whole years since I mentioned this. What...is...the...point? if ( $free_space > $min_free_space AND $free_space_percent > $min_free_percent ) { return 0; } I've been commenting this out for six years because even though I had plenty of free space, the percentage always failed even when I ha...
by pribis
Fri Jan 13, 2017 1:12 pm
Forum: General Discussion
Topic: Extra request fields
Replies: 1
Views: 1782

Extra request fields

So we upgraded to 10.0.4 (local install) today. And our supervisor noticed that when she went to approve requests there were a lot more fields then before. I see reference to this here: http://help.timetrex.com/v10.0/enterprise/#Modules/Requests.htm#kanchor100 She is seeing what is listed under the ...
by pribis
Wed Feb 10, 2016 11:44 am
Forum: General Discussion
Topic: password policy change
Replies: 7
Views: 4516

Re: password policy change

One more thing (is this written down somewhere? I looked in the manual but didn't see it):

Does the password policy expire passwords? I don't want to be surprised by this one either.

Thanks
by pribis
Wed Feb 10, 2016 10:10 am
Forum: General Discussion
Topic: password policy change
Replies: 7
Views: 4516

Re: password policy change

Concerning your passwords that would or would not be accepted. I went back and checked that out. You are right (of course), but it seems that maybe some tuning would be a good thing. Like why in the world would abc123 be accepted but Paumiu6w or Deis7iLi not? Sequential numbers and letters are typic...
by pribis
Wed Feb 10, 2016 9:59 am
Forum: General Discussion
Topic: password policy change
Replies: 7
Views: 4516

Re: password policy change

Thanks for the feedback. I guess the problem I'm running into is that you and I have different ideas of what is needed for the environment I work in. Besides, passwords that are so difficult that they cannot be memorized with a certain amount of ease just get written down and stored out in the open ...
by pribis
Wed Feb 10, 2016 5:43 am
Forum: General Discussion
Topic: password policy change
Replies: 7
Views: 4516

Re: password policy change

Our passwords are secure and frankly screwing with the password policy sucks when we already have a company wide one that isn't in sync with yours. So now I have to change our policy to fit yours? If you are going to do that then please enable the password policy editor for the community edition. Wh...
by pribis
Tue Feb 09, 2016 11:08 am
Forum: General Discussion
Topic: password policy change
Replies: 7
Views: 4516

password policy change

Ok, so suddenly the passwords I use to use aren't working. I'm told they are too weak and need a special char or number? My passwords eight characters and contain upper and lower case and a number and are never based off of regular english words. So they are strong enough for an inhouse system. I tr...