View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Create cotation not possible (Postgresql 5.2.1 version) - ProjeQtOr
 
 

Create cotation not possible (Postgresql 5.2.1 version)

More
20 Jan 2016 15:36 #1 by pipobru
Hello,
When y would create e new cotation (proposal) no error but no record present. If i would add in same time a file an sql error are displayed. The Log:
2016-01-20 15:29:00.426 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:00.426 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:00.427 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:00.427 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:00.427 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:00.440 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:00.440 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:00.440 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:00.440 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:00.440 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:06.869 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column command.untaxedamount does not exist
LINE 1: ..., command.validatedEndDate as "validatedEndDate", command.un...
^
2016-01-20 15:29:06.869 ***** ERROR ***** For query : select command.id as "id", T1.name as "nameProject", T2.name as "nameCommandType", command.na me as "name", T3.sortOrder || '#split#' ||T3.name || '#split#' ||COALESCE(T3.color,'') as "colorNameStatus", T4.fullName as "nameResource", command.id Resource, command.validatedEndDate as "validatedEndDate", command.untaxedAmount as "untaxedAmount", command.addUntaxedAmount as "addUntaxedAmount", co mmand.totalUntaxedAmount as "totalUntaxedAmount", command.handled as "handled", command.done as "done", command.idle as "idle",command.idProject as id project from command left join project as T1 on command.idProject = T1.id left join type as T2 on command.idCommandType = T2.id left join status as T3 on command.idStatus = T3.id left join resource as T4 on command.idResource = T4.id where command.idle=0 and command.idProject in (0, 1, 11) and ( (co mmand.idProject not in (0) or command.idProject is null ) and (command.idProject not in (0) or command.idProject is null or (command.idResource='14') ) and (command.idProject not in (0) or command.idProject is null or (command.idUser='14') ) ) order by command.id desc
2016-01-20 15:29:06.869 ***** ERROR ***** Strack trace :
2016-01-20 15:29:06.870 ***** ERROR ***** #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:496]
2016-01-20 15:29:08.096 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column quotation.untaxedamount does not exist
LINE 1: ..., quotation.validityEndDate as "validityEndDate", quotation....
^
2016-01-20 15:29:08.096 ***** ERROR ***** For query : select quotation.id as "id", T1.name as "nameProject", T2.name as "nameClient", T3.name as "n ameQuotationType", quotation.name as "name", T4.sortOrder || '#split#' ||T4.name || '#split#' ||COALESCE(T4.color,'') as "colorNameStatus", T5.fullNam e as "nameResource", quotation.idResource, quotation.validityEndDate as "validityEndDate", quotation.untaxedAmount as "untaxedAmount", quotation.fullA mount as "fullAmount", quotation.handled as "handled", quotation.done as "done", quotation.idle as "idle",quotation.idProject as idproject from quotat ion left join project as T1 on quotation.idProject = T1.id left join client as T2 on quotation.idClient = T2.id left join type as T3 on quotation.idQu otationType = T3.id left join status as T4 on quotation.idStatus = T4.id left join resource as T5 on quotation.idResource = T5.id where quotation.idle =0 and quotation.idProject in (0, 1, 11) and ( (quotation.idProject not in (0) or quotation.idProject is null ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idResource='14') ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idUser= '14') ) ) order by quotation.id desc
2016-01-20 15:29:08.096 ***** ERROR ***** Strack trace :
2016-01-20 15:29:08.096 ***** ERROR ***** #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:496]
2016-01-20 15:29:20.080 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:20.080 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:20.080 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:20.080 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:20.080 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:20.446 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column quotation.untaxedamount does not exist
LINE 1: ..., quotation.validityEndDate as "validityEndDate", quotation....
^
2016-01-20 15:29:20.447 ***** ERROR ***** For query : select quotation.id as "id", T1.name as "nameProject", T2.name as "nameClient", T3.name as "n ameQuotationType", quotation.name as "name", T4.sortOrder || '#split#' ||T4.name || '#split#' ||COALESCE(T4.color,'') as "colorNameStatus", T5.fullNam e as "nameResource", quotation.idResource, quotation.validityEndDate as "validityEndDate", quotation.untaxedAmount as "untaxedAmount", quotation.fullA mount as "fullAmount", quotation.handled as "handled", quotation.done as "done", quotation.idle as "idle",quotation.idProject as idproject from quotat ion left join project as T1 on quotation.idProject = T1.id left join client as T2 on quotation.idClient = T2.id left join type as T3 on quotation.idQu otationType = T3.id left join status as T4 on quotation.idStatus = T4.id left join resource as T5 on quotation.idResource = T5.id where quotation.idle =0 and quotation.idProject in (0, 1, 11) and ( (quotation.idProject not in (0) or quotation.idProject is null ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idResource='14') ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idUser= '14') ) ) order by quotation.id desc
2016-01-20 15:29:20.447 ***** ERROR ***** Strack trace :
2016-01-20 15:29:20.447 ***** ERROR ***** #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:496]
2016-01-20 15:29:20.513 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:20.513 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:20.513 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:20.513 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:20.513 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:20.812 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:20.812 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:20.812 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:20.812 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:20.813 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:20.890 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:20.890 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:20.890 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:20.890 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:20.890 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:20.967 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:20.967 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:20.967 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:20.967 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:20.967 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:21.047 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:21.048 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:21.048 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:21.048 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:21.048 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:21.124 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:21.125 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:21.125 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:21.125 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:21.125 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:21.212 ***** ERROR ***** Error on SqlElement to get 'idDeliveryMode' for Class 'Quotation' : field 'idDeliveryMode' not found in Dat abase.
2016-01-20 15:29:21.212 ***** ERROR ***** Error on SqlElement to get 'idPaymentDelay' for Class 'Quotation' : field 'idPaymentDelay' not found in Dat abase.
2016-01-20 15:29:21.212 ***** ERROR ***** Error on SqlElement to get 'untaxedAmount' for Class 'Quotation' : field 'untaxedAmount' not found in Datab ase.
2016-01-20 15:29:21.212 ***** ERROR ***** Error on SqlElement to get 'taxPct' for Class 'Quotation' : field 'tax' not found in Database.
2016-01-20 15:29:21.212 ***** ERROR ***** Error on SqlElement to get 'fullAmount' for Class 'Quotation' : field 'fullAmount' not found in Database.
2016-01-20 15:29:26.352 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column command.untaxedamount does not exist
LINE 1: ..., command.validatedEndDate as "validatedEndDate", command.un...
^
2016-01-20 15:29:26.353 ***** ERROR ***** For query : select command.id as "id", T1.name as "nameProject", T2.name as "nameCommandType", command.na me as "name", T3.sortOrder || '#split#' ||T3.name || '#split#' ||COALESCE(T3.color,'') as "colorNameStatus", T4.fullName as "nameResource", command.id Resource, command.validatedEndDate as "validatedEndDate", command.untaxedAmount as "untaxedAmount", command.addUntaxedAmount as "addUntaxedAmount", co mmand.totalUntaxedAmount as "totalUntaxedAmount", command.handled as "handled", command.done as "done", command.idle as "idle",command.idProject as id project from command left join project as T1 on command.idProject = T1.id left join type as T2 on command.idCommandType = T2.id left join status as T3 on command.idStatus = T3.id left join resource as T4 on command.idResource = T4.id where command.idle=0 and command.idProject in (0, 1, 11) and ( (co mmand.idProject not in (0) or command.idProject is null ) and (command.idProject not in (0) or command.idProject is null or (command.idResource='14') ) and (command.idProject not in (0) or command.idProject is null or (command.idUser='14') ) ) order by command.id desc
2016-01-20 15:29:26.353 ***** ERROR ***** Strack trace :
2016-01-20 15:29:26.353 ***** ERROR ***** #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:496]
2016-01-20 15:29:27.751 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column quotation.untaxedamount does not exist
LINE 1: ..., quotation.validityEndDate as "validityEndDate", quotation....
^
2016-01-20 15:29:27.751 ***** ERROR ***** For query : select quotation.id as "id", T1.name as "nameProject", T2.name as "nameClient", T3.name as "n ameQuotationType", quotation.name as "name", T4.sortOrder || '#split#' ||T4.name || '#split#' ||COALESCE(T4.color,'') as "colorNameStatus", T5.fullNam e as "nameResource", quotation.idResource, quotation.validityEndDate as "validityEndDate", quotation.untaxedAmount as "untaxedAmount", quotation.fullA mount as "fullAmount", quotation.handled as "handled", quotation.done as "done", quotation.idle as "idle",quotation.idProject as idproject from quotat ion left join project as T1 on quotation.idProject = T1.id left join client as T2 on quotation.idClient = T2.id left join type as T3 on quotation.idQu otationType = T3.id left join status as T4 on quotation.idStatus = T4.id left join resource as T5 on quotation.idResource = T5.id where quotation.idle =0 and quotation.idProject in (0, 1, 11) and ( (quotation.idProject not in (0) or quotation.idProject is null ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idResource='14') ) and (quotation.idProject not in (0) or quotation.idProject is null or (quotation.idUser= '14') ) ) order by quotation.id desc
2016-01-20 15:29:27.751 ***** ERROR ***** Strack trace :
2016-01-20 15:29:27.751 ***** ERROR ***** #0 Sql->query called at [/var/www/html/tool/jsonQuery.php:496]

