If you get this error while installing Reports module, you are running an old version of MySQL (earlier than MySQL 5). Reports module requires at least MySQL 5 since it uses views on activeCollab tables to pull ticket categories and activity levels.

Error
Error (DBQueryError)
Query failed with message '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 'VIEW IF EXISTS `acx_view_ticket_categories`' at line 1'
Error params:
File: NULL
Line: NULL
Sql: DROP VIEW IF EXISTS `acx_view_ticket_categories`
Error number: 1064
Error message: 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 'VIEW IF EXISTS `acx_view_ticket_categories`' at line 1
Backtrace:


#0 Error->__construct(Query failed with message '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 'VIEW IF EXISTS `acx_view_ticket_categories`' at line 1', 1) called at [/yourserver.com/activecollab/angie/classes/errors/DBQueryError.class.php:57]

Solution
Upgrade to MySQL 5+.