Mantis Bugtracker          
testlink.org

View Revisions: Issue #8670 All Revisions ] Back to Issue ]
Summary 0008670: Full text search - DB Access Error - Data too long for column 'Dirty'
Revision 2019-05-23 21:08 by fman
Description No matter what i am searching for, i get an DB Access Error on full test search always.

This is the entry in userlog: (i think the number of testcases could be a problem) We are now at a point, where the number of users and testcases leeds up to more and more errors in TestLink.


[19/May/21 12:27:49][ERROR][5e3869771811c14245bd190db289265d][DATABASE]
ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'Dirty' at row 1 - SELECT LVN.testcase_id,



Query failed: errorcode[1406]
    errormsg:Data too long for column 'Dirty' at row 1
Revision 2019-05-23 21:07 by fman
Description No matter what i am searching for, i get an DB Access Error on full test search always.

This is the entry in userlog: (i think the number of testcases could be a problem) We are now at a point, where the number of users and testcases leeds up to more and more errors in TestLink.


[19/May/21 12:27:49][ERROR][5e3869771811c14245bd190db289265d][DATABASE]
ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'Dirty' at row 1 - SELECT LVN.testcase_id,


NH_TC.name, TCV.id AS tcversion_id, TCV.summary, TCV.version, TCV.tc_external_id FROM latest_tcase_version_number LVN JOIN nodes_hierarchy NH_TC ON NH_TC.id = LVN.testcase_id JOIN nodes_hierarchy NH_TCV ON NH_TCV.parent_id = NH_TC.id JOIN tcversions TCV ON NH_TCV.id = TCV.id AND TCV.version = LVN.version LEFT OUTER JOIN nodes_hierarchy NH_TCSTEPS ON NH_TCSTEPS.parent_id = NH_TCV.id LEFT OUTER JOIN tcsteps TCSTEPS ON NH_TCSTEPS.id = TCSTEPS.id WHERE LVN.testcase_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063
,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881
,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,
413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526
,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571
,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,
489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,
524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,6172
4,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61
776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835
,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,6
1895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,619
54,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,6201
6,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63
591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,
199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,2267
66,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,29383
0,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626
,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,
425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,4
25621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,44
6800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,56
3066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563
140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213
,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,
563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,
563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,56386
0,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,5639
90,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND NH_TCV.parent_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND (/* filterSpecial */ 1=0 OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.actions) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.expected_results) LIKE '%meier%' ) OR ( 1=0 or NH_TC.name LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.summary) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.preconditions) LIKE '%meier%' ))
THE MESSAGE : SELECT LVN.testcase_id, NH_TC.name, TCV.id AS tcversion_id, TCV.summary, TCV.version, TCV.tc_external_id FROM latest_tcase_version_number LVN JOIN nodes_hierarchy NH_TC ON NH_TC.id = LVN.testcase_id JOIN nodes_hierarchy NH_TCV ON NH_TCV.parent_id = NH_TC.id JOIN tcversions TCV ON NH_TCV.id = TCV.id AND TCV.version = LVN.version LEFT OUTER JOIN nodes_hierarchy NH_TCSTEPS ON NH_TCSTEPS.parent_id = NH_TCV.id LEFT OUTER JOIN tcsteps TCSTEPS ON NH_TCSTEPS.id = TCSTEPS.id WHERE LVN.testcase_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND NH_TCV.parent_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND (/* filterSpecial */ 1=0 OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.actions) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.expected_results) LIKE '%meier%' ) OR ( 1=0 or NH_TC.name LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.summary) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.preconditions) LIKE '%meier%' ))


Query failed: errorcode[1406]
    errormsg:Data too long for column 'Dirty' at row 1
Revision 2019-05-21 13:18 by stef-lhm
Description No matter what i am searching for, i get an DB Access Error on full test search always.

This is the entry in userlog: (i think the number of testcases could be a problem) We are now at a point, where the number of users and testcases leeds up to more and more errors in TestLink.

    [19/May/21 12:27:49][ERROR][5e3869771811c14245bd190db289265d][DATABASE]
        ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'Dirty' at row 1 - SELECT LVN.testcase_id, NH_TC.name, TCV.id AS tcversion_id, TCV.summary, TCV.version, TCV.tc_external_id FROM latest_tcase_version_number LVN JOIN nodes_hierarchy NH_TC ON NH_TC.id = LVN.testcase_id JOIN nodes_hierarchy NH_TCV ON NH_TCV.parent_id = NH_TC.id JOIN tcversions TCV ON NH_TCV.id = TCV.id AND TCV.version = LVN.version LEFT OUTER JOIN nodes_hierarchy NH_TCSTEPS ON NH_TCSTEPS.parent_id = NH_TCV.id LEFT OUTER JOIN tcsteps TCSTEPS ON NH_TCSTEPS.id = TCSTEPS.id WHERE LVN.testcase_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND NH_TCV.parent_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND (/* filterSpecial */ 1=0 OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.actions) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.expected_results) LIKE '%meier%' ) OR ( 1=0 or NH_TC.name LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.summary) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.preconditions) LIKE '%meier%' ))
