Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008416TestLinkDatabase MySQLpublic2018-10-17 10:272018-10-31 16:56
Reporterall-it 
Assigned Tofman 
PrioritynormalSeverityblockReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOSOS Version
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008416: We get an error when we add test cases
DescriptionDB Access Error - debug_print_backtrace() OUTPUT START
 ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
            Having this additional Information could be useful for reporting
            issue to development TEAM.
Steps To Reproduce1. go to - add/remove test cases
2. choose test cases
3. click on add/remove test cases
4. error
Additional InformationI catch this error only when I run the whole tests.
I have tried to grant all privileges to user bn_testlink on DB bitnami_testlink.* but without success too. I got the same error.

I can go down following the tree and run all tests in the subdirectory, in this case, tests are passed without error but not all of them. Some tests are not marked. I can mark them again, and run tests with the same result.

Next, I can go deeper to the subfolder, mark tests and run them. Tests are passed.

And at last, I can go back to the parent folder and try to check all test cases for adding and run them. Now I do not receive any errors.

I use all values with their defaults, as described at README.txt
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL 5.7.23 - build in the bundle
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028031)
fman (administrator)
2018-10-17 16:58

>> I catch this error only when I run the whole tests.
IMHO using the term run is misleading

Please enable more debug or unfortunately it will be impossible to help you
(0028033)
all-it (reporter)
2018-10-18 07:44

If I understand you correctly then it relates to following file:
./apps/testlink/htdocs/third_party/adodb/adodb.inc.php
and change values:
var $debug = true

There were many SQL queryis but I think here is an issue:

(mysqli): /* Class:tlEvent - Method: writeToDB */ INSERT INTO events (transaction_id,log_level,description,source,fired_at,object_id,object_type,activity) VALUES (29,1,'ERROR ON exec_query() - database.class.php
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \')\' at line 1 - /* Class:testplan - Method: tcversionInfoForAudit */ SELECT TCV.id, tc_external_id, version, NHB.name FROM tcversions TCV,nodes_hierarchy NHA, nodes_hierarchy NHB WHERE NHA.id=TCV.id AND NHB.id=NHA.parent_id AND TCV.id IN (3734,3738,3743,3747,3750,3753,3757,3760,3763,3766,3769,3775,3786,3790,3797,3801,3808,3811,3814,3818,3822,3825,3831,3836,3840,3843,3848,3856,3862,3865,3869,3874,3880,3884,3889,3893,3896,3899,3904,3909,3913,3917,3920,3924,3927,3930,3933,3936,3939,3943,3948,3951,3954,3958,3961,3964,3969,3973,3977,3980,3983,3990,3993,3997,4001,4004,4007,4013,4017,4021,4028,4031,4035,4038,4042,4047,4050,4053,4058,4061,4064,4068,4072,4076,4080,4084,4089,4093,4096,4099,4103,4109,4114,4119,4124,4128,4133,4136,4139,4142,4146,4149,4152,4155,4161,4164,4168,4174,4180,4183,4187,4193,4198,4203,4208,4213,4217,4224,4228,4231,4235,4238,4249,4254,4261,4264,4269,4272,4275,4278,4281,4286,4289,4294,4297,4300,4303,4307,4312,4317,4322,4326,4330,4335,4341,4345,4353,4359,4366,4374,4383,4388,4393,4399,4406,4411,4417,4421,4425,4428,4431,4435,4440,4443,4446,4451,4456,4459,4462,4467,4476,4480,4485,4490,4494,4498,4503,4507,4510,4513,4517,4526,4530,4535,4540,4543,4546,4550,4553,4556,4561,4565,4574,4576,4578,4580,4582,4584,4586,4588,4590,4592,4594,4596,4599,4605,4608,4614,4621,4625,4628,4632,4636,4639,4643,4646,4651,4654,4657,4660,4663,4667,4674,4679,4685,4690,4694,4699,4702,4705,4709,4714,4719,4723,4729,4732,4736,4740,4745,4748,)
THE MESSAGE : /* Class:testplan - Method: tcversionInfoForAudit */ SELECT TCV.id, tc_external_id, version, NHB.name FROM tcversions TCV,nodes_hierarchy NHA, nodes_hierarchy NHB WHERE NHA.id=TCV.id AND NHB.id=NHA.parent_id AND TCV.id IN (3734,3738,3743,3747,3750,3753,3757,3760,3763,3766,3769,3775,3786,3790,3797,3801,3808,3811,3814,3818,3822,3825,3831,3836,3840,3843,3848,3856,3862,3865,3869,3874,3880,3884,3889,3893,3896,3899,3904,3909,3913,3917,3920,3924,3927,3930,3933,3936,3939,3943,3948,3951,3954,3958,3961,3964,3969,3973,3977,3980,3983,3990,3993,3997,4001,4004,4007,4013,4017,4021,4028,4031,4035,4038,4042,4047,4050,4053,4058,4061,4064,4068,4072,4076,4080,4084,4089,4093,4096,4099,4103,4109,4114,4119,4124,4128,4133,4136,4139,4142,4146,4149,4152,4155,4161,4164,4168,4174,4180,4183,4187,4193,4198,4203,4208,4213,4217,4224,4228,4231,4235,4238,4249,4254,4261,4264,4269,4272,4275,4278,4281,4286,4289,4294,4297,4300,4303,4307,4312,4317,4322,4326,4330,4335,4341,4345,4353,4359,4366,4374,4383,4388,4393,4399,4406,4411,4417,4421,4425,4428,4431,4435,4440,4443,4446,4451,4456,4459,4462,4467,4476,4480,4485,4490,4494,4498,4503,4507,4510,4513,4517,4526,4530,4535,4540,4543,4546,4550,4553,4556,4561,4565,4574,4576,4578,4580,4582,4584,4586,4588,4590,4592,4594,4596,4599,4605,4608,4614,4621,4625,4628,4632,4636,4639,4643,4646,4651,4654,4657,4660,4663,4667,4674,4679,4685,4690,4694,4699,4702,4705,4709,4714,4719,4723,4729,4732,4736,4740,4745,4748,)\nQuery failed: errorcode[1064]\n errormsg:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \')\' at line 1 ','DATABASE',1539848080,0,NULL,NULL)
(0028034)
fman (administrator)
2018-10-18 08:40

ok, this is a little bit better.
would you mind to export your test project, and send it to me in order to set the same scenario?
(0028148)
fman (administrator)
2018-10-31 16:56

no more user feedback

- Issue History
Date Modified Username Field Change
2018-10-17 10:27 all-it New Issue
2018-10-17 16:58 fman Note Added: 0028031
2018-10-17 16:58 fman Assigned To => fman
2018-10-17 16:58 fman Status new => feedback
2018-10-18 07:44 all-it Note Added: 0028033
2018-10-18 07:44 all-it Status feedback => assigned
2018-10-18 08:40 fman Note Added: 0028034
2018-10-18 08:40 fman Status assigned => feedback
2018-10-31 16:56 fman QA Team - Task Workflow Status => TBD
2018-10-31 16:56 fman Note Added: 0028148
2018-10-31 16:56 fman Status feedback => closed
2018-10-31 16:56 fman Resolution open => unable to reproduce



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker