pay stub error ubuntu

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

pay stub error ubuntu

Post by arcolen »

Hello, i move all the timetrex of windows server 2003 to ubuntu intrepid ibex 8.10, and all was fine, the load of the timetrex is 20 times faster :D , but i had a problem again with pay stub, when i try to generate a pay stub its apear blank page at all, no showing nothing.

if i try to load the pay stub with windows, the acrobat reader show me "nombre de objeto desconocido" in english "unknow object name"

i debug the pay stub and show this:

Code: Select all

(mysqlt): SET SESSION sql_mode='ansi'   (mysqlt): SET TRANSACTION ISOLATION LEVEL READ COMMITTED   (mysqlt): SET SESSION time_zone='America/Buenos_Aires'   (mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = 'e8221b537d3afa4afef0d18608708616' AND ip_address = '127.0.0.1' AND updated_date >= 1227611650   (mysqlt): update authentication set updated_date = 1227626050 where session_id = 'e8221b537d3afa4afef0d18608708616'   (mysqlt): select * from station where company_id = '1' AND station_id = '140176d43d2793a1b1d9351807955ff1' AND deleted = 0   (mysqlt): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1   (mysqlt): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = '1' AND a.type_id = 50 AND b.date_stamp < '2008-11-25' AND e.status_id = 10 AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc    /tmp/timetrex//e4/adodb_e488e80b1fe712edd3b20b1ce6347806.cache reloaded, ttl=4349 [ select * from pay_stub where id = -1 ]
(mysqlt): select a.* from pay_stub as a LEFT JOIN users as b ON a.user_id = b.id where b.company_id = '1' AND a.id in ('1622') AND ( a.deleted = 0 AND b.deleted = 0 ) order by transaction_date desc   (mysqlt): select * from pay_period_schedule where id = '3' AND deleted=0   /tmp/timetrex//e7/adodb_e797f8857d918598a5ad8393da09cbce.cache reloaded, ttl=4349 [ select * from pay_stub_entry where id = -1 ]
(mysqlt): 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 = '1622' AND a.deleted = 0 order by b.ps_order asc,abs(a.ytd_amount) asc,a.id asc   /tmp/timetrex//06/adodb_0646dc11c07626fb570a2915060584b1.cache reloaded, ttl=4356 [ select * from accrual_balance where id = -1 ]
(mysqlt): select a.*, c.name as name from accrual_balance as a, users as b, accrual_policy as c where a.user_id = b.id AND a.accrual_policy_id = c.id AND b.company_id = '1' AND c.enable_pay_stub_balance_display = 1 AND a.user_id in ('8') AND a.deleted = 0 order by c.name asc   ERROR: Talonario de Pagos no esta disponible, puede haber sido eliminado!
and the end says that the pay stub is not available or has been eliminated.

Can you help me?
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

the log of the maintenance job have an error;

---------------[ Tue, 25 Nov 2008 14:02:50 -0200 (PID: 25228) ]---------------
---------------[ Tue, 25 Nov 2008 14:04:00 -0200 (PID: 25228) ]---------------
DEBUG [43]: <b>DBError::__construct()</b>: mysqlt error: [-32000: Cache write error] in CacheExecute(/tmp/timetrex//93/adodb_936e17385786cc62241b96df62979d85.cache, select * from cron where id = -1)
<br>
---------------[ Tue, 25 Nov 2008 14:04:00 -0200 (PID: 25228) ]---------------

maybe this cause the issue
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Yes, your cache files in /tmp/timetrex are not writable by the web server user.

Delete everything out of all your cache directories, and make sure that your maintenance jobs are being run as the same user your web server runs as.

Also I recommend re-running the TimeTrex installer to confirm that all system requirements are being met.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

trying to find the problem, i downgrade to an old backup of the bd, the issue still there.
with the downgrade timetrex inform me of maintenance job
i do it manualy and i recive this error:
arcolen@servidor:~$ php /var/www/timetrex/classes/modules/core/../../../maint/cron.php
sh: /usr/sbin/sendmail: not found

i install sendmail and the maintenance job work grate.
but, the issue continue

i upgrade again the bd

try to do maintenance job and end but nothing showing :S
arcolen@servidor:~$ php /var/www/timetrex/classes/modules/core/../../../maint/cron.php
sh: /var/lib/php5: Permission denied
arcolen@servidor:~$

log:

Code: Select all

---------------[ Tue, 25 Nov 2008 14:27:43 -0200 (PID: 26322) ]---------------
---------------[ Tue, 25 Nov 2008 14:28:53 -0200 (PID: 26322) ]---------------
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: AddPayPeriod Previous Scheduled Date: Tue, 25 Nov 2008 00:00:00 -0200(1227578400) Last Run Time: Mon, 24 Nov 2008 12:27:37 -0200(1227536857) Current Epoch: 1227630463<br>
DEBUG [470]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is SCHEDULED TO RUN NOW!<br>
DEBUG [332]:	<b>CronJobFactory::getSystemLoad()</b>:  Load Average: 0.95<br>
DEBUG [350]:	<b>CronJobFactory::isSystemLoadValid()</b>:  Load average within valid limits: Current: 0.95 Max: 9999<br>
DEBUG [567]:	<b>CronJobFactory::Execute()</b>: Job is currently running, skipping...<br>
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: AddUserDate Previous Scheduled Date: Tue, 25 Nov 2008 00:15:00 -0200(1227579300) Last Run Time: Mon, 24 Nov 2008 12:27:37 -0200(1227536857) Current Epoch: 1227630463<br>
DEBUG [470]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is SCHEDULED TO RUN NOW!<br>
DEBUG [332]:	<b>CronJobFactory::getSystemLoad()</b>:  Load Average: 0.95<br>
DEBUG [350]:	<b>CronJobFactory::isSystemLoadValid()</b>:  Load average within valid limits: Current: 0.95 Max: 9999<br>
DEBUG [567]:	<b>CronJobFactory::Execute()</b>: Job is currently running, skipping...<br>
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: UserCount Previous Scheduled Date: Tue, 25 Nov 2008 01:15:00 -0200(1227582900) Last Run Time: Mon, 24 Nov 2008 12:27:37 -0200(1227536857) Current Epoch: 1227630463<br>
DEBUG [470]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is SCHEDULED TO RUN NOW!<br>
DEBUG [332]:	<b>CronJobFactory::getSystemLoad()</b>:  Load Average: 0.95<br>
DEBUG [350]:	<b>CronJobFactory::isSystemLoadValid()</b>:  Load average within valid limits: Current: 0.95 Max: 9999<br>
DEBUG [534]:	<b>CronJobFactory::Execute()</b>: Job is NOT currently running, running now...<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 20<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [815]:	<b>Factory::Save()</b>:  Updating...<br>
DEBUG [640]:	<b>Factory::getUpdateQuery()</b>: Update<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227630463 Converted Value: 1227630463<br>
DEBUG [671]:	<b>Factory::getUpdateQuery()</b>: Data changed, set updated date: <br>
DEBUG [853]:	<b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [69]:	<b>Factory::removeCache()</b>: Attempting to remove cache: 6<br>
DEBUG [75]:	<b>Factory::removeCache()</b>: Removing cache: 6 Group Id: cron<br>
DEBUG [736]:	<b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [547]:	<b>CronJobFactory::Execute()</b>: Command: "/var/lib/php5"  "/var/www/timetrex/maint/UserCount.php"<br>
DEBUG [551] Array: <b>CronJobFactory::Execute()</b>: Time: 0.00352692604065s - Command RetCode: 126 Output: 
<pre>
Array
(
)
</pre><br>
DEBUG [110]:	<b>Validator::isNumeric()</b>: Value:6<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 500<br>
DEBUG [149]:	<b>Validator::isLength()</b>: Value: cron Length: 4 Min: 2 Max: 250<br>
DEBUG [149]:	<b>Validator::isLength()</b>: Value: Executing Cron Job: 6 Command: "/var/lib/php5"  "/var/www/timetrex/maint/UserCount.php" Return Code: 126 Length: 104 Min: 2 Max: 2000<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227630463 Converted Value: 1227630463<br>
DEBUG [802]:	<b>Factory::Save()</b>: Insert ID: 19390<br>
DEBUG [708]:	<b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [43]:	<b>DBError::__construct()</b>: mysqlt error: [-32000: Cache write error] in adodb_throw(/tmp/timetrex//5d/adodb_5d59db020971136517ec3e74cbd6b77b.cache, select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1)
<br>
---------------[ Tue, 25 Nov 2008 14:28:53 -0200 (PID: 26322) ]---------------
i still trying to fix this while i wait help.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

hi shaunw, i dont see your reply cause i posting.

then i had to change:
* * * * * su arcolen -c "php /var/www/timetrex/classes/modules/core/../../../ma$
for:

* * * * * su www-data -c "php /var/www/timetrex/classes/modules/core/../../../ma$

cause the prmision are for www-data

i try it now
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i change the permisions of the folders, and this is the result:
arcolen@servidor:~$ php /var/www/timetrex/classes/modules/core/../../../maint/cron.php
NOTE: Jobs are scheduled to run at specific times, therefore only some jobs are executed each time this file is run.
Jobs Executed: 1 of 11
arcolen@servidor:~$

Code: Select all

---------------[ Tue, 25 Nov 2008 15:03:43 -0200 (PID: 28513) ]---------------
---------------[ Tue, 25 Nov 2008 15:04:34 -0200 (PID: 28543) ]---------------
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: AddPayPeriod Previous Scheduled Date: Tue, 25 Nov 2008 00:00:00 -0200(1227578400) Last Run Time: Tue, 25 Nov 2008 15:03:00 -0200(1227632580) Current Epoch: 1227632674<br>
DEBUG [473]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is NOT scheduled to run right now...<br>
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: TimeClockSync Previous Scheduled Date: Tue, 25 Nov 2008 15:04:00 -0200(1227632640) Last Run Time: Tue, 25 Nov 2008 15:03:00 -0200(1227632580) Current Epoch: 1227632674<br>
DEBUG [470]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is SCHEDULED TO RUN NOW!<br>
DEBUG [332]:	<b>CronJobFactory::getSystemLoad()</b>:  Load Average: 2.37<br>
DEBUG [350]:	<b>CronJobFactory::isSystemLoadValid()</b>:  Load average within valid limits: Current: 2.37 Max: 9999<br>
DEBUG [534]:	<b>CronJobFactory::Execute()</b>: Job is NOT currently running, running now...<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 20<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [815]:	<b>Factory::Save()</b>:  Updating...<br>
DEBUG [640]:	<b>Factory::getUpdateQuery()</b>: Update<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632674 Converted Value: 1227632674<br>
DEBUG [671]:	<b>Factory::getUpdateQuery()</b>: Data changed, set updated date: <br>
DEBUG [853]:	<b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [69]:	<b>Factory::removeCache()</b>: Attempting to remove cache: 11<br>
DEBUG [75]:	<b>Factory::removeCache()</b>: Removing cache: 11 Group Id: cron<br>
DEBUG [736]:	<b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [555]:	<b>CronJobFactory::Execute()</b>: WARNING: File does not exist, skipping: /var/www/timetrex/maint/TimeClockSync.php<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 10<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632700 Converted Value: 1227632700<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [815]:	<b>Factory::Save()</b>:  Updating...<br>
DEBUG [640]:	<b>Factory::getUpdateQuery()</b>: Update<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632674 Converted Value: 1227632674<br>
DEBUG [671]:	<b>Factory::getUpdateQuery()</b>: Data changed, set updated date: <br>
DEBUG [853]:	<b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [69]:	<b>Factory::removeCache()</b>: Attempting to remove cache: 11<br>
DEBUG [75]:	<b>Factory::removeCache()</b>: Removing cache: 11 Group Id: cron<br>
DEBUG [736]:	<b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [60]:	<b>[Function]()</b>: CRON: Jobs Executed: 1 of 11<br>
---------------[ Tue, 25 Nov 2008 15:04:34 -0200 (PID: 28543) ]---------------
---------------[ Tue, 25 Nov 2008 15:06:31 -0200 (PID: 28598) ]---------------
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: AddPayPeriod Previous Scheduled Date: Tue, 25 Nov 2008 00:00:00 -0200(1227578400) Last Run Time: Tue, 25 Nov 2008 15:03:00 -0200(1227632580) Current Epoch: 1227632791<br>
DEBUG [473]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is NOT scheduled to run right now...<br>
DEBUG [467]:	<b>CronJobFactory::isScheduledToRun()</b>:  Name: TimeClockSync Previous Scheduled Date: Tue, 25 Nov 2008 15:06:00 -0200(1227632760) Last Run Time: Tue, 25 Nov 2008 15:05:00 -0200(1227632700) Current Epoch: 1227632791<br>
DEBUG [470]:	<b>CronJobFactory::isScheduledToRun()</b>:   JOB is SCHEDULED TO RUN NOW!<br>
DEBUG [332]:	<b>CronJobFactory::getSystemLoad()</b>:  Load Average: 2.27<br>
DEBUG [350]:	<b>CronJobFactory::isSystemLoadValid()</b>:  Load average within valid limits: Current: 2.27 Max: 9999<br>
DEBUG [534]:	<b>CronJobFactory::Execute()</b>: Job is NOT currently running, running now...<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 20<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [815]:	<b>Factory::Save()</b>:  Updating...<br>
DEBUG [640]:	<b>Factory::getUpdateQuery()</b>: Update<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632791 Converted Value: 1227632791<br>
DEBUG [671]:	<b>Factory::getUpdateQuery()</b>: Data changed, set updated date: <br>
DEBUG [853]:	<b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [69]:	<b>Factory::removeCache()</b>: Attempting to remove cache: 11<br>
DEBUG [75]:	<b>Factory::removeCache()</b>: Removing cache: 11 Group Id: cron<br>
DEBUG [736]:	<b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [555]:	<b>CronJobFactory::Execute()</b>: WARNING: File does not exist, skipping: /var/www/timetrex/maint/TimeClockSync.php<br>
DEBUG [98]:	<b>Validator::inArrayKey()</b>: Key: 10<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632820 Converted Value: 1227632820<br>
DEBUG [726]:	<b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [772]:	<b>Factory::Save()</b>: Calling preSave()<br>
DEBUG [815]:	<b>Factory::Save()</b>:  Updating...<br>
DEBUG [640]:	<b>Factory::getUpdateQuery()</b>: Update<br>
DEBUG [358]:	<b>Validator::isDate()</b>: Raw Date: 1227632791 Converted Value: 1227632791<br>
DEBUG [671]:	<b>Factory::getUpdateQuery()</b>: Data changed, set updated date: <br>
DEBUG [853]:	<b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [69]:	<b>Factory::removeCache()</b>: Attempting to remove cache: 11<br>
DEBUG [75]:	<b>Factory::removeCache()</b>: Removing cache: 11 Group Id: cron<br>
DEBUG [736]:	<b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [60]:	<b>[Function]()</b>: CRON: Jobs Executed: 1 of 11<br>
---------------[ Tue, 25 Nov 2008 15:06:31 -0200 (PID: 28598) ]---------------
but the issue of the pay stub still :(

what relation have pay stub with that folders?
what permisions have to grant to what folders and files?
the first think i do in ubuntu is install a new copy of timetrex to be sure of the requirements, and are fine.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

now i will install the 2.2.16 to view if the issu magicly be fixed
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

issue persist, i make all folders relationed with timetrex 777

help!!
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

the number of error in the acrobat reader its '110'
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i find out this:
http://www.quickpdf.org/forum/forum_posts.asp?TID=326

its says that this error code was cause by fonts
i think cause i'm on ubuntu and i dont have some of the fonts expected by the pdf

it's this posible? cause they say that the version 5 work fine, and i test the version 4 of acrobat and still the same error.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i fix the error 110 in windows using foxit reader, but the pay stub sill blank page :(

i will try to put the fonts of windows on ubuntu
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

:( the fonts dont make any change :(
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

I doubt its a font issue. Are there any errors appearing in the TimeTrex log file when you try to view the pay stub now?
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i dont see any log when i try to view a pay stub

if this a problem of tmp cahe log etc, can i disable that thinks?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Check your PHP error log as well. There may be a fatal error occurring that is logged to that.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

any error in error_log

there is no error log, i have to make a script with a bad php code for generate the error_log

another solution?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

There is some error that is occurring if it works in Windows but not in Linux. Unfortunately without any sort of error logs it makes it extremely difficult to troubleshoot.

You could try disabling the cache in your timetrex.ini.php file to see if that makes a difference.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i will try tomorow at work, thanks
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

if i set:
;
; Cache settings
;
[cache]
enable = FALSE
;Linux
dir = /tmp/timetrex

the timetrex make folders in /tmp/ with adodb files

can you tell me everithing i had to install for timetrex? maibe the installer dont check everything

regards
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i dont have adodb installed, i installed but still blank pay stub
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

System Linux servidor 2.6.27-7-generic #1 SMP Tue Nov 4 19:33:20 UTC 2008 i686
Build Date Oct 14 2008 19:43:47
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php5/apache2
Loaded Configuration File /etc/php5/apache2/php.ini
Scan this dir for additional .ini files /etc/php5/apache2/conf.d
additional .ini files parsed /etc/php5/apache2/conf.d/adodb.ini, /etc/php5/apache2/conf.d/gd.ini, /etc/php5/apache2/conf.d/mcrypt.ini, /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Try going to the Pay Stub List page, then modify: interface/pay_stub/PayStubList.php

Around line 162 you will see:

Code: Select all

        case 'view':
                //Debug::setVerbosity(11);
Remove the "//" in front of the Debug line.

Save the file then press view beside the pay stub that is coming up blank. This should show you a bunch of debug text, copy and paste that here.
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

/tmp/e4/adodb_e488e80b1fe712edd3b20b1ce6347806.cache reloaded, ttl=79809 [ select * from pay_stub where id = -1 ]
(mysqlt): select a.* from pay_stub as a LEFT JOIN users as b ON a.user_id = b.id where b.company_id = '1' AND a.id in ('419') AND ( a.deleted = 0 AND b.deleted = 0 ) order by transaction_date desc (mysqlt): select * from pay_period where id = '3' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 /tmp/e7/adodb_e797f8857d918598a5ad8393da09cbce.cache reloaded, ttl=79814 [ select * from pay_stub_entry where id = -1 ]
(mysqlt): 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 ERROR: Pay stub not available, you may not have permissions to view this pay stub or it may be deleted!

Code: Select all

	case 'view':
		Debug::setVerbosity(11);
		Debug::Text('aAction: View!', __FILE__, __LINE__, __METHOD__,10);
		if ( isset($id) AND !isset($ids) ) {
			$ids = array($id);
		}

		if ( count($ids) == 0 ) {
			echo TTi18n::gettext("ERROR: No Items Selected!")."<br>\n";
			exit;
		}

		if ( count($ids) > 0 ) {
			$pslf = new PayStubListFactory();

			if ( $permission->Check('pay_stub','view') == FALSE ) {
				if ( $permission->Check('pay_stub','view_child') ) {
					$filter_data['permission_children_ids'] = $permission_children_ids;
				}
				if ( $permission->Check('pay_stub','view_own') == TRUE ) {
					$filter_data['permission_children_ids'][] = $current_user->getId();
				}
			}

			$filter_data['id'] = $ids;

			$pslf->getSearchByCompanyIdAndArrayCriteria( $current_company->getId(), $filter_data );

			$output = $pslf->getPayStub( $pslf, (bool)$hide_employer_rows );

			if ( $output !== FALSE AND Debug::getVerbosity() < 11 ) {
				Misc::FileDownloadHeader('pay_stub.pdf', 'application/pdf', strlen($output));
				echo $output;
				exit;
			} else {
				echo TTi18n::gettext("ERROR: Pay stub not available, you may not have permissions to view this pay stub or it may be deleted!")."<br>\n";
				exit;
			}
		}

		break;
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

ERROR: Pay stub not available, you may not have permissions to view this pay stub or it may be deleted!
I have to believe that statement is accurate at this point. The question is which is it...

What is the output if you run this query from the MySQL console:
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
I'm still seeing ADODB caching in use... Have you tried removing all the cache files in /tmp?
arcolen
Posts: 57
Joined: Mon Nov 03, 2008 6:49 am

Post by arcolen »

i will try tomorow at work

i enable the cache again, tomorow i will disable and test it

thanks
Locked