Table 'timetrex.user_group_tree' doesn't exist

Ask your questions regarding TimeTrex installation here.
Locked
Burhan
Posts: 2
Joined: Sun Feb 04, 2007 8:16 am

Table 'timetrex.user_group_tree' doesn't exist

Post by Burhan »

1146: Table 'timetrex.user_group_tree' doesn't exist

ADOConnection._Execute( 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 JOI...) % line 842, file: adodb.inc.php
ADOConnection.Execute( 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 JOI..., Array[2]) % line 1418, file: adodb.inc.php
ADOConnection.GetRow( 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 JOI..., Array[2]) % line 138, file: FastTree.class.php
FastTree.getNode(0) % line 90, file: FastTree.class.php
FastTree._setupTree() % line 80, file: FastTree.class.php


Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1146: Table 'timetrex.user_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 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 ") ' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\TimeTrex\classes\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\TimeTrex\classes\adodb\adodb.inc.php(886): adodb_throw('mysqlt', 'EXECUTE', 1146, 'Table 'timetrex...', '?SELECT a.objec...', false, Object(ADODB_mysqlt)) #1 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\TimeTrex\classes\adodb\adodb.inc.php(842): ADOConnection->_Execute('?SELECT a.objec...') #2 C:\Program Files\Apache Softwa in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\TimeTrex\classes\adodb\adodb-exceptions.inc.php on line 78


this is what i m getting after my first time login using admin account i made during installation.....
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

It looks like your installation didn't complete successfully. Delete your entire database and try it again.
Burhan
Posts: 2
Joined: Sun Feb 04, 2007 8:16 am

thanx shaun problem resolved

Post by Burhan »

you were right installation was not complete ... because php has a limit of 30 seconds in its php.ini settings.... and it terminated my database script before completion..........
i adjusted it ... now its resolved...

thanx for your help
Locked