Please Log in or Create an account to join the conversation.

More
20 Jan 2016 19:54 - 20 Jan 2016 19:55 #2 by babynus
Hi,

It seems some migration went wrong.
Could you please retreive latest database mibration logs and post it here ?
I guess it is migration to V5.1 that went wrong...

Babynus
Administrator of ProjeQtOr web site
Last edit: 20 Jan 2016 19:55 by babynus.
The following user(s) said Thank You: pipobru

Please Log in or Create an account to join the conversation.

More
21 Jan 2016 08:28 #3 by pipobru
Hi,
I think is possible but not with the last migration (without error sur !)
It is possible to re run migration script ?

Please Log in or Create an account to join the conversation.

More
22 Jan 2016 16:55 #4 by pipobru
Hi,
can you help me ? Sorry but it is important. Very big thanks for you work.

Please Log in or Create an account to join the conversation.

More
22 Jan 2016 19:59 #5 by babynus
yes, you can re-execute migration.

change parameterValue = old version for line of parameter table where parameterCode='dbVersion'

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
25 Jan 2016 15:51 #6 by pipobru
Very big thanks.
My script sql for solve the problem:

ALTER TABLE quotation RENAME initialwork TO "untaxedAmount";
ALTER TABLE quotation
ALTER COLUMN "untaxedAmount" TYPE numeric(11,2);
ALTER TABLE quotation
ADD COLUMN iddeliverymode numeric(12,0);
ALTER TABLE quotation
ADD COLUMN idpaymentdelay numeric(12,0);
ALTER TABLE quotation
ADD COLUMN tax numeric(5,2);
ALTER TABLE quotation
ADD COLUMN fullamount numeric(12,2);

ALTER TABLE command
ADD COLUMN "idpaymentdelay" numeric(12,0);
ALTER TABLE command
ADD COLUMN tax numeric(5,2);
ALTER TABLE command
ADD COLUMN "fullamount" numeric(12,2);
ALTER TABLE command
ADD COLUMN addfullamount numeric(12,2);
ALTER TABLE command
ADD COLUMN totalfullamount numeric(12,2);
ALTER TABLE command
ADD COLUMN iddeliverymode numeric(12,0);

ALTER TABLE quotation
ADD COLUMN "untaxedAmount" numeric(11,2);

ALTER TABLE command
ADD COLUMN "untaxedAmount" numeric(11,2);
ALTER TABLE command
ADD COLUMN "addUntaxedAmount" numeric(11,2);
ALTER TABLE command
ADD COLUMN "totalUntaxedAmount" numeric(11,2);

Please Log in or Create an account to join the conversation.

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