ProjeQtOr free project management software - Deliveries windows empty - ProjeQtOr
 

Deliveries windows empty

More
23 Aoû 2019 13:24 - 23 Aoû 2019 13:24 #1 by karl.binet
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
Attachments:
Last edit: 23 Aoû 2019 13:24 by karl.binet.

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 15:01 #2 by babynus
Replied by babynus on topic Deliveries windows empty
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 ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 15:24 #3 by karl.binet
Replied by karl.binet on topic Deliveries windows empty
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
Attachments:

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 15:31 #4 by babynus
Replied by babynus on topic Deliveries windows empty
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.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: karl.binet

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 15:37 #5 by karl.binet
Replied by karl.binet on topic Deliveries windows empty
Great, everything is back to normal

Thanks for your help.

Regards

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.226 seconds