View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Create new document - ProjeQtOr
 
 

Create new document

More
17 Feb 2015 08:11 #1 by pipobru
Create new document was created by pipobru
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]
The topic has been locked.
More
17 Feb 2015 22:07 #2 by babynus
Replied by babynus on topic Create new document
Ticket #1661 recorded
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
18 Feb 2015 23:01 #3 by babynus
Replied by babynus on topic Create new document
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.
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
19 Feb 2015 07:42 #4 by pipobru
Replied by pipobru on topic Create new document
Hi,
It's perfect ! correctif full efficient ! Big Thanks :cheer: :woohoo: :lol: :woohoo:
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.036 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.

Login Form