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

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

V2.0 Error on SqlElement

More
16 Fév 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 Connexion or Create an account to join the conversation.

More
16 Fév 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 Connexion or Create an account to join the conversation.

More
16 Fév 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 Connexion or Create an account to join the conversation.

More
16 Fév 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 Connexion or Create an account to join the conversation.

More
22 Fév 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 Connexion or Create an account to join the conversation.

More
22 Fév 2012 16:34 #6 by babynus
Sent it at Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.064 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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