View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - closed Ticket - 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)

 

 

 

closed Ticket

More
11 Déc 2017 12:29 #1 by Durou C
closed Ticket was created by Durou C
I can't close ticket and modify the result...

I have got this error message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idAccountable' in 'field list'

in log file:


2017-12-11 12:22:57.832 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.837 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.889 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.892 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.892 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.893 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.894 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.897 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.900 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.927 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:57.933 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.760 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.764 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.814 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.821 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.822 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.825 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.828 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.831 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.832 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idAccountable' in 'field list'
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] For query : update ticket set idStatus='19' , idAccountable='30' , idle='1' , idleDateTime='2017-12-11 12:20:00' , lastUpdateDateTime='2017-12-11 12:22:59' where id=149
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1412]
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:923]
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:619]
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/var/www/projeqtor/model/TicketMain.php:401]
2017-12-11 12:22:59.837 ***** ERROR ***** [V6.5.0] #4 TicketMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]
2017-12-11 12:23:00.003 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.417 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.420 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.471 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.473 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.473 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.474 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.475 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.477 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.479 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.
2017-12-11 12:25:07.500 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idAccountable' for Class 'Ticket' : field 'idAccountable' not found in Database.

Please Connexion or Create an account to join the conversation.

More
11 Déc 2017 16:02 #2 by Durou C
Replied by Durou C on topic closed Ticket
I downgrade to 6.4.4, all it works...

Please Connexion or Create an account to join the conversation.

More
11 Déc 2017 16:56 #3 by babynus
Replied by babynus on topic closed Ticket
It looks like you run code of V6.5 with db structure of V6.4

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
11 Déc 2017 17:00 #4 by Durou C
Replied by Durou C on topic closed Ticket
but when I upgrade to 6.5, the db structure don't update in the same time ?

Please Connexion or Create an account to join the conversation.

More
12 Déc 2017 10:16 #5 by babynus
Replied by babynus on topic closed Ticket
Remind of migration process:
- overwrite existing code with new one (do not install on new folder)
- reconnect as admin to finalize migration

If it is what you did, please post log file corresponding to upgrade process.
Thanks.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
12 Déc 2017 10:19 #6 by Durou C
Replied by Durou C on topic closed Ticket
I did this it's ok now...

but I have another problem.

In Kanban, when I drop activité finished to closed I have this message:

TypeError: null is not an object (evaluating 'dojo.byId('divPrincItem'+id).innerHTML=splitData[1].split('[splitcustom2]')[0]')
Contactez votre administrateur
(l'erreur détaillée est consignée dans le fichier de log)

and nothing in log file.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.045 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.