View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Create new document - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

16 juillet (10h30-12h)

22 août (16h-17h30)

12 sept (10h30-12h)

1er oct (16h-17h30)

 
 

Planifiez avec ProjeQtOr

18 et 19 septembre (9h - 12h30)

 
 

Administrez avec ProjeQtOr

25 et 26 septembre (9h - 12h30)

 

 

 

Create new document

More
17 Fév 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 Fév 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 Fév 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 Fév 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: babynusprotion
Time to create page: 0.030 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.