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]
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"
1) Yup I'm using PostgreSQL
2) No errors were display when I migrated.
Whereabouts do I change the code?
2) No errors were display when I migrated.
Can you retreive and post log of migration
I had to do a fresh install. I've attached the section of the log which covers the database set up.
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 ?
Here is the table definition:
CREATE TABLE public.tender
(
id integer NOT NULL DEFAULT nextval('tender_id_seq'::regclass),
reference character varying(100) DEFAULT NULL::character varying,
name character varying(200) DEFAULT NULL::character varying,
idtendertype numeric(12,0) DEFAULT NULL::numeric,
idproject numeric(12,0) DEFAULT NULL::numeric,
idcallfortender numeric(12,0) DEFAULT NULL::numeric,
idtenderstatus numeric(12,0) DEFAULT NULL::numeric,
iduser numeric(12,0) DEFAULT NULL::numeric,
creationdate date,
idprovider numeric(12,0) DEFAULT NULL::numeric,
externalreference character varying(100) DEFAULT NULL::character varying,
description text,
idstatus numeric(12,0) DEFAULT NULL::numeric,
idresource numeric(12,0) DEFAULT NULL::numeric,
idcontact numeric(12,0) DEFAULT NULL::numeric,
requestdatetime timestamp without time zone,
expectedtenderdatetime timestamp without time zone,
receptiondatetime timestamp without time zone,
evaluationvalue numeric(7,2) DEFAULT NULL::numeric,
evaluationrank numeric(3,0) DEFAULT NULL::numeric,
offervalidityenddate date,
plannedamount numeric(11,2),
taxpct numeric(5,2) DEFAULT NULL::numeric,
plannedtaxamount numeric(11,2),
plannedfullamount numeric(11,2),
untaxedamount numeric(11,2),
initialtaxamount numeric(11,2),
initialfullamount numeric(11,2),
deliverydelay character varying(100) DEFAULT NULL::character varying,
deliverydate date,
paymentcondition character varying(100) DEFAULT NULL::character varying,
evaluation numeric(7,2) DEFAULT NULL::numeric,
result text,
handled numeric(1,0) DEFAULT '0'::numeric,
done numeric(1,0) DEFAULT '0'::numeric,
idle numeric(1,0) DEFAULT '0'::numeric,
cancelled numeric(1,0) DEFAULT '0'::numeric,
handleddate date,
donedate date,
idledate date,
discountamount numeric(11,2),
discountrate numeric(5,2),
idprojectexpense numeric(12,0) DEFAULT NULL::numeric,
discountfrom character varying(10),
CONSTRAINT tender_pkey PRIMARY KEY (id)
)
Hi,
Got it !
It is an issue fixed on V7.3.2.
You can also simply "reset" column display in column selector
brilliant - thanks 🙂
i'll upgrade over the next few days.
I have a second question, I've tried to include the tender process on the plan. I added an activity to the plan but when I tried to link the activity to the "call to tender", I couldn't find it on the list. I can link the individual tenders but not the "call to tender".
Hi,
Tenders are "linkable", but Call for tenders are not.
It could be an improvment.
Hint :
As a workarount, go to the Call For Tender, here link the activity : you're done !
Go to the activity : link to Call for Tender exists.
I think it should be an improvement and the workaround works 🙂
Thanks