View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Provider tenders - ProjeQtOr
 

Provider tenders

More
02 Dec 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 Log in or Create an account to join the conversation.

More
03 Dec 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 Log in or Create an account to join the conversation.

More
06 Dec 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 Log in or Create an account to join the conversation.

More
07 Dec 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 Log in or Create an account to join the conversation.

More
09 Dec 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 Log in or Create an account to join the conversation.

More
11 Dec 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.042 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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