[SOLVED] Unable to see the test cases / Test scenario

I have this weird situation knocking on my head...

I have 9 different users with same profile QA Team: I haven't made changes in the access permissions and it is as per earlier version [5.2.1]. Admin of course has all the access.

I have created some Test cases (simple) and some other data. When I am trying to see the tickets from ticket screen, its not showing to all users except 1.
I have thoroughly checked all the access permissions and visibility settings, but I could not find the reason for this weird behavior. Even there is no error in the log file. So where am I going wrong?

Showing below error as per log file.

NEW CONNECTED USER 'devendra'
2016-05-10 19:16:14.471 ===== TRACE ===== DISCONNECTED USER 'devendra'
2016-05-10 19:16:21.832 ===== TRACE ===== NEW CONNECTED USER 'admin'
2016-05-10 19:16:31.298 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'testcase.idProductOrComponent' in 'on clause'
2016-05-10 19:16:31.298 ***** ERROR ***** For query : select testcase.id as id, T1.name as nameProject, T2.name as nameProduct, T3.name as nameVersion, T4.name as nameTestCaseType, testcase.name as name, convert(concat(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) using utf8) as colorNameRunStatus, convert(concat(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8) as colorNameStatus, T7.fullName as nameResource, testcase.idResource as idResource, testcase.handled as handled, testcase.done as done, testcase.idle as idle, testcase.externalReference as externalReference, T8.name as nameTestCase, convert(concat(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) using utf8) as colorNamePriority, T10.name as nameProductOrComponent,testcase.idProject as idproject from testcase left join project as T1 on testcase.idProject = T1.id left join product as T2 on testcase.idProduct = T2.id left join version as T3 on testcase.idVersion = T3.id left join type as T4 on testcase.idTestCaseType = T4.id left join runstatus as T5 on testcase.idRunStatus = T5.id left join status as T6 on testcase.idStatus = T6.id left join resource as T7 on testcase.idResource = T7.id left join testcase as T8 on testcase.idTestCase = T8.id left join priority as T9 on testcase.idPriority = T9.id left join product as T10 on testcase.idProductOrComponent = T10.id where testcase.idle=0 and ( (testcase.idProject not in (0) or testcase.idProject is null ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idResource='1') ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idUser='1') ) ) order by testcase.id desc
2016-05-10 19:16:31.298 ***** ERROR ***** Strack trace :
2016-05-10 19:16:31.298 ***** ERROR ***** #0 Sql->query called at [D:\ProjeQtorWebSite\tool\jsonQuery.php:530]
2016-05-10 19:20:27.083 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'testcase.idProductOrComponent' in 'on clause'
2016-05-10 19:20:27.083 ***** ERROR ***** For query : select testcase.id as id, T1.name as nameProject, T2.name as nameProduct, T3.name as nameVersion, T4.name as nameTestCaseType, testcase.name as name, convert(concat(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) using utf8) as colorNameRunStatus, convert(concat(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) using utf8) as colorNameStatus, T7.fullName as nameResource, testcase.idResource as idResource, testcase.handled as handled, testcase.done as done, testcase.idle as idle, testcase.externalReference as externalReference, T8.name as nameTestCase, convert(concat(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) using utf8) as colorNamePriority, T10.name as nameProductOrComponent,testcase.idProject as idproject from testcase left join project as T1 on testcase.idProject = T1.id left join product as T2 on testcase.idProduct = T2.id left join version as T3 on testcase.idVersion = T3.id left join type as T4 on testcase.idTestCaseType = T4.id left join runstatus as T5 on testcase.idRunStatus = T5.id left join status as T6 on testcase.idStatus = T6.id left join resource as T7 on testcase.idResource = T7.id left join testcase as T8 on testcase.idTestCase = T8.id left join priority as T9 on testcase.idPriority = T9.id left join product as T10 on testcase.idProductOrComponent = T10.id where testcase.idle=0 and ( (testcase.idProject not in (0) or testcase.idProject is null ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idResource='1') ) and (testcase.idProject not in (0) or testcase.idProject is null or (testcase.idUser='1') ) ) order by testcase.id desc
2016-05-10 19:20:27.083 ***** ERROR ***** Strack trace :
2016-05-10 19:20:27.083 ***** ERROR ***** #0 Sql->query called at [D:\ProjeQtorWebSite\tool\jsonQuery.php:530]

Hi,
If we make the change in query & modify as per below, it gives the result as expected, but need to know the cause of records are visible to one user but not to other users. If query is not correct then should have not shown the records to any one.

SELECT testcase.id AS id, T1.name AS nameProject, T2.name AS nameProduct, T3.name AS nameVersion, T4.name AS nameTestCaseType, testcase.name AS NAME, CONVERT(CONCAT(T5.sortOrder,'#split#',T5.name,'#split#',COALESCE(T5.color,'')) USING utf8) AS colorNameRunStatus,
CONVERT(CONCAT(T6.sortOrder,'#split#',T6.name,'#split#',COALESCE(T6.color,'')) USING utf8) AS colorNameStatus, T7.fullName AS nameResource, testcase.idResource AS idResource,
testcase.handled AS handled, testcase.done AS done, testcase.idle AS idle, testcase.externalReference AS externalReference, T8.name AS nameTestCase,
CONVERT(CONCAT(T9.sortOrder,'#split#',T9.name,'#split#',COALESCE(T9.color,'')) USING utf8) AS colorNamePriority, T10.name AS nameProductOrComponent,
testcase.idProject AS idproject FROM testcase LEFT JOIN project AS T1 ON testcase.idProject = T1.id
LEFT JOIN product AS T2 ON testcase.idProduct = T2.id LEFT JOIN VERSION AS T3 ON testcase.idVersion = T3.id
LEFT JOIN TYPE AS T4 ON testcase.idTestCaseType = T4.id LEFT JOIN runstatus AS T5 ON testcase.idRunStatus = T5.id
LEFT JOIN STATUS AS T6 ON testcase.idStatus = T6.id LEFT JOIN resource AS T7 ON testcase.idResource = T7.id
LEFT JOIN testcase AS T8 ON testcase.idTestCase = T8.id LEFT JOIN priority AS T9 ON testcase.idPriority = T9.id
LEFT JOIN product AS T10 ON testcase.idProduct = T10.id WHERE testcase.idle=0 AND
( (testcase.idProject NOT IN (0) OR testcase.idProject IS NULL ) AND
(testcase.idProject NOT IN (0) OR testcase.idProject IS NULL OR (testcase.idResource='1') ) AND
(testcase.idProject NOT IN (0) OR testcase.idProject IS NULL OR (testcase.idUser='1') ) )
ORDER BY testcase.id DESC