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

/* 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.