Abyss X2 2.5
PHP 5.2.4
PEAR 1.7.1
MySQL 5.1.22
TimeTrex SE 2.2.6
After a successful install, we login as the admin user created during setup. Once logged in, we are notified that this is our first time logging in and we need to fill out the following information. We will fill out the required items, marked with asterisks, and click submit. We are then taken to the Recent Activity Summary. If we click on any navigation link, it brings us back to the edit user form as if we never filled any of the required data in. Any ideas? See dump below of the submit event...
Code: Select all
--------------------------------------------------------------------------------
(mysqlt): SET SESSION sql_mode='ansi'
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SET SESSION time_zone='America/Denver'
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = '5845a34d66aa8e7b597b622a64f1474c' AND ip_address = '192.168.100.32' AND updated_date >= 1204924597
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): update authentication set updated_date = 1204938997 where session_id = '5845a34d66aa8e7b597b622a64f1474c'
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SET SESSION time_zone='US/Arizona'
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select * from station where company_id = '1' AND station_id = '31694d9cc7b698bd5200ce46f885f944' 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-03-07' 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
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select name FROM bread_crumb WHERE user_id = '1' AND name = 'Employee List' LIMIT 1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): UPDATE bread_crumb SET url = '/timetrex/interface/users/UserList.php', created_date = 1204938997 WHERE user_id = '1' AND name = 'Employee List'
--------------------------------------------------------------------------------
d:\timetrex\temp\/3b/adodb_3b36094360e60c1880e87148d5d4fcf6.cache reloaded, ttl=84572 [ select * from user_generic_data where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): select * from user_generic_data where user_id = '1' AND script = '/timetrex/interface/users/UserList.php' AND is_default = 1 AND deleted = 0 order by updated_date desc
--------------------------------------------------------------------------------
d:\timetrex\temp\/0e/adodb_0e9afd8cfc1db9db627f8c51a5b08c65.cache reloaded, ttl=84572 [ select * from users where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): SELECT COUNT(*) FROM users as a LEFT JOIN branch as b ON a.default_branch_id = b.id LEFT JOIN department as c ON a.default_department_id = c.id LEFT JOIN user_group as d ON a.group_id = d.id LEFT JOIN user_title as e ON a.title_id = e.id where a.company_id = '1' AND a.deleted = 0 LIMIT 1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select a.* from users as a LEFT JOIN branch as b ON a.default_branch_id = b.id LEFT JOIN department as c ON a.default_department_id = c.id LEFT JOIN user_group as d ON a.group_id = d.id LEFT JOIN user_title as e ON a.title_id = e.id where a.company_id = '1' AND a.deleted = 0 order by status_id asc,last_name asc,first_name asc LIMIT 0,25
--------------------------------------------------------------------------------
d:\timetrex\temp\/1d/adodb_1d4f0dc4643e63d9e075ed43fc102eaf.cache reloaded, ttl=84572 [ select * from user_title where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): select * from user_title where company_id = '1' AND deleted = 0 order by name asc
--------------------------------------------------------------------------------
d:\timetrex\temp\/e8/adodb_e87823365cf91e7abab08c3b051641b9.cache reloaded, ttl=84572 [ select * from branch where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): select * from branch where company_id = '1' AND deleted = 0 order by name asc
--------------------------------------------------------------------------------
d:\timetrex\temp\/00/adodb_002af0b0267dd7e7fa18315fc82e7ec0.cache reloaded, ttl=84572 [ select * from department where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): select * from department where company_id = '1' AND deleted = 0 order by name asc
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 0 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SELECT object_id FROM user_group_tree WHERE tree_id = '1' AND parent_id = -1 LIMIT 1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = '0' GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SELECT a.object_id, a.parent_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND b.left_id >= '0' AND b.right_id <= '1000' AND a.object_id != '0' GROUP BY a.object_id, a.parent_id, a.left_id ORDER BY a.left_id
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select * from pay_period_schedule as a where company_id = '1' AND deleted=0
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select * from policy_group as a where company_id = '1' AND deleted = 0
--------------------------------------------------------------------------------
d:\timetrex\temp\/3b/adodb_3b36094360e60c1880e87148d5d4fcf6.cache reloaded, ttl=84572 [ select * from user_generic_data where id = -1 ]
--------------------------------------------------------------------------------
(mysqlt): select * from user_generic_data where user_id = '1' AND script = '/timetrex/interface/users/UserList.php' AND deleted = 0 order by is_default desc,name asc
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): select * from system_setting where name = 'license'
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqlt): SELECT name,url FROM bread_crumb WHERE user_id = '1' ORDER BY created_date DESC LIMIT 5
--------------------------------------------------------------------------------
Debug Buffer
============================================================================
Memory Usage: 11881424
----------------------------------------------------------------------------
DEBUG [259]: [Function](): URI: /timetrex/interface/users/UserList.php
DEBUG [261]: [Function](): Version: 2.2.6 Edition: 10 Production: 1 Demo Mode: 0
DEBUG [107]: TTDate::setTimeZone(): Setting TimeZone: America/Denver
DEBUG [497]: Authentication::Check(): Session Name: SessionID
DEBUG [503]: Authentication::Check(): Session ID: 5845a34d66aa8e7b597b622a64f1474c
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:5845a34d66aa8e7b597b622a64f1474c
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:5845a34d66aa8e7b597b622a64f1474c
DEBUG [69]: [Function](): User Authenticated: ldunn Created Date: 1204938671
DEBUG [1957]: UserFactory::isInformationComplete(): User Information is NOT Complete:
DEBUG [107]: TTDate::setTimeZone(): Setting TimeZone: US/Arizona
DEBUG [135]: TTDate::setDateFormat(): Setting Default Date Format: m/d/y
DEBUG [149]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [163]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [101]: [Function](): Locale Cookie: en_US
DEBUG [287]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [109]: [Function](): User Preference Language matches cookie!
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale:
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en
DEBUG [203]: TTi18n::tryLocale(): Found valid windows locale: English_United States.1252 Linux locale: en_US
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale:
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [1957]: UserFactory::isInformationComplete(): User Information is NOT Complete:
DEBUG [138]: [Function](): Station ID Cookie found! 31694d9cc7b698bd5200ce46f885f944
DEBUG [241]: [Function](): UnRead Messages: 0
DEBUG [106]: [Function](): Action:
DEBUG [114] Array: [Function](): Permission Children Ids:
DEBUG [123]: [Function](): Action: submit
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Employee List URL: /timetrex/interface/users/UserList.php
DEBUG [180]: [Function](): Sort Column: last_name
DEBUG [181]: [Function](): Saved Search ID:
DEBUG [214]: [Function](): Users in company only!
DEBUG [342]: FastTree::getAllChildren(): Getting Root ID: 0
DEBUG [1517]: CompanyFactory::getLogoFileName(): Logo File Name: \timetrex\classes\modules\core\..\..\..\\interface\images\timetrex_logo_wbg_small2.jpg
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 44.2290 ms (8.07 %) Authentication::Check()
1 27.6539 ms (5.05 %) Interface.inc - Check for Exceptions
1 33.7138 ms (6.15 %) Interface.inc - Check for UNREAD messages...
6 5.7230 ms (1.04 %) getEmptyRecordSet()
1 14.6148 ms (2.67 %) getPermissionHierarchyChildrenByCompanyIdAndUserId
1 28.6911 ms (5.24 %) setLocale()
1 257.4558 ms (46.99 %) unprofiled
135.8056 ms (24.79 %) Missed
============================================================================
547.8871 ms (100.00 %) OVERALL TIME
============================================================================