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) - Page 2 - ProjeQtOr
 
 

Create cotation not possible (Postgresql 5.2.1 version)

More
25 Jan 2016 16:20 #7 by pipobru
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 ?

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

More
26 Jan 2016 20:59 #8 by babynus
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 ?

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: pipobru

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

More
28 Jan 2016 10:26 #9 by pipobru
Hi,
It is when i record a new cotation. I think no, bug is present.

Thanks for your support.

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.