Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008506TestLinkDatabase Postgrespublic2018-12-17 09:532018-12-17 15:35
Reportergunnar 
Assigned Tofman 
PrioritynormalSeverityblockReproducibilityalways
StatusfeedbackResolutionopen 
PlatformlinuxOSdebianOS Version
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008506: login not possible after upgrade 1.9.17 -> 1.9.18
Descriptionlogin not possible after upgrade 1.9.17 -> 1.9.18

sql statement is missing something after AND: ..." AND ORDER BY name"

for full "stack trace" see attached txt
Steps To Reproduceupgarde from 1.9.17 -> 1.9.18.
Run both sql scripts in DB.1.9.18.
open index.php in browser
Additional Informationpostgresql-9.4-main.log:

2018-12-17 10:30:58 CET [1320-1] testlink@testlink ERROR: syntax error at or near "ORDER" at character 489
2018-12-17 10:30:58 CET [1320-2] testlink@testlink STATEMENT: /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role, USER_TPLAN_ROLES.role_id AS user_testplan_role, TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 2 WHERE testproject_id = 1 AND active = 1 AND NH.id = 18198 AND ORDER BY name
TagsNo tags attached.
Database (MySQL,Postgres,etc)postgres
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Filestxt file icon psql.txt [^] (17,206 bytes) 2018-12-17 09:53 [Show Content]

- Relationships

-  Notes
(0028326)
fman (administrator)
2018-12-17 15:35

please do fresh install using latest code from github, retest & provide feedback

- Issue History
Date Modified Username Field Change
2018-12-17 09:53 gunnar New Issue
2018-12-17 09:53 gunnar File Added: psql.txt
2018-12-17 15:35 fman Note Added: 0028326
2018-12-17 15:35 fman Assigned To => fman
2018-12-17 15:35 fman Status new => feedback



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker