Message Try to hack detected when importing CSV / XLSX requirements in 9.5
log:
2022-03-31 10:00:59.038 ===== TRACE ===== Importation : File type XSLX
2022-03-31 10:00:59.039 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.xlsx
2022-03-31 08:00:59.102 ** ERROR ** [V9.5.0] HACK ================================================================
2022-03-31 08:00:59.102 ** ERROR ** [V9.5.0] Try to hack detected
2022-03-31 08:00:59.103 ** ERROR ** [V9.5.0] Source Code = SqlElement->_construct : id 'status' is not numeric for class Requirement
2022-03-31 08:00:59.103 ** ERROR ** [V9.5.0] QUERY_STRING =
2022-03-31 08:00:59.104 ** ERROR ** [V9.5.0] REMOTE_ADDR = 127.0.0.1
2022-03-31 08:00:59.104 ** ERROR ** [V9.5.0] SCRIPT_FILENAME = C:/APP/XAMPP/htdocs/projeqtor_de/tool/import.php
2022-03-31 08:00:59.104 ** ERROR ** [V9.5.0] CONNECTED USER = #1 - admin
2022-03-31 08:00:59.105 ** ERROR ** [V9.5.0] REQUEST_URI = /projeqtor_de/tool/import.php
2022-03-31 10:02:26.335 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-03-31 10:02:35.861 ===== TRACE ===== DISCONNECTED USER 'admin'
2022-03-31 10:02:50.806 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-03-31 10:03:44.990 ===== TRACE ===== Importation : File type XSLX
2022-03-31 10:03:44.991 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.xlsx
2022-03-31 08:03:45.046 ** ERROR ** [V9.5.0] HACK ================================================================
2022-03-31 08:03:45.047 ** ERROR ** [V9.5.0] Try to hack detected
2022-03-31 08:03:45.047 ** ERROR ** [V9.5.0] Source Code = SqlElement->_construct : id 'status' is not numeric for class Requirement
2022-03-31 08:03:45.048 ** ERROR ** [V9.5.0] QUERY_STRING =
2022-03-31 08:03:45.048 ** ERROR ** [V9.5.0] REMOTE_ADDR = 127.0.0.1
2022-03-31 08:03:45.049 ** ERROR ** [V9.5.0] SCRIPT_FILENAME = C:/APP/XAMPP/htdocs/projeqtor_de/tool/import.php
2022-03-31 08:03:45.049 ** ERROR ** [V9.5.0] CONNECTED USER = #1 - admin
2022-03-31 08:03:45.049 ** ERROR ** [V9.5.0] REQUEST_URI = /projeqtor_de/tool/import.php
2022-03-31 10:04:53.105 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-03-31 10:05:35.423 ===== TRACE ===== Importation : File type CSV
2022-03-31 10:05:35.424 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.csv
2022-03-31 10:08:15.224 ===== TRACE ===== Importation : File type CSV
2022-03-31 10:08:15.226 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.csv
2022-03-31 10:10:51.054 ===== TRACE ===== Importation : File type CSV
2022-03-31 10:10:51.054 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.csv
2022-03-31 14:23:28.961 ===== TRACE ===== Importation : File type XSLX
2022-03-31 14:23:28.961 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.xlsx
2022-03-31 12:23:29.046 ** ERROR ** [V9.5.0] HACK ================================================================
2022-03-31 12:23:29.046 ** ERROR ** [V9.5.0] Try to hack detected
2022-03-31 12:23:29.047 ** ERROR ** [V9.5.0] Source Code = SqlElement->_construct : id 'requirement type' is not numeric for class Requirement
2022-03-31 12:23:29.047 ** ERROR ** [V9.5.0] QUERY_STRING =
2022-03-31 12:23:29.048 ** ERROR ** [V9.5.0] REMOTE_ADDR = 127.0.0.1
2022-03-31 12:23:29.048 ** ERROR ** [V9.5.0] SCRIPT_FILENAME = C:/APP/XAMPP/htdocs/projeqtor_de/tool/import.php
2022-03-31 12:23:29.049 ** ERROR ** [V9.5.0] CONNECTED USER = #1 - admin
2022-03-31 12:23:29.049 ** ERROR ** [V9.5.0] REQUEST_URI = /projeqtor_de/tool/import.php
2022-03-31 14:24:13.126 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-03-31 14:25:45.400 ===== TRACE ===== Importation : File type CSV
2022-03-31 14:25:45.401 ===== TRACE ===== File Name : ../files/attach/importimport_Requirement_20220331_094856.csv
2022-03-31 14:25:45.702 ** ERROR ** [V9.5.0] HACK ================================================================
2022-03-31 14:25:45.703 ** ERROR ** [V9.5.0] Try to hack detected
2022-03-31 14:25:45.703 ** ERROR ** [V9.5.0] Source Code = SqlElement->_construct : id 'requirement type' is not numeric for class Requirement
2022-03-31 14:25:45.703 ** ERROR ** [V9.5.0] QUERY_STRING =
2022-03-31 14:25:45.704 ** ERROR ** [V9.5.0] REMOTE_ADDR = 127.0.0.1
2022-03-31 14:25:45.704 ** ERROR ** [V9.5.0] SCRIPT_FILENAME = C:/APP/XAMPP/htdocs/projeqtor_de/tool/import.php
2022-03-31 14:25:45.704 ** ERROR ** [V9.5.0] CONNECTED USER = #1 - admin
2022-03-31 14:25:45.705 ** ERROR ** [V9.5.0] REQUEST_URI = /projeqtor_de/tool/import.php
I guess you have some issue in your column "ID"
It seems there is value "status", which of course is not numeric.
Thanks. You're right. ";" detected in name and description fields. Not so good to import in CSV!
Yes,
text fields should be surounded by double quotes