on V10.0.4, I try to extract tickets on CSV files, it's works, but when I open the csv file with Excel, the is empty and it's write "aucune donnée à afficher pour ce repas"
log file:2022-08-25 12:13:21.981 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.983 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.997 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:21.999 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:22.002 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:13:22.004 ***** ERROR ***** [V10.0.4] Error on SqlElement to get 'test' for Class 'Ticket' : field 'test' not found in Database on table ticket
2022-08-25 12:14:10.251 ***** ERROR ***** [V10.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket.test' in 'field list'
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] For query : select ticket.id as id, ticket.name as name, ticket.idTicketType as idTicketType, ticket.idProject as idProject, ticket.idUrgency as idUrgency, ticket.test as test, ticket.creationDateTime as creationDateTime, ticket.idUser as idUser, ticket.idContact as idContact, ticket.idStatus as idStatus, ticket.idAccountable as idAccountable, ticket.idResource as idResource, ticket.actualDueDateTime as actualDueDateTime, workelement.realWork as realWork, ticket.doneDateTime as doneDateTime, ticket.idProduct as idProduct, ticket.idOriginalProductVersion as idOriginalProductVersion from ticket left join origin on ticket.id = origin.refId and origin.refType='Ticket' left join workelement on ticket.id = workelement.refId and workelement.refType='Ticket' where (ticket.idProject <> 317 or ticket.idProject is null) and ( ( 1=1 and (ticket.idProject in (0, 226, 232, 16, 29, 13, 334, 14, 15, 17, 248, 332, 326, 371, 2, 37, 25, 82, 96, 89, 77, 91, 84, 97, 98, 87, 107, 114, 132, 90, 72, 71, 307, 396, 70, 170, 106, 80, 171, 81, 115, 67, 116, 66, 123, 136, 151, 141, 207, 158, 192, 198, 178, 206, 218, 201, 225, 251, 253, 165, 249, 108, 109, 208, 233, 234, 131, 173, 219, 250, 236, 252, 215, 216, 217, 231, 235, 164, 209, 63, 254, 195, 244, 245, 246, 111, 110, 274, 221, 306, 271, 261, 264, 262, 272, 273, 237, 312, 268, 305, 284, 285, 280, 354, 279, 288, 290, 291, 294, 295, 286, 298, 299, 238, 303, 301, 323, 313, 292, 293, 347, 281, 345, 324, 338, 308, 329, 330, 344, 333, 302, 314, 339, 331, 346, 310, 311, 366, 340, 348, 343, 351, 362, 357, 194, 359, 352, 369, 368, 370, 358, 363, 372, 379, 378, 384, 387, 365, 355, 377, 376, 403, 364, 401, 390, 388, 385, 386, 380, 374, 399, 402, 391, 88, 408, 409, 404, 405, 406, 407, 470, 212, 441, 439, 59, 410, 463, 458, 454, 545, 240, 452, 451, 448, 447, 353, 475, 474, 551, 477, 473, 464, 471, 476, 395, 316, 478, 465, 491, 455, 461, 501, 490, 488, 517, 495, 393, 544, 479, 506, 513, 530, 503, 507, 518, 549, 548, 529, 565, 524, 525, 527, 494, 492, 547, 546, 564, 562, 552, 557, 571, 502, 558, 570, 567, 580, 56, 57, 586, 579, 482, 584, 587, 568, 588, 597, 583, 592, 260, 596, 573, 467, 572, 574, 593, 594, 589, 576, 55, 119, 65, 69, 68, 54, 53, 425, 575, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 39, 40, 33, 577, 578, 38, 35, 36, 83, 85, 86, 92, 93, 99, 121, 104, 105, 113, 117, 118, 120, 122, 124, 125, 126, 127, 128, 133, 134, 135, 137, 138, 139, 142, 152, 153, 154, 159, 167, 168, 169, 174, 176, 177, 182, 183, 184, 185, 186, 187, 190, 193, 197, 202, 203, 204, 210, 214, 220, 222, 223, 224, 228, 227, 229, 230, 242, 243, 247, 256, 257, 258, 265, 266, 269, 275, 276, 277, 278, 282, 296, 297, 304, 309, 318, 319, 320, 321, 325, 327, 328, 335, 336, 337, 341, 342, 349, 356, 360, 361, 373, 375, 383, 389, 392, 394, 397, 398, 400, 411, 414, 415, 416, 417, 426, 427, 428, 440, 442, 443, 444, 445, 446, 449, 450, 456, 457, 460, 462, 466, 469, 480, 481, 493, 499, 500, 504, 505, 508, 510, 511, 514, 516, 519, 520, 521, 522, 523, 526, 541, 542, 543, 550, 555, 556, 560, 561, 563, 566, 581, 582, 585, 590, 591, 595, 143, 437, 144, 255, 429, 430, 431, 145, 432, 433, 434, 435, 436, 3, 263, 75, 32, 129, 26, 27, 28, 382, 31, 472, 267, 283, 419, 420, 422, 421, 189, 34, 7, 10, 322, 73, 147, 148, 166, 418, 553, 554, 30, 211, 213, 162, 163, 259, 149, 150, 270, 157, 160, 239, 94, 95, 146, 100, 101, 102, 103, 424, 22, 172, 175, 179, 196, 287, 315, 438, 528, 4, 350, 367, 381, 24, 453, 5, 199, 6, 11, 12, 18, 19, 20, 21, 23, 140, 289, 161, 8, 509, 512, 300, 489, 483, 484, 485, 486, 487, 515, 569) or ticket.idProject is null) and ticket.idProject not in (0, 16, 29, 13, 15, 553, 94, 101, 199) ) or (ticket.idProject=16 ) or (ticket.idProject=29 ) or (ticket.idProject=13 ) or (ticket.idProject=15 ) or (ticket.idProject=553 ) or (ticket.idProject=94 ) or (ticket.idProject=101 ) or (ticket.idProject=199 ) ) and ( ((ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource=3) ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser=3) )) ) order by ticket.id desc
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] Strack trace :
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:794]
2022-08-25 12:14:10.252 ***** ERROR ***** [V10.0.4] #1 include called at [/var/www/html/projeqtor/view/print.php:288]
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket.test' in 'field list'
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] For query : select ticket.id as id, ticket.name as name, ticket.idTicketType as idTicketType, ticket.idProject as idProject, ticket.idUrgency as idUrgency, ticket.test as test, ticket.creationDateTime as creationDateTime, ticket.idUser as idUser, ticket.idContact as idContact, ticket.idStatus as idStatus, ticket.idAccountable as idAccountable, ticket.idResource as idResource, ticket.actualDueDateTime as actualDueDateTime, workelement.realWork as realWork, ticket.doneDateTime as doneDateTime, ticket.idProduct as idProduct, ticket.idOriginalProductVersion as idOriginalProductVersion from ticket left join origin on ticket.id = origin.refId and origin.refType='Ticket' left join workelement on ticket.id = workelement.refId and workelement.refType='Ticket' where (ticket.idProject <> 317 or ticket.idProject is null) and ( ( 1=1 and (ticket.idProject in (0, 226, 232, 16, 29, 13, 334, 14, 15, 17, 248, 332, 326, 371, 2, 37, 25, 82, 96, 89, 77, 91, 84, 97, 98, 87, 107, 114, 132, 90, 72, 71, 307, 396, 70, 170, 106, 80, 171, 81, 115, 67, 116, 66, 123, 136, 151, 141, 207, 158, 192, 198, 178, 206, 218, 201, 225, 251, 253, 165, 249, 108, 109, 208, 233, 234, 131, 173, 219, 250, 236, 252, 215, 216, 217, 231, 235, 164, 209, 63, 254, 195, 244, 245, 246, 111, 110, 274, 221, 306, 271, 261, 264, 262, 272, 273, 237, 312, 268, 305, 284, 285, 280, 354, 279, 288, 290, 291, 294, 295, 286, 298, 299, 238, 303, 301, 323, 313, 292, 293, 347, 281, 345, 324, 338, 308, 329, 330, 344, 333, 302, 314, 339, 331, 346, 310, 311, 366, 340, 348, 343, 351, 362, 357, 194, 359, 352, 369, 368, 370, 358, 363, 372, 379, 378, 384, 387, 365, 355, 377, 376, 403, 364, 401, 390, 388, 385, 386, 380, 374, 399, 402, 391, 88, 408, 409, 404, 405, 406, 407, 470, 212, 441, 439, 59, 410, 463, 458, 454, 545, 240, 452, 451, 448, 447, 353, 475, 474, 551, 477, 473, 464, 471, 476, 395, 316, 478, 465, 491, 455, 461, 501, 490, 488, 517, 495, 393, 544, 479, 506, 513, 530, 503, 507, 518, 549, 548, 529, 565, 524, 525, 527, 494, 492, 547, 546, 564, 562, 552, 557, 571, 502, 558, 570, 567, 580, 56, 57, 586, 579, 482, 584, 587, 568, 588, 597, 583, 592, 260, 596, 573, 467, 572, 574, 593, 594, 589, 576, 55, 119, 65, 69, 68, 54, 53, 425, 575, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 39, 40, 33, 577, 578, 38, 35, 36, 83, 85, 86, 92, 93, 99, 121, 104, 105, 113, 117, 118, 120, 122, 124, 125, 126, 127, 128, 133, 134, 135, 137, 138, 139, 142, 152, 153, 154, 159, 167, 168, 169, 174, 176, 177, 182, 183, 184, 185, 186, 187, 190, 193, 197, 202, 203, 204, 210, 214, 220, 222, 223, 224, 228, 227, 229, 230, 242, 243, 247, 256, 257, 258, 265, 266, 269, 275, 276, 277, 278, 282, 296, 297, 304, 309, 318, 319, 320, 321, 325, 327, 328, 335, 336, 337, 341, 342, 349, 356, 360, 361, 373, 375, 383, 389, 392, 394, 397, 398, 400, 411, 414, 415, 416, 417, 426, 427, 428, 440, 442, 443, 444, 445, 446, 449, 450, 456, 457, 460, 462, 466, 469, 480, 481, 493, 499, 500, 504, 505, 508, 510, 511, 514, 516, 519, 520, 521, 522, 523, 526, 541, 542, 543, 550, 555, 556, 560, 561, 563, 566, 581, 582, 585, 590, 591, 595, 143, 437, 144, 255, 429, 430, 431, 145, 432, 433, 434, 435, 436, 3, 263, 75, 32, 129, 26, 27, 28, 382, 31, 472, 267, 283, 419, 420, 422, 421, 189, 34, 7, 10, 322, 73, 147, 148, 166, 418, 553, 554, 30, 211, 213, 162, 163, 259, 149, 150, 270, 157, 160, 239, 94, 95, 146, 100, 101, 102, 103, 424, 22, 172, 175, 179, 196, 287, 315, 438, 528, 4, 350, 367, 381, 24, 453, 5, 199, 6, 11, 12, 18, 19, 20, 21, 23, 140, 289, 161, 8, 509, 512, 300, 489, 483, 484, 485, 486, 487, 515, 569) or ticket.idProject is null) and ticket.idProject not in (0, 16, 29, 13, 15, 553, 94, 101, 199) ) or (ticket.idProject=16 ) or (ticket.idProject=29 ) or (ticket.idProject=13 ) or (ticket.idProject=15 ) or (ticket.idProject=553 ) or (ticket.idProject=94 ) or (ticket.idProject=101 ) or (ticket.idProject=199 ) ) and ( ((ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource=3) ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser=3) )) ) order by ticket.id desc
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] Strack trace :
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:794]
2022-08-25 12:15:06.733 ***** ERROR ***** [V10.0.4] #1 include called at [/var/www/html/projeqtor/view/print.php:288]