Click on the "Punches" and show a blank white page

chris · Post by **chris** » Mon Mar 16, 2009 9:44 pm

Here is the path of URL:
http://domain/timetrex/interface/punch/PunchList.php

When I click the "Punches" under "Timesheet", it show a blank white page, is it normal?

Post by **shaunw** » Tue Mar 17, 2009 8:04 am

Please see this FAQ entry:
http://forums.timetrex.com/viewtopic.php?t=89

chris · Post by **chris** » Tue Mar 31, 2009 3:08 am

Dear Shauw,

I've found both of "punches" and "Scheduled Shifts" is not working properly in v2.2.19 and v2.2.20 (v2.2.18 is okay), base on the following environment:

Cent OS 5.2
httpd 2.2.3
php 5.1.6
mysql 5.0.45

Below is the error_log of httpd:

Code: Select all

[Tue Mar 31 17:48:30 2009] [error] [client 192.168.1.47] PHP Fatal error:  Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 12] in EXECUTE("SELECT COUNT(*) FROM \tpunch as a\n\t\t\t\t\t\t\tLEFT JOIN punch_control as b ON a.punch_control_id = b.id\n\t\t\t\t\t\t\tLEFT JOIN user_date as c ON b.user_date_id = c.id\n\t\t\t\t\t\t\tLEFT JOIN users as d ON c.user_id = d.id\n\t\t\t\t\t\t\tLEFT JOIN station as e ON a.station_id = e.id\n\t\t\t\t\t\t\tLEFT JOIN user_wage as z ON z.id = (select z.id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom user_wage as z\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere z.user_id = c.user_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand z.effective_date <= c.date_stamp\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand z.deleted = 0\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t LiMiT 1)\n\t\t\t\t\t\tWHERE d.company_id = '1'\n\t\t\t\t\t\tAND (a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 AND d.deleted = 0)\n\t\t\t\t\t order by time_stamp desc,c.pay_period_id asc,c.user_id asc,a.time_stamp asc,a.punch_control_id asc,a.status_id desc LiMiT 1 LIMIT 1")\n' in /var/www/htm in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://192.168.1.48/222/interface/timesheet/ViewUserTimeSheet.php

[Tue Mar 31 17:49:15 2009] [error] [client 192.168.1.47] PHP Fatal error:  Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 10] in EXECUTE("SELECT COUNT(*) FROM \tschedule as a\n\t\t\t\t\t\t\tLEFT JOIN user_date as c ON a.user_date_id = c.id\n\t\t\t\t\t\t\tLEFT JOIN users as d ON c.user_id = d.id\n\t\t\t\t\t\t\tLEFT JOIN user_wage as z ON z.id = (select z.id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom user_wage as z\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere z.user_id = c.user_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand z.effective_date <= c.date_stamp\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand z.deleted = 0\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t limit 1)\n\t\t\t\t\t\tWHERE d.company_id = '1'\n\t\t\t\t\t\tAND (a.deleted = 0 AND c.deleted = 0 AND d.deleted = 0)\n\t\t\t\t\t order by start_time desc,a.start_time asc,a.status_id asc limit 1 LIMIT 1")\n' in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/html/222/classes/adodb/adodb.inc.php(1042): adodb_throw('mysqlt', 'EXECUTE', 1064, 'You have an err...', 'SELECT COUNT in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://192.168.1.48/222/interface/accrual/UserAccrualBalanceList.php

Thanks in advance.

Post by **shaunw** » Tue Mar 31, 2009 8:32 am

Change your database type from "mysqlt" to "mysqli" in your TimeTrex.ini.php file. Also make sure that the PHP MySQLi extension is installed first.

chris · Post by **chris** » Wed Apr 01, 2009 2:59 am

shaunw wrote:Change your database type from "mysqlt" to "mysqli" in your TimeTrex.ini.php file. Also make sure that the PHP MySQLi extension is installed first.

I'm already change the settings in Timetrex.ini.php, also re-create the database for installation, BUT it's fail at the step three(Database Configuration), the warning said innodb dose not support in my database, is there any missing settings for mysqli in my server? It can work normaly before change to mysqli.

Could you please provide some clear steps for this?

Post by **shaunw** » Wed Apr 01, 2009 7:47 am

You only need to change the setting in your timetrex.ini.php file, you don't need to reinstall at all.

However it sounds like you have already done that, so carry out the installation with "mysqlt" driver, and once that is done, change it to "mysqli" in the timetrex.ini.php file.

chris · Post by **chris** » Wed Apr 01, 2009 9:01 pm

shaunw wrote:You only need to change the setting in your timetrex.ini.php file, you don't need to reinstall at all.

However it sounds like you have already done that, so carry out the installation with "mysqlt" driver, and once that is done, change it to "mysqli" in the timetrex.ini.php file.

Tried, both of "mysqlt" and "mysqli" gets blank page after login...

Code: Select all

