View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] CSV extract tickets - ProjeQtOr
 

[SOLVED] CSV extract tickets

More
25 Aug 2022 12:20 #1 by pdecloedt
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]
 

Please Log in or Create an account to join the conversation.

More
25 Aug 2022 14:33 - 25 Aug 2022 14:33 #2 by babynus
Replied by babynus on topic CSV extract tickets
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)

Babynus
Administrator of ProjeQtOr web site
Last edit: 25 Aug 2022 14:33 by babynus.
The following user(s) said Thank You: pdecloedt

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.047 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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