Hello,
I use the last version 4.5.5 (same problem with the previous version 4.5.4). Is not possible to create a new document with postgresql databse. I think the problem com from postgres because i found similar probleme on this forum, on other fonctionnalitys.
Log:
2015-02-17 08:36:39 ** 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...
^
2015-02-17 08:36:39 ** ERROR ** For query : select * from statusmail where idle='0' and idMailable='14' and ( false or idStatus=' ' or idEvent='9' )
2015-02-17 08:36:39 ** ERROR ** Strack trace :
2015-02-17 08:36:39 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1488]
2015-02-17 08:36:39 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:2859]
2015-02-17 08:36:39 ** ERROR ** #2 SqlElement->sendMailIfMailable called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:528]
2015-02-17 08:36:39 ** ERROR ** #3 SqlElement->saveSqlElement called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:398]
2015-02-17 08:36:39 ** ERROR ** #4 SqlElement->save called at [/var/www/html/projeqtor455/model/Document.php:263]
2015-02-17 08:36:39 ** ERROR ** #5 Document->save called at [/var/www/html/projeqtor455/tool/saveObject.php:83]
2015-02-17 08:36:39 ** ERROR ** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-02-17 08:36:39 ** ERROR ** For query : select * from documentdirectory where id=2
2015-02-17 08:36:39 ** ERROR ** Strack trace :
2015-02-17 08:36:39 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1743]
2015-02-17 08:36:39 ** ERROR ** #1 SqlElement->getSqlElement called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:377]
2015-02-17 08:36:39 ** ERROR ** #2 SqlElement->__construct called at [/var/www/html/projeqtor455/model/DocumentDirectory.php:72]
2015-02-17 08:36:39 ** ERROR ** #3 DocumentDirectory->__construct called at [/var/www/html/projeqtor455/model/Document.php:268]
2015-02-17 08:36:39 ** ERROR ** #4 Document->save called at [/var/www/html/projeqtor455/tool/saveObject.php:83]
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'id' for Class 'DocumentDirectory' : field 'id' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'idDocumentDirectory' for Class 'DocumentDirectory' : field 'idDocumentDirectory' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'name' for Class 'DocumentDirectory' : field 'name' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'location' for Class 'DocumentDirectory' : field 'location' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'idProject' for Class 'DocumentDirectory' : field 'idProject' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'idProduct' for Class 'DocumentDirectory' : field 'idProduct' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'idDocumentType' for Class 'DocumentDirectory' : field 'idDocumentType' not found in Database.
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1798)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** ERROR **
2015-02-17 08:36:39 ** ERROR ** on file '/var/www/html/projeqtor455/model/persistence/SqlElement.php' at line (1800)
2015-02-17 08:36:39 ** ERROR ** cause = array_key_exists() expects parameter 2 to be array, boolean given
2015-02-17 08:36:39 ** ERROR ** Error on SqlElement to get 'idle' for Class 'DocumentDirectory' : field 'idle' not found in Database.
2015-02-17 08:36:39 ** ERROR ** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-02-17 08:36:39 ** 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
2015-02-17 08:36:39 ** ERROR ** Strack trace :
2015-02-17 08:36:39 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:2166]
2015-02-17 08:36:39 ** ERROR ** #1 SqlElement->getFormatList called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1923]
2015-02-17 08:36:39 ** ERROR ** #2 SqlElement->getDataType called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1455]
2015-02-17 08:36:39 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor455/model/Document.php:283]
2015-02-17 08:36:39 ** ERROR ** #4 Document->save called at [/var/www/html/projeqtor455/tool/saveObject.php:83]
2015-02-17 08:36:39 ** ERROR ** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-02-17 08:36:39 ** ERROR ** For query : select * from documentversion where documentversion.idDocument='11'
2015-02-17 08:36:39 ** ERROR ** Strack trace :
2015-02-17 08:36:39 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1488]
2015-02-17 08:36:39 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor455/model/Document.php:283]
2015-02-17 08:36:39 ** ERROR ** #2 Document->save called at [/var/www/html/projeqtor455/tool/saveObject.php:83]
2015-02-17 08:36:39 ** ERROR ** Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-02-17 08:36:39 ** ERROR ** For query : select * from checklistdefinition where nameChecklistable='Document' and (idType is null or idType=63)
2015-02-17 08:36:39 ** ERROR ** Strack trace :
2015-02-17 08:36:39 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor455/model/persistence/SqlElement.php:1488]
2015-02-17 08:36:39 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor455/tool/saveObject.php:96]
Ticket #1661 recorded
Hi !
Fix for this issue (only happening with PostgreSql) is on /model/persistence/SqlElement.php, replace line 2827
if ($statusChange and $this->idStatus) {
with
if ($statusChange and trim($this->idStatus)) {
This fix will be included in next version.
Hi,
It's perfect ! correctif full efficient ! Big Thanks :cheer: :woohoo: 😆 :woohoo: