Problem with ticket module installation

avatar virtualmissfriday Pro Apr 24. 2009. 6:46 am #1
Just went to install the tickets module on an upgrade from small biz to corp, and when I clicked install the ticket module tab disappeared completely :-(

Any idea how I can get this back?
avatar virtualmissfriday Pro Apr 24. 2009. 7:24 am #2
The same things is happening with all modules accept for docs - this is the only one which installed correctly
avatar Ilija Studen Staff Apr 24. 2009. 7:30 am #3
This looks like an upgrade issue. Please make sure that you delete all %% files from /compile folder and cch_ files from /cache folder and try again.
Follow @activecollab and activeCollab on Facebook.
avatar virtualmissfriday Pro Apr 24. 2009. 12:46 pm #4
I did it and got this message:

Query failed with message 'Can't DROP 'parent_id'; check that column/key exists'
Error params:
File: NULL
Line: NULL
Sql: alter table acx_status_updates drop parent_id
Error number: 1091
Error message: Can't DROP 'parent_id'; check that column/key exists
Backtrace:

#0 Error->__construct(Query failed with message 'Can't DROP 'parent_id'; check that column/key exists', 1) called at [/home/ehvdervu/public_html/office/activecollab/angie/classes/errors/DBQueryError.class.php:57]
#1 DBQueryError->__construct(alter table acx_status_updates drop parent_id, 1091, Can't DROP 'parent_id'; check that column/key exists) called at [/home/ehvdervu/public_html/office/activecollab/angie/classes/database/DBConnection.class.php:240]
#2 DBConnection->prepareAndExecute(alter table acx_status




avatar Ilija Studen Staff Apr 24. 2009. 2:48 pm #5
When you cleared %% and cch_ files, there is no need to run the upgrade script again - your database is already up to date. Instead, just continue using the system.
Follow @activecollab and activeCollab on Facebook.