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]