pay stub error ubuntu

arcolen · Post by **arcolen** » Fri Nov 28, 2008 8:37 am

i run

select a.* from pay_stub_entry as a, pay_stub_entry_account as b where a.pay_stub_entry_name_id = b.id AND a.pay_stub_id = '419' AND a.deleted = 0 order by b.ps_order asc,abs(a.ytd_amount) asc,a.id asc

and thats return 0 rows :S

i search manualy and there is no row with that pay_stub_id in pay_stub_entry

i will try to truncate all pay_stub related tables

arcolen · Post by **arcolen** » Fri Nov 28, 2008 9:06 am

i truncate the tables:
pay_stub
pay_stub_entry
pay_stub_entry_id_seq
pay_stub_id_seq

and when i generate the pay_stub its generate two with the same pay pariod
in the forum was something like this:
http://forums.timetrex.com/viewtopic.php?t=344

my version of mysql its 5.0.67

i will install the .deb of timetrex, and restore the backup of database

Post by **shaunw** » Fri Nov 28, 2008 9:35 am

Do you still have TimeTrex running on Windows? If so, I would try running the same query on there to see what the results are.

Definitely sounds like your database didn't make it to Linux in one piece.

arcolen · Post by **arcolen** » Fri Nov 28, 2008 11:00 am

the .bin install postgresql

i will unistall the .bin and install al manually, or can i install mysql version compatible with timetrex and linkit in the timetrex.ini.php???

regards

Post by **shaunw** » Fri Nov 28, 2008 11:06 am

The automated installer will only work with PostgreSQL.

arcolen · Post by **arcolen** » Fri Nov 28, 2008 3:02 pm

mmm, i had another instalation of postgre for openbravo erp , and the pgadmin dont show me the timetrex table

why the instaler dosn't have mysql?

Post by **shaunw** » Fri Nov 28, 2008 5:25 pm

While TimeTrex supports MySQL, we don't recommend using it because it lacks major enterprise functionality and reliability that we believe is necessary for storing mission critical data used for payroll and time and attendance.

MySQL accounts for less then 2% (roughly) of our install base, while it also accounts for over half of all database related problems. It is also slower especially when it comes to some of the advanced queries TimeTrex needs to run.

arcolen · Post by **arcolen** » Sat Nov 29, 2008 1:52 pm

how can i enter to pgadmin timetrex?

arcolen · Post by **arcolen** » Mon Dec 01, 2008 7:36 am

i setup pgadmin and phppgadmin

the problem now is mysql tables to postgre

arcolen · Post by **arcolen** » Wed Dec 03, 2008 9:03 am

i test the files and database i had in ubuntu in a windows xp and pay stub work great!!

in ubuntu i install xampp 1.6.6 that comes with mysql 5.0.51a the same i have in windows (appserv)

in ubuntu pay syub apear blank, windows pay stub good

here is the phpinfo of each one:

http://74.86.193.160/~elvioylo/phpinfo_windows.htm
http://74.86.193.160/~elvioylo/phpinfo_ubuntu.html

can you tell the diference betwen them? i look someone of diference but i dont know what make pay stub work

please check the phpinfo and tell me what i have to modify in ubuntu

thank you so much!!!!!!!!!

Post by **shaunw** » Wed Dec 03, 2008 10:22 am

This tells me that there are likely two possible problems:

1. All the data wasn't migrated from your windows MySQL to your Linux MySQL.

2. Your TimeTrex installation on Linux is not correct.

To troubleshoot which it is, I would try pointing your TimeTrex installation on Linux to the MySQL server on Windows. If that works, then we know something is getting lost during the MySQL data migration.

If it doesn't work, then chances are your TimeTrex installation on Linux is having problems.

arcolen · Post by **arcolen** » Thu Dec 04, 2008 10:07 am

in the las post i tell you i have migrate all the linux instalation to windows, and its works perfectly.

for that reason i post the phpinfo data of windows and ubuntu to find something wrong in ubuntu.

arcolen · Post by **arcolen** » Tue Dec 09, 2008 9:21 am

can you tell me any solution? or what versions of apache php mysql i had to install?

i'm the only one who has this issue?? everything works great but dont show pay stub!!!!

Post by **shaunw** » Tue Dec 09, 2008 10:56 am

If I understand you correctly, you took the Linux database and migrated it to Windows and the pay stubs worked?

If thats the case, then its likely just a permission issue with the cache files like we discussed earlier.

At the Linux console/shell, go to your TimeTrex cache directory and run:

ls -lR

Copy and paste the output here.

arcolen · Post by **arcolen** » Fri Dec 12, 2008 11:07 am

this is the result:

Code: Select all

