View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - V2.0 Error on SqlElement - ProjeQtOr
 
 

V2.0 Error on SqlElement

More
16 Feb 2012 20:31 #1 by ericg
Hi,
I have just install V2.0 on unix system and when i try to get Planning screen it's very long and i have this error in log file :
2012-02-16 19:54:53 ***** ERROR ***** Error on SqlElement to get 'idBill' for Class 'PlannedWork' : field 'idBill' not found in Database.
We have created some activity and we want to try calculating the planning.

Thanks for you help

regards,
Eric

Please Log in or Create an account to join the conversation.

More
16 Feb 2012 21:23 #2 by babynus
Did you install V2.0 on a previous version ?
If so, you must disconnect and reconnect as admin, to run the database updates.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Feb 2012 22:02 #3 by ericg
Replied by ericg on topic RE : V2.0 Error on SqlElement
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<br/><br/>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<br/><br/>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

Please Log in or Create an account to join the conversation.

More
16 Feb 2012 22:18 #4 by babynus
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
22 Feb 2012 15:51 #5 by ericg
Replied by ericg on topic RE : V2.0 Error on SqlElement
Hi babynus,
How can I post zip file whith logs file
Eric

Please Log in or Create an account to join the conversation.

More
22 Feb 2012 16:34 #6 by babynus
Sent it at This email address is being protected from spambots. You need JavaScript enabled to view it.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.066 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.