Forum

[SOLVED] CSV extrac...
 
Notifications
Retirer tout

[SOLVED] CSV extract tickets

2 Posts
2 Utilisateurs
0 Reactions
1,443 Vu
(@pdecloedt)
Posts: 165
Active Member
Début du sujet
 
[#8440]

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]
 


 
Posté : 25 Août PM 14:088
(@babynus)
Posts: 14952
Membre Admin
 

There is a reference to non existing field "test".
Possibly you created it and restored DB without clening customization.
Clean customization for Ticket. (remove test field)


 
Posté : 25 Août PM 16:088
Share:
Retour en haut