Recently I discovered dotProject. Not so cool looking as much as cool working application written in PHP for project managment. Have a look at this article.
If you experience problems with PHP errors at Files menu after installing the application here is what you might do to fix it.
Open the /modules/files/index_table.php file and somwere around line 105 you will find the code that’s causing the error. Just replace it like
/*
ORIGINAL CODE
$r->addQuery(‘DISTINCT count(f.file_id) as file_versions’
. ‘, max(DISTINCT f.file_version) as file_lastversion’
. ‘, f.file_version_id, f.file_project’);
*/
/* MODIFIED CODE */
$r->addQuery(‘DISTINCT count(f.file_id) as file_versions’
. ‘, max(f.file_version) as file_lastversion’
. ‘, f.file_version_id, f.file_project’);
Do the same replacement for folders_table.php file around line 280.
After that, your Files tab should work.
One notice, i experienced this problem on my live hosting, not on my local machine.