Did you install V2.0 on a previous version ?
If so, you must disconnect and reconnect as admin, to run the database updates.

no it's a new installation.
we have installed same version on windows 2003 and I had doing a database dump from windows to unix. No error is appeared on export / import.
but on windows 2003 we already have this :

2012-02-16 13:29:41 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database.
2012-02-16 13:31:39 ===== TRACE ===== DISCONNECTED USER 'fdoucet'
2012-02-16 13:31:45 ===== TRACE ===== NEW CONNECTED USER 'fdoucet'
2012-02-16 13:32:04 ===== TRACE ===== DISCONNECTED USER 'fdoucet'
2012-02-16 13:32:15 ===== TRACE ===== NEW CONNECTED USER 'admin'
2012-02-16 13:32:40 ===== TRACE ===== DISCONNECTED USER 'admin'
2012-02-16 13:32:45 ===== TRACE ===== NEW CONNECTED USER 'admin'
2012-02-16 13:34:18 ===== TRACE ===== DISCONNECTED USER 'admin'
2012-02-16 13:34:24 ===== TRACE ===== NEW CONNECTED USER 'fdoucet'
2012-02-16 13:38:28 ** ERROR ** [1064] Erreur SQL : 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 ' 1, 2, 11) order by activityplanningelement.wbsSortable , activity.id desc' at line 1

select activity.id as id, T1.name as nameProject, T2.name as nameActivityType, activityplanningelement.wbsSortable as wbsSortable, activity.name as name, activityplanningelement.validatedEndDate as validatedEndDate, activityplanningelement.plannedEndDate as plannedEndDate, convert(concat(T3.sortOrder,'#split#',T3.name,'#split#',T3.color) using utf8) as colorNameStatus, T4.fullName as nameResource, activity.handled as handled, activity.done as done, activity.idle as idle from activity left join project as T1 on activity.idProject = T1.id left join type as T2 on activity.idActivityType = T2.id left join planningelement as activityplanningelement on (activityplanningelement.refId=activity.id and activityplanningelement.refType='Activity') left join status as T3 on activity.idStatus = T3.id left join user as T4 on activity.idResource = T4.id where activity.idle=0 and ( activity.idProject in (2, 3, 4, 5, 6, 7) ) and activity.idStatus IN ( , 1, 2, 11) order by activityplanningelement.wbsSortable , activity.id desc
2012-02-16 13:39:04 ** ERROR ** [1064] Erreur SQL : 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 ' 1, 2, 11) order by activityplanningelement.wbsSortable , activity.id desc' at line 1

select activity.id as id, T1.name as nameProject, T2.name as nameActivityType, activityplanningelement.wbsSortable as wbsSortable, activity.name as name, activityplanningelement.validatedEndDate as validatedEndDate, activityplanningelement.plannedEndDate as plannedEndDate, convert(concat(T3.sortOrder,'#split#',T3.name,'#split#',T3.color) using utf8) as colorNameStatus, T4.fullName as nameResource, activity.handled as handled, activity.done as done, activity.idle as idle from activity left join project as T1 on activity.idProject = T1.id left join type as T2 on activity.idActivityType = T2.id left join planningelement as activityplanningelement on (activityplanningelement.refId=activity.id and activityplanningelement.refType='Activity') left join status as T3 on activity.idStatus = T3.id left join user as T4 on activity.idResource = T4.id where activity.idle=0 and ( activity.idProject in (2, 3, 4, 5, 6, 7) ) and activity.idStatus IN ( , 1, 2, 11) order by activityplanningelement.wbsSortable , activity.id desc
2012-02-16 13:43:47 ** ERROR ** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database.

thanks

eric

Can you retrive the fist log, when you deployed the application.
There must be detailed trace of all updates, and there should be an error.

Hi babynus,
How can I post zip file whith logs file
Eric

Sent it at support@toolware.fr