Hi,
I tried to use the delivery object, in order to link the deliverables together (and also in the future be able to see the delivery in the planning). I'm still using v7.1.5.
When I saved the delivery, it did not appear on the delivery list. I updated it and saved it again, and still doesn't appear.
I went to deliverables, and then went back to delivery, and the delivery doesn't appear. Where is the object now ?
Here is the log showing the creation and update of the delivery :
And here is the view from the delivery tab :
PS : Here is the error log from the server when trying to display the delivery tab :
2018-09-20 16:23:45.755 ***** ERROR ***** [V7.1.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'delivery.idDeliverableType' in 'on clause'
2018-09-20 16:23:45.755 ***** ERROR ***** [V7.1.5] For query : select delivery.id as id, T1.name as nameProject, T2.name as nameDeliverableType, delivery.name as name, convert(concat(COALESCE(T3.sortOrder,''),'#split#',T3.name,'#split#',COALESCE(T3.color,'')) using utf8) as colorNameDeliverableStatus, convert(concat(COALESCE(T4.sortOrder,''),'#split#',T4.name,'#split#',COALESCE(T4.color,'')) using utf8) as colorNameDeliverableWeight, delivery.plannedDate as plannedDate, delivery.realDate as realDate, delivery.idle as idle, T5.name as nameDeliveryType,delivery.idProject as idproject from delivery left join project as T1 on delivery.idProject = T1.id left join type as T2 on delivery.idDeliverableType = T2.id left join deliverablestatus as T3 on delivery.idDeliverableStatus = T3.id left join deliverableweight as T4 on delivery.idDeliverableWeight = T4.id left join type as T5 on delivery.idDeliveryType = T5.id where delivery.idle=0 and ( (delivery.idProject not in (0) or delivery.idProject is null ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idResource='1') ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idUser='1') ) ) order by delivery.id desc
2018-09-20 16:23:45.755 ***** ERROR ***** [V7.1.5] Strack trace :
2018-09-20 16:23:45.755 ***** ERROR ***** [V7.1.5] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:550]