THE MESSAGE : SELECT LVN.testcase_id, NH_TC.name, TCV.id AS tcversion_id, TCV.summary, TCV.version, TCV.tc_external_id FROM latest_tcase_version_number LVN JOIN nodes_hierarchy NH_TC ON NH_TC.id = LVN.testcase_id JOIN nodes_hierarchy NH_TCV ON NH_TCV.parent_id = NH_TC.id JOIN tcversions TCV ON NH_TCV.id = TCV.id AND TCV.version = LVN.version LEFT OUTER JOIN nodes_hierarchy NH_TCSTEPS ON NH_TCSTEPS.parent_id = NH_TCV.id LEFT OUTER JOIN tcsteps TCSTEPS ON NH_TCSTEPS.id = TCSTEPS.id WHERE LVN.testcase_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND NH_TCV.parent_id IN (52370,52372,52374,67439,111211,124510,659266,52376,80163,80265,376517,63589,197038,64547,598450,129063,182437,189044,189049,347785,347790,204810,204812,218917,218962,243893,243891,243888,278684,360881,403744,371497,371499,376515,376508,389314,389363,403314,503670,504550,412442,412446,412462,413304,413371,423614,441404,441460,575470,447626,447645,448082,448084,459409,484270,533436,449521,449526,449541,449546,449556,449576,449586,449596,449761,449770,449531,449536,449551,449561,449566,449571,449581,449591,449601,467976,476808,476811,477924,477926,477928,489647,489692,489652,489697,489657,489702,489662,489707,489667,489712,489672,489677,489682,489687,489765,491835,504685,504698,554482,524871,524876,524881,524886,524891,563982,564050,52438,52442,52440,52546,61712,61715,61718,61721,61724,61727,61730,61733,61736,61739,61742,61745,418176,61749,61752,61755,61758,61761,61764,61767,61770,61773,61776,61779,61782,61785,61788,61791,61794,61797,61800,61803,61806,61808,61810,61812,61815,61825,61829,61835,61839,61842,61846,61849,61852,61855,61859,61862,61865,61869,61872,61875,61878,61881,61885,61889,61892,61895,61898,61901,61905,61908,61912,61916,61919,61923,61926,61929,61932,61935,61938,61942,61946,61950,61954,61957,61960,61963,61966,61969,61972,61975,61978,61981,61984,61988,61992,62001,62004,62009,62013,62016,62019,62022,62025,62029,62040,62053,62063,62074,62085,62096,336739,62105,62113,63645,63647,63559,63591,63593,63563,63565,63567,189706,199115,199119,199123,199127,199130,199135,199141,199147,199151,199155,199157,199161,199164,199168,208992,208996,221961,221959,221957,221955,219676,226760,226762,226764,226766,226768,226770,226772,226774,226776,274912,461116,344529,459342,347770,293825,293823,293827,293830,293832,293834,293836,316986,316988,316990,316992,316994,316996,316998,389633,369213,389621,389626,389422,395542,395549,395556,389491,397388,397439,425537,425541,425545,425549,425553,425557,425561,425565,425569,425573,425577,425581,425585,425589,425593,425597,425601,425605,425609,425613,425617,425621,425625,425629,425633,425637,425641,425645,425649,412452,425409,407831,407833,436347,446796,446800,503639,503644,596778,506448,524856,524851,524861,524866,563055,563057,563059,563061,563063,563066,563073,563076,563085,563089,563092,563095,563102,563108,563125,563128,563131,563133,563135,563140,563142,563144,563150,563156,563166,562391,562769,562771,562773,562775,592626,592641,563147,563213,563426,563215,563217,563219,563221,563224,563226,563229,563232,563234,563236,563240,564126,564446,563277,563280,563285,563290,563293,563314,563326,563331,563864,563337,563351,563360,563363,563381,563396,563442,563460,563481,564269,564293,564469,563848,563850,563854,563852,563856,563858,563860,563862,563868,563878,563880,563939,563958,563960,563962,563967,563969,563973,563975,563985,563990,564028,564145,564039,564041,564043,564046,564048,564052,564056,564060,564070,564150,564074,564115,564131,564134,564136,564140,564143,564058,564202,564255,564257,564259,564261,564263,564265,564272,564275,564278,564288,564370,564373,564386,564393,564398,564418,564422,564471,565845,565847,565850,565852,592620,592754,592784,592756,593630,659870,121005,121008,121010,122009,120999,121003,121001,122011,122007,129111,129087,175633,175640,175739,189040,189042,189057,189059,189047,189051,189053,189037,195099,198976,198980,198984,198988,198992,199001,199011,199014,199017,199021,199024,199027,199032,199035,199038,199041,199045,199049,199054,199059,199064,199068,199073,199078,199086,199090,199094,199098,199102,199106,199110,290893,290895,290897,290899,290901,290903,290905,297783,297785,297787,297789,297791,297793,297795,297797,297802,297807,297812,297817,297822,297827,297832,297837,297842,297847,297852,297857,297862,297867,297872,297877,297882,297887,297892,297897,297902,297907,297912,297917,297922,297927,297929,297934,297939,297944,297949,354127,354135,354143,354148,354155,354162,354169,354176,354179,354183,354193,354198,354204,354212,354217,354223,354229,354238,354242,354246,354251,354255,354260,354268,354273,354283,354291,354299,354304,354312,354316,354326,354333,354337,354345,354352,354356,354360,354368,354373,354377,354386,354390,354395,354399,354404,354409,354413,354417,354422,354428,354438,354445,354452,354456,354464,354469,354474,354480,354486,354493,354497,354505,354509,354516,354521,354525,354529,354536,354544,354549,354554,354563,354569,354573,354577,354582,354590,354598,354601,354610,354618,354626,354633,354640,354648,354652,354659,354664,354669,354674,354680,354690,354693,354700,354706,354720,354725,354732,354741,354751,354770,354774,354778,354786,354792,354799,354804,354808,354812,354816,354820,354824,354828,354832,354837,354841,354845,354852,354858,354866,354870,354873,354877,354888,404523,444226,425495,425515,425522,427419,427423,427427,427431,427435,427439,427443,427447,427451,427455,427459,427463,427467,427471,427475,427479,427483,427487,427491,427495,427499,427503,427507,427511,427515,427519,427523,427527,427531,427535,427539,427543,427547,427551,427555,427559,427563,427567,427571,427575,427579,427583,427587,427591,427595,427599,427603,427607,427611,427615,427619,427623,427627,427631,487233,487239,487246,487253,487307,487311,487317,487322,487326,487330,487334,487338,487346,487350,487354,487357,487363,487370,487374,487377,534065,534069,534072,534079,534088,534099,534105,534114,534123,534138,534148,534156,534164,534174,534186,534198,534207,545097,554488,129072,130236,317031,317033,317035,317037,317039,317041,317043,349272,349276,349281,349285,349290,407845,407851,407857,407863,407870,407876,407882,407888,487021,487029,487033,487037,487040,487045,487049,487057,487126,487133,487140,487143,487146,487149,487153,487156,487159,487163,487166,487170,487176,487183,487191,487208,487216,487220,487224,487227,487261,487266,487273,487279,487287,487295,487304,562793,562796,565178,129339,129393,430724,429086,429090,429094,429098,429102,429106,429110,429114,429119,429123,429127,429131,429135,429139,429143,429147,429151,429155,429168,429172,429176,429180,429184,429188,429194,429198,429202,429206,429210,429214,429218,429223,429227,429231,429235,429239,429243,429247,429251,429255,429259,429263,429267,435192,435199,435206,435210,435217,435224,435228,435232,435236,486969,486974,486979,486983,486988,486995,487001,487007,487012,487019,487063,487066,487070,487078,487088,487096,487106,487114,487124,487198,487203) AND (/* filterSpecial */ 1=0 OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.actions) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCSTEPS.expected_results) LIKE '%meier%' ) OR ( 1=0 or NH_TC.name LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.summary) LIKE '%meier%' ) OR ( 1=0 or UDFStripHTMLTags(TCV.preconditions) LIKE '%meier%' ))
Query failed: errorcode[1406]
    errormsg:Data too long for column 'Dirty' at row 1



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker