Whenever I try to create a new document, despots it shows me all OK, the document isn't created and in the log file I have this entry:
2014-05-26 14:20:19 ***** ERROR ***** Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: " "
LINE 1: ...'0' and idMailable='14' and ( false or idStatus=' ' or id...
^
2014-05-26 14:20:19 ***** ERROR ***** For query : select * from statusmail where idle='0' and idMailable='14' and ( false or idStatus=' ' or idEvent='9' )
2014-05-26 14:20:19 ***** ERROR ***** Strack trace :
2014-05-26 14:20:19 ***** ERROR ***** #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:1444]
2014-05-26 14:20:19 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/opt/projeqtor/model/persistence/SqlElement.php:2780]
2014-05-26 14:20:19 ***** ERROR ***** #2 SqlElement->sendMailIfMailable called at [/opt/projeqtor/model/persistence/SqlElement.php:501]
2014-05-26 14:20:19 ***** ERROR ***** #3 SqlElement->saveSqlElement called at [/opt/projeqtor/model/persistence/SqlElement.php:371]
2014-05-26 14:20:19 ***** ERROR ***** #4 SqlElement->save called at [/opt/projeqtor/model/Document.php:238]
2014-05-26 14:20:19 ***** ERROR ***** #5 Document->save called at [/opt/projeqtor/tool/saveObject.php:58]
2014-05-26 14:20:19 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2014-05-26 14:20:19 ***** ERROR ***** For query : SELECT a.attname as field, pg_catalog.format_type(a.atttypid, a.atttypmod) as type FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='documentversion') AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum
2014-05-26 14:20:19 ***** ERROR ***** Strack trace :
2014-05-26 14:20:19 ***** ERROR ***** #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:2097]
2014-05-26 14:20:19 ***** ERROR ***** #1 SqlElement->getFormatList called at [/opt/projeqtor/model/persistence/SqlElement.php:1874]
2014-05-26 14:20:19 ***** ERROR ***** #2 SqlElement->getDataType called at [/opt/projeqtor/model/persistence/SqlElement.php:1411]
2014-05-26 14:20:19 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [/opt/projeqtor/model/Document.php:258]
2014-05-26 14:20:19 ***** ERROR ***** #4 Document->save called at [/opt/projeqtor/tool/saveObject.php:58]
2014-05-26 14:20:19 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2014-05-26 14:20:19 ***** ERROR ***** For query : select * from documentversion where documentversion.idDocument='1'
2014-05-26 14:20:19 ***** ERROR ***** Strack trace :
2014-05-26 14:20:19 ***** ERROR ***** #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:1444]
2014-05-26 14:20:19 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/opt/projeqtor/model/Document.php:258]
2014-05-26 14:20:19 ***** ERROR ***** #2 Document->save called at [/opt/projeqtor/tool/saveObject.php:58]
2014-05-26 14:20:19 ***** ERROR ***** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2014-05-26 14:20:19 ***** ERROR ***** For query : select * from checklistdefinition where nameChecklistable='Document' and (idType is null or idType=98)
2014-05-26 14:20:19 ***** ERROR ***** Strack trace :
2014-05-26 14:20:19 ***** ERROR ***** #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:1444]
2014-05-26 14:20:19 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/opt/projeqtor/tool/saveObject.php:71]
I tried to execute the first statement on the database directly and, in fact, it does not like it :
select * from statusmail where idle='0' and idMailable='14' and ( false or idStatus=' ' or idEvent='9' )
It doesn't like the space on the "idStatus" field, since it is expecting a numeric.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
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.