arcolen@servidor:/etc/init.d$ cd /tmp/timetrex
arcolen@servidor:/tmp/timetrex$ ls -lR
ls: no se puede abrir el directorio .: Permiso denegado
arcolen@servidor:/tmp/timetrex$ sudo ls -lR
.:
total 44
drwxrwx--x 2 nobody nogroup 4096 2008-12-12 16:05 53
drwxrwx--x 2 nobody nogroup 4096 2008-12-12 16:05 88
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 company
drwxrwx--x 2 nobody nogroup 4096 2008-12-12 16:05 f0
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 hierarchy_object_type
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 message
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 pay_period
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 permission
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 system_setting
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 user_preference
drwxr-x--x 3 nobody nogroup 4096 2008-12-12 16:05 users

./53:
total 8
-rw-r--r-- 1 nobody nogroup 4722 2008-12-12 16:05 adodb_5316f6a097cc5ee9a27598911d587bb5.cache

./88:
total 8
-rw-r--r-- 1 nobody nogroup 7243 2008-12-12 16:05 adodb_881691a757c17b3163b781e01cad99f2.cache

./company:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 208

./company/208:
total 4
-rw-r--r-- 1 nobody nogroup 3743 2008-12-12 16:05 2082672713

./f0:
total 8
-rw-r--r-- 1 nobody nogroup 7408 2008-12-12 16:05 adodb_f0d39a1f6d9decdb89e5dc69b416f410.cache

./hierarchy_object_type:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 577

./hierarchy_object_type/577:
total 4
-rw-r--r-- 1 nobody nogroup 3234 2008-12-12 16:05 577100463

./message:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 208

./message/208:
total 4
-rw-r--r-- 1 nobody nogroup 36 2008-12-12 16:05 2082672713

./pay_period:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 425

./pay_period/425:
total 4
-rw-r--r-- 1 nobody nogroup 591 2008-12-12 16:05 425632125

./permission:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 276

./permission/276:
total 12
-rw-r--r-- 1 nobody nogroup 8539 2008-12-12 16:05 27623755

./system_setting:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 914

./system_setting/914:
total 4
-rw-r--r-- 1 nobody nogroup 393 2008-12-12 16:05 91457757

./user_preference:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 208

./user_preference/208:
total 4
-rw-r--r-- 1 nobody nogroup 3604 2008-12-12 16:05 2082672713

./users:
total 4
drwxr-x--x 2 nobody nogroup 4096 2008-12-12 16:05 208

./users/208:
total 8
-rw-r--r-- 1 nobody nogroup 4738 2008-12-12 16:05 2082672713
arcolen@servidor:/tmp/timetrex$

Post by **shaunw** » Fri Dec 12, 2008 12:18 pm

The permissions appear to be fine.

Unfortunately I don't know what the issue is. I would recommend purchasing a support package so we can access your server remotely and fix the issue for you.

arcolen · Post by **arcolen** » Fri Dec 12, 2008 12:27 pm

what is the cost of the support?

Post by **shaunw** » Fri Dec 12, 2008 12:49 pm

Support is $85/hr.

arcolen · Post by **arcolen** » Fri Dec 12, 2008 1:03 pm

for the moment i will try to fix the issue wihtout pay. but i will consult my boss.

arcolen · Post by **arcolen** » Tue Dec 23, 2008 9:57 am

hi, i install timetrex with the installer on the site.

to migrate the mysql database i folow this simple steps:

first truncate all timetrex tables on postgre:

Code: Select all

