Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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
1) Do you have any filter applied on Deliveries screen ?
2) Do you have any error on log file ?
3) If you select a delivery on Global Planning screen, do you see its content ?
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
OK, error is clear, and it's the source of the issue.
On the column selector, jsut click on the Refresh button, to get back to default columns settings.
All should get to normal then.
Great, everything is back to normal
Thanks for your help.
Regards