Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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]
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...
Hi,
I think is possible but not with the last migration (without error sur !)
It is possible to re run migration script ?
Hi,
can you help me ? Sorry but it is important. Very big thanks for you work.
yes, you can re-execute migration.
change parameterValue = old version for line of parameter table where parameterCode='dbVersion'
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);
The last problem, not blocant is in log file this error:
2016-01-25 16:18:01.563 ** ERROR ** Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: ""
LINE 1: ...reference,''),' - ',name,' (',coalesce(fullAmount,''),')') a...
^
2016-01-25 16:18:01.563 ** ERROR ** For query : select id as id, concat(coalesce(reference,''),' - ',name,' (',coalesce(fullAmount,''),')') as name from bill where (1=1 and idle=0 and bill.paymentDone='0' and bill.done='1') order by bill.name
2016-01-25 16:18:01.563 ** ERROR ** Strack trace :
2016-01-25 16:18:01.563 ** ERROR ** #0 Sql->query called at [/var/www/html/model/persistence/SqlList.php:227]
2016-01-25 16:18:01.563 ** ERROR ** #1 SqlList->fetchListWithCrit called at [/var/www/html/model/persistence/SqlList.php:76]
2016-01-25 16:18:01.563 ** ERROR ** #2 SqlList->getListWithCrit called at [/var/www/html/tool/html.php:95]
2016-01-25 16:18:01.563 ** ERROR ** #3 htmlDrawOptionForReference called at [/var/www/html/view/objectDetail.php:1415]
2016-01-25 16:18:01.564 ** ERROR ** #4 drawTableFromObject called at [/var/www/html/view/objectDetail.php:251]
I think i dont have initialised default values. But the question is what is default value ?
Ticket #1950 recorded.
IT is a specific PostgreSql issue.
This issue seems to appear when displaying a payment, no ?
Can you try and replace in /model/BillMain.php, line 122 from
public $_calculateForColumn=array("name"=>"concat(coalesce(reference,''),' - ',name,' (',coalesce(fullAmount,''),')')");
to
public $_calculateForColumn=array("name"=>"concat(coalesce(reference,''),' - ',name,' (',coalesce(fullAmount,0),')')");
and in /model/BillNotPaid.php line 53 from
public $_calculateForColumn=array("name"=>"concat(coalesce(reference,''), ' - ', name, ' (',coalesce(fullAmount,''),')')");
to
public $_calculateForColumn=array("name"=>"concat(coalesce(reference,''), ' - ', name, ' (',coalesce(fullAmount,0),')')");
Does it fix the issue ?
Hi,
It is when i record a new cotation. I think no, bug is present.
Thanks for your support.