Deliveries windows empty

Hi,

V8.1.5

In this first print screen, you can see in global planning that I have many deliveries for a specified project.



But, when i go into the delivery windows, there is no data, the deliveries are missing



Even if i select on top "All projects" the deliveries windows is still empty



I had the same issue in V8.0.6

thanks for your help

Regards

Hi,

1) Do you have any filter applied on Deliveries screen ?

No



2) Do you have any error on log file ?

Oups !! Yes

2019-08-23 09:19:44.148 ***** ERROR ***** [V8.1.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'delivery.idDeliverableType' in 'on clause'
2019-08-23 09:19:44.148 ***** ERROR ***** [V8.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 in (0, 4743) 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='27') ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idUser='27') )) ) order by delivery.id desc
2019-08-23 09:19:44.148 ***** ERROR ***** [V8.1.5] Strack trace :
2019-08-23 09:19:44.148 ***** ERROR ***** [V8.1.5] #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:692]

3) If you select a delivery on Global Planning screen, do you see its content ?

yes



Thank you

Great, everything is back to normal

Thanks for your help.

Regards