Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Error for ...
 
Notifications
Clear all

[SOLVED] Error for define a filter

3 Posts
2 Users
0 Reactions
2,144 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#6706]

Hello,
when i want create a new filter with a activity type criteria i have this trace, in complement the problem is only when i have selected different projects:

2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERREUR: syntaxe en entrée invalide pour le type numeric : « 2,45,41 »
LINE 1: ...stricttype where (1=1 and restricttype.idProject='2,45,41' ...
^
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] For query : select id as id, idType as name from restricttype where (1=1 and restricttype.idProject='2,45,41' and restricttype.className='ActivityType') order by restricttype.idType
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] Strack trace :
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlList.php:298]
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] #1 SqlList->fetchListWithCrit called at [/home/projtma/public_html/model/persistence/SqlList.php:77]
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] #2 SqlList->getListWithCrit called at [/home/projtma/public_html/model/Type.php:277]
2020-05-13 08:06:31.417 ** ERROR ** [V8.4.3] #3 Type->listRestritedTypesForClass called at [/home/projtma/public_html/tool/jsonList.php:375]
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] HACK ================================================================
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] Try to hack detected
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] Source Code = SqlElement->_construct : id '2,45,41' is not numeric for class Project
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] QUERY_STRING = required=true&listType=list&dataType=idActivityType&critField=idProject&critValue=2,45,41
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] REMOTE_ADDR = 91.161.39.143
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] SCRIPT_FILENAME = /home/projtma/public_html/tool/jsonList.php
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/tool/projeqtor.php at line 1524 calling debugPrintTraceStack()
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/model/persistence/SqlElement.php at line 691 calling traceHack()
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/model/ProjectMain.php at line 188 calling SqlElement:__construct()
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/model/Project.php at line 40 calling ProjectMain:__construct()
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/model/Type.php at line 281 calling Project:__construct()
2020-05-13 08:06:31.418 ----- DEBUG ----- => /home/projtma/public_html/tool/jsonList.php at line 375 calling Type:listRestritedTypesForClass()
2020-05-13 08:06:31.418 ** ERROR ** [V8.4.3] REQUEST_URI = /tool/jsonList.php?required=true&listType=list&dataType=idActivityType&critField=idProject&critValue=2,45,41
2020-05-13 08:06:53.043 ----- DEBUG ----- loginCheck : current db version = 'V8.4.3'
2020-05-13 08:06:53.045 ----- DEBUG ----- User->authenticate('Bruno', '50169a609e9d643ac018fa72a543ebc093d02d8ec591d490a853ce4c48fcd9cc')
2020-05-13 08:06:53.046 ----- DEBUG ----- User->authenticate : sha256 encryption
2020-05-13 08:06:53.046 ----- DEBUG ----- User->authenticate : Successfull login
2020-05-13 08:06:53.051 ===== TRACE ===== NEW CONNECTED USER 'Bruno'
2020-05-13 08:07:30.318 ** ERROR ** [V8.4.3] Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERREUR: syntaxe en entrée invalide pour le type numeric : « 2,45,41 »
LINE 1: ...stricttype where (1=1 and restricttype.idProject='2,45,41' ...

Can you help me ? It's urgent for my reporting.
Very thanks.
Bruno.


 
Posted : 13 May 2020 10H12
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

Issue recorded as Ticket #4664

Can you help me ? It's urgent for my reporting.

The only way to have urgent fixing is to subscribe to our professional support service.


 
Posted : 13 May 2020 14H29
(@pipobru)
Posts: 180
Active Member
Topic starter
 

It is clear and normal. Very thanks for your answer


 
Posted : 13 May 2020 14H38
Share:

Scroll to Top