View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Delivery doesn't appear in list after saving - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

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

More
20 Sep 2018 16:22 - 20 Sep 2018 16:25 #1 by louisc
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]
Attachments:
Last edit: 20 Sep 2018 16:25 by louisc.

Please Connexion or Create an account to join the conversation.

More
21 Sep 2018 09:20 #2 by babynus
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".

Babynus
Administrator of ProjeQtOr web site
Attachments:

Please Connexion or Create an account to join the conversation.

More
21 Sep 2018 15:46 #3 by louisc
Hi Pascal,

This works thank you !

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.054 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.