View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Provider tenders - ProjeQtOr

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Provider tenders

More
02 Déc 2018 10:46 #1 by andyb
Provider tenders was created by andyb
Hi,

I'm using version 7.2.7. If you select the Provider Tenders option then it does not display a list of existing provder tenders. Looking in the error log, I can see

2018-12-02 09:20:37.809 ***** ERROR ***** [V7.2.7] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column tender.totaluntaxedamount does not exist
LINE 1: ...,'') as "colorNameStatus", tender.idle as "idle", tender.tot...
^
2018-12-02 09:20:37.809 ***** ERROR ***** [V7.2.7] For query : select tender.id as "id", T1.name as "nameProject", T2.name as "nameTenderType", tender.name as "name", T3.sortOrder || '#split#' ||T3.name || '#split#' ||COALESCE(T3.color,'') as "colorNameTenderStatus", tender.evaluationValue as "evaluationValue", tender.plannedAmount as "plannedAmount", T4.sortOrder || '#split#' ||T4.name || '#split#' ||COALESCE(T4.color,'') as "colorNameStatus", tender.idle as "idle", tender.totalUntaxedAmount as "totalUntaxedAmount",tender.idProject as idproject from tender left join project as T1 on tender.idProject = T1.id left join type as T2 on tender.idTenderType = T2.id left join tenderstatus as T3 on tender.idTenderStatus = T3.id left join status as T4 on tender.idStatus = T4.id where tender.idle=0 and ( (tender.idProject not in (0) or tender.idProject is null ) and (tender.idProject not in (0) or tender.idProject is null or (tender.idResource='3') ) and (tender.idProject not in (0) or tender.idProject is null or (tender.idUser='3') ) ) order by tender.id desc
2018-12-02 09:20:37.809 ***** ERROR ***** [V7.2.7] Strack trace :
2018-12-02 09:20:37.809 ***** ERROR ***** [V7.2.7] #0 Sql->query called at [/var/www/business.workmage.com/project/tool/jsonQuery.php:567]

Please Connexion or Create an account to join the conversation.

More
03 Déc 2018 09:58 #2 by babynus
Replied by babynus on topic Provider tenders
1) You must be using PostgreSql
2) Some errors should have been reported during migration.

Check errors.
Re-execute erroneous queries after fixing.
For issue on tender, you should replace "UNSIGNED NULL DEFAULT NULL" with just "UNSIGNED"

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
06 Déc 2018 21:33 #3 by andyb
Replied by andyb on topic Provider tenders
1) Yup I'm using PostgreSQL
2) No errors were display when I migrated.

Whereabouts do I change the code?

Please Connexion or Create an account to join the conversation.

More
07 Déc 2018 09:59 #4 by babynus
Replied by babynus on topic Provider tenders
2) No errors were display when I migrated.
Can you retreive and post log of migration

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
09 Déc 2018 11:31 #5 by andyb
Replied by andyb on topic Provider tenders
I had to do a fresh install. I've attached the section of the log which covers the database set up.
Attachments:

Please Connexion or Create an account to join the conversation.

More
11 Déc 2018 09:45 #6 by babynus
Replied by babynus on topic Provider tenders
The trace of update show correct update of table tender :

2018-12-06 20:54:53.796 ===== TRACE ===== Table "tender" altered.
2018-12-06 20:54:53.822 ===== TRACE ===== Table "tender" altered.


Can you show desc of table tender ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 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.