[Thu Apr 02 11:55:10 2009] [error] [client 192.168.1.47] PHP Fatal error:  Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1146: Table 'worldex.users' doesn't exist] in EXECUTE("\n\t\t\t\t\tselect \t*\n\t\t\t\t\tfrom\tusers\n\t\t\t\t\twhere\tuser_name = 'admin'\n\t\t\t\t\t\tAND deleted = 0")\n' in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/html/222/classes/adodb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 1146, 'Table 'worldex....', '??????select ?*...', false, Object(ADODB_mysqli))\n#1 /var/www/html/222/classes/adodb/adodb.inc.php(998): ADOConnection->_Execute('??????select ?*...')\n#2 /var/www/html/222/classes/modules/users/UserListFactory.class.php(200): ADOConnection->Execute('??????select ?*...', Array)\n#3 /var/www/html/222/classes/modules/core/Authentication.class.php(196): UserListFactory->getByUserName('admin')\n#4 /var/www/html/222/classes/modules/core/Authentication.class.php(474): Authentication->checkCompanyStatus('admin')\n#5 /var/www/html/222/interface/Login.php(55): Authentication->Login('admin', 'hkcg0173')\n#6 {main}\n  thrown in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://192.168.1.48/222/interface/Login.php

[Thu Apr 02 11:56:44 2009] [error] [client 192.168.1.47] PHP Fatal error:  Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1146: Table 'worldex.users' doesn't exist] in EXECUTE("\n\t\t\t\t\tselect \t*\n\t\t\t\t\tfrom\tusers\n\t\t\t\t\twhere\tuser_name = 'admin'\n\t\t\t\t\t\tAND deleted = 0")\n' in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/html/222/classes/adodb/adodb.inc.php(1042): adodb_throw('mysqlt', 'EXECUTE', 1146, 'Table 'worldex....', '??????select ?*...', false, Object(ADODB_mysqlt))\n#1 /var/www/html/222/classes/adodb/adodb.inc.php(998): ADOConnection->_Execute('??????select ?*...')\n#2 /var/www/html/222/classes/modules/users/UserListFactory.class.php(200): ADOConnection->Execute('??????select ?*...', Array)\n#3 /var/www/html/222/classes/modules/core/Authentication.class.php(196): UserListFactory->getByUserName('admin')\n#4 /var/www/html/222/classes/modules/core/Authentication.class.php(474): Authentication->checkCompanyStatus('admin')\n#5 /var/www/html/222/interface/Login.php(55): Authentication->Login('admin', 'hkcg0173')\n#6 {main}\n  thrown in /var/www/html/222/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://192.168.1.48/222/interface/Login.php

chris · Post by **chris** » Wed Apr 01, 2009 10:11 pm

Just drop the database and start form zero again, still get the blank page after change to "mysqli"

Code: Select all

[Thu Apr 02 13:05:17 2009] [error] [client 192.168.1.47] PHP Fatal error:  Factory::getRecordCount() [<a href='function.Factory-getRecordCount'>function.Factory-getRecordCount</a>]: The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "ADORecordSet_mysqlt" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition  in /var/www/html/worldex/classes/modules/core/Factory.class.php on line 408, referer: http://192.168.1.48/worldex/interface/Login.php

Post by **shaunw** » Thu Apr 02, 2009 11:03 am

Anytime you change your database type, you will need to clear your TimeTrex cache directory. You can do this manually or re-run the installer to the System Requirements page (no further).

chris · Post by **chris** » Tue Apr 07, 2009 11:48 pm

It's okay now, many thanks!

ravis007 · Post by **ravis007** » Tue Sep 15, 2009 5:48 am

But I have installed timetrex manually.
I am using mysql for timetrex.

Where is the cache directory located in timetrex when installed manually.

But when I moved timetrex directory & database also from one machine to another, it gives login error.

I can't login into it. And my apache error logs are like -

------------------------------------------------------------------------------------

[Tue Sep 15 23:18:14 2009] [error] [client 172.26.3.94] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1033: Incorrect information in file: './timetrex/users.frm'] in EXECUTE("\n\t\t\t\t\tselect \t*\n\t\t\t\t\tfrom\tusers\n\t\t\t\t\twhere\tuser_name = 'anil'\n\t\t\t\t\t\tAND deleted = 0")\n' in /var/www/html/hrm/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/html/hrm/classes/adodb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 1033, 'Incorrect infor...', '??????select ?*...', false, Object(ADODB_mysqli))\n#1 /var/www/html/hrm/classes/adodb/adodb.inc.php(998): ADOConnection->_Execute('??????select ?*...')\n#2 /var/www/html/hrm/classes/modules/users/UserListFactory.class.php(200): ADOConnection->Execute('??????select ?*...', Array)\n#3 /var/www/html/hrm/classes/modules/core/Authentication.class.php(196): UserListFactory->getByUserName('anil')\n#4 /var/www/html/hrm/classes/modules/core/Authentication.class.php(474): Authentication->checkCompanyStatus('anil')\n#5 /var/www/html/hrm/interface/Login.php(55): Authentication->Login('anil', '123456')\n#6 {main}\n in /var/www/html/hrm/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://172.26.3.103/hrm/interface/Login.php

-------------------------------------------------------------------------------------

And when I do "select * from users" table it gives error like -

mysql> select * from users;
ERROR 1033 (HY000): Incorrect information in file: './timetrex/users.frm'

How to resolve this error.
Please Help.

Post by **shaunw** » Tue Sep 15, 2009 8:28 am

mysql> select * from users;
ERROR 1033 (HY000): Incorrect information in file: './timetrex/users.frm'

This is a MySQL issue, your tables appear to be corrupt, I recommend posting this question in a MySQL forum as they would be able to offer you proper solutions.

TimeTrex Time and Attendance

Click on the "Punches" and show a blank white page

Click on the "Punches" and show a blank white page

Time and Attendance