Forum

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.

[SOLVED] Delivery d...
 
Notifications
Clear all

[SOLVED] Delivery doesn't appear in list after saving

3 Posts
2 Users
0 Reactions
2,553 Views
(@louisc)
Posts: 58
Active Member
Topic starter
 
[#5439]

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]

 
Posted : 20 Sep 2018 18H22
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

In V7.1 we split deliverable types and delivery types.
So columns name idDeleverableType was changed to idDeliveryType.
Then you need to reset list disposition
- click on button "select columnt to display"

- click on button "reset".


 
Posted : 21 Sep 2018 11H20
(@louisc)
Posts: 58
Active Member
Topic starter
 

Hi Pascal,

This works thank you !


 
Posted : 21 Sep 2018 17H46
Share:

Scroll to Top