TRUNCATE TABLE "absence_policy";
TRUNCATE TABLE "accrual";
TRUNCATE TABLE "accrual_balance";
TRUNCATE TABLE "accrual_policy";
TRUNCATE TABLE "accrual_policy_milestone";
TRUNCATE TABLE "authentication";
TRUNCATE TABLE "authorizations";
TRUNCATE TABLE "bank_account";
TRUNCATE TABLE "branch";
TRUNCATE TABLE "bread_crumb";
TRUNCATE TABLE "company";
TRUNCATE TABLE "company_deduction";
TRUNCATE TABLE "company_deduction_pay_stub_entry_account";
TRUNCATE TABLE "company_user_count";
TRUNCATE TABLE "cron";
TRUNCATE TABLE "currency";
TRUNCATE TABLE "department";
TRUNCATE TABLE "department_branch";
TRUNCATE TABLE "department_branch_user";
TRUNCATE TABLE "exception";
TRUNCATE TABLE "exception_policy";
TRUNCATE TABLE "exception_policy_control";
TRUNCATE TABLE "help";
TRUNCATE TABLE "help_group";
TRUNCATE TABLE "help_group_control";
TRUNCATE TABLE "hierarchy_control";
TRUNCATE TABLE "hierarchy_object_type";
TRUNCATE TABLE "hierarchy_share";
TRUNCATE TABLE "hierarchy_tree";
TRUNCATE TABLE "holidays";
TRUNCATE TABLE "holiday_policy";
TRUNCATE TABLE "holiday_policy_recurring_holiday";
TRUNCATE TABLE "income_tax_rate";
TRUNCATE TABLE "income_tax_rate_cr";
TRUNCATE TABLE "income_tax_rate_us";
TRUNCATE TABLE "meal_policy";
TRUNCATE TABLE "message";
TRUNCATE TABLE "other_field";
TRUNCATE TABLE "over_time_policy";
TRUNCATE TABLE "pay_period";
TRUNCATE TABLE "pay_period_schedule";
TRUNCATE TABLE "pay_period_schedule_user";
TRUNCATE TABLE "pay_period_time_sheet_verify";
TRUNCATE TABLE "pay_stub";
TRUNCATE TABLE "pay_stub_amendment";
TRUNCATE TABLE "pay_stub_entry";
TRUNCATE TABLE "pay_stub_entry_account";
TRUNCATE TABLE "pay_stub_entry_account_link";
TRUNCATE TABLE "permission";
TRUNCATE TABLE "permission_control";
TRUNCATE TABLE "permission_old";
TRUNCATE TABLE "permission_user";
TRUNCATE TABLE "policy_group";
TRUNCATE TABLE "policy_group_accrual_policy";
TRUNCATE TABLE "policy_group_over_time_policy";
TRUNCATE TABLE "policy_group_premium_policy";
TRUNCATE TABLE "policy_group_round_interval_policy";
TRUNCATE TABLE "policy_group_user";
TRUNCATE TABLE "premium_policy";
TRUNCATE TABLE "premium_policy_branch";
TRUNCATE TABLE "premium_policy_department";
TRUNCATE TABLE "punch";
TRUNCATE TABLE "punch_control";
TRUNCATE TABLE "recurring_holiday";
TRUNCATE TABLE "recurring_ps_amendment";
TRUNCATE TABLE "recurring_ps_amendment_user";
TRUNCATE TABLE "recurring_schedule_control";
TRUNCATE TABLE "recurring_schedule_template";
TRUNCATE TABLE "recurring_schedule_template_control";
TRUNCATE TABLE "recurring_schedule_user";
TRUNCATE TABLE "request";
TRUNCATE TABLE "roe";
TRUNCATE TABLE "round_interval_policy";
TRUNCATE TABLE "schedule";
TRUNCATE TABLE "schedule_policy";
TRUNCATE TABLE "station";
TRUNCATE TABLE "station_branch";
TRUNCATE TABLE "station_department";
TRUNCATE TABLE "station_exclude_user";
TRUNCATE TABLE "station_include_user";
TRUNCATE TABLE "station_user";
TRUNCATE TABLE "station_user_group";
TRUNCATE TABLE "system_log";
TRUNCATE TABLE "system_setting";
TRUNCATE TABLE "users";
TRUNCATE TABLE "user_date";
TRUNCATE TABLE "user_date_total";
TRUNCATE TABLE "user_deduction";
TRUNCATE TABLE "user_default";
TRUNCATE TABLE "user_default_company_deduction";
TRUNCATE TABLE "user_generic_data";
TRUNCATE TABLE "user_generic_status";
TRUNCATE TABLE "user_group";
TRUNCATE TABLE "user_group_tree";
TRUNCATE TABLE "user_identification";
TRUNCATE TABLE "user_pay_period_total";
TRUNCATE TABLE "user_preference";
TRUNCATE TABLE "user_tax";
TRUNCATE TABLE "user_title";
TRUNCATE TABLE "user_wage";

then i make a dump of mysql database without the tables ended on id_seq, only data without "complete inserts" and "extended INSERTs" cause this make errors on postgree

in the .sql file i replace all the ` with " , postgre don't suport `

also i don't export the table system_log cause have to many error for postgre

also station table had a bad date style: 0000-00-00 00:00:00
i replace all the 0000-00-00 00:00:00 with 2000-01-01 00:00:01

if i don't forget nothing, these are the step i follow, sure to many people with useit

but, when we run timetrex with your installer and the migrated database, the issue with pay stub don't be solved

then, the error is not in the timetrex instalation i guess

what other solution can we try???

Regards

Post by **shaunw** » Tue Dec 23, 2008 10:47 am

During the database migration, did you also update all the sequences to a value above the maximum that is already contained in the table? Without that most things will fail with conflicting primary key errors.

arcolen · Post by **arcolen** » Wed Dec 24, 2008 9:52 am

i dont understand, plese be more especific

regards

Post by **shaunw** » Wed Dec 24, 2008 12:11 pm

Please see the PostgreSQL documentation regarding sequences.

Migrating from MySQL to PostgreSQL (or vice versa) is actually quite complex and difficult to do correctly.

arcolen · Post by **arcolen** » Wed Dec 24, 2008 2:50 pm

y dont understant the problem of that, if i insert the rows with sql, it has to be the same in postgre and mysql

the only think i made was insert rows, is nothing of the other world

arcolen · Post by **arcolen** » Mon Dec 29, 2008 9:33 am

i had to create the sequens for all *_id_seq tables of timetrex?
like:

CREATE SEQUENCE absence_policy_id_seq

can you givme one example of CREATE SEQUENCE and i will make the rest

thanks a lot

TimeTrex Time and Attendance

pay stub error ubuntu

Time and Attendance