View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - closed Ticket - ProjeQtOr
 

closed Ticket

More
11 Dec 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 Log in or Create an account to join the conversation.

More
11 Dec 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 Log in or Create an account to join the conversation.

More
11 Dec 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 Log in or Create an account to join the conversation.

More
11 Dec 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 Log in or Create an account to join the conversation.

More
12 Dec 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 Log in or Create an account to join the conversation.

More
12 Dec 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 Log in or Create an account to join the conversation.

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