Database Error: Table does not exist 'job_item_group_tree'

[DeschChris]

hi all,

after installing version 1.4.0 on FC6 already seems to be okay , but after i added an employee_group and tried to edit the group i got following error:

-- snipp --
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1146: Table 'timetrex.job_item_group_tree' doesn't exist] in EXECUTE(" SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM job_item_group_tree a LEFT JOIN job_item_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 ") ' in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/html/timetrex/classes/adodb/adodb.inc.php(886): adodb_throw('mysqlt', 'EXECUTE', 1146, 'Table 'timetrex...', '?SELECT a.objec...', false, Object(ADODB_mysqlt)) #1 /var/www/html/timetrex/classes/adodb/adodb.inc.php(842): ADOConnection->_Execute('?SELECT a.objec...') #2 /var/www/html/timetrex/classes/adodb/adodb.inc.php(1418): ADOConnection->Execute('?SELECT a.objec...', Array) #3 /var/www/html/timetrex/classes/modules/core/Fa in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php on line 78
--- snipp ---


it seems that the table "job_item_group_tree" does not exist. after checking the database (mysql) i cannot find any table entry called "job_*" .... ???

i got no error installing the database at the installation-process.

thx for your help

[shaunw]

Edit interface/users/EditUserGroup.php

Change line 84 from:

Code: Select all

$ft = new FastTree( $fast_tree_job_item_group_options );

To:

Code: Select all

$ft = new FastTree( $fast_tree_user_group_options );

I'm told this bug will be fixed in TimeTrex v1.4.1.