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.
I downgrade to 6.4.4, all it works...
It looks like you run code of V6.5 with db structure of V6.4
but when I upgrade to 6.5, the db structure don't update in the same time ?
It doesn't check consistence of db. It looks like recent changes are applied only. Dependant on first version you installed you might be missing one or multiple tables and / or fields.
See https://www.projeqtor.org/en/forum/2-submit-issues/8839-db-inconsitent-between-versions-because-of-errors-in-sql
where I tried to explain it and how I fixed it to get a picture of reason for errors in log file.
cu, diri
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.
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.
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]')
Issue recorded as Ticket #3138
On first quick attempt, I could not reproduce.
Can you please try again after cleaning browser cache ?
If issue still occurs, please ;
- indicate version of Kanban
- try and reproduce on Demo so that we have dedicated use case.
Kanban V3.4
Clean cache ok, same error message...
try to reproduce on demo base, all it's fine, not my problem...
Can you please add console.log before lines 104 and 153 of projeqtor/plugin/kanban/kanban.js, this way :
console.log(data);
dojo.byId('divPrincItem'+id).innerHTML=splitData[1].split('[splitcustom2]')[0];
Then clear browser cache, test again and post contednt of browser console.
Thanks in advance.
Thanks for the information.
Note added on Ticket #3138