Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008480TestLinkInstallerpublic2018-11-19 17:142019-03-12 22:45
Reportermichalexvr 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformLinuxOSFedoraOS Version28
Product Version1.9.18 (2018 Q3) 
Fixed in Version1.9.20 Raijing DEV 
Summary0008480: Tables Prefix throws an SQL exception at installation
DescriptionIf you put an table prefix in the installation configurations, throws an SQL exception at installation
Steps To ReproduceIn the first installation step, if you put an table prefix, and then installation script returns an installation error.

Reviewing the logs, i found this message:

[>>][5bf0c80e84412827432282][DEFAULT][/testlink/install/installNewDB.php][18/Nov/18 02:01:50]
    [18/Nov/18 02:01:52][ERROR][<nosession>][DATABASE]
        ERROR ON exec_query() - database.class.php
1146 - Table 'testlink.latest_req_version' doesn't exist - CREATE OR REPLACE VIEW tllatest_req_version_id
AS SELECT
   LRQVN.req_id AS req_id,
   LRQVN.version AS version,
   REQV.id AS req_version_id
FROM latest_req_version LRQVN
JOIN tlnodes_hierarchy NHRQV
ON NHRQV.parent_id = LRQVN.req_id
JOIN tlreq_versions REQV
ON REQV.id = NHRQV.id AND REQV.version = LRQVN.version
THE MESSAGE : CREATE OR REPLACE VIEW tllatest_req_version_id
AS SELECT
   LRQVN.req_id AS req_id,
   LRQVN.version AS version,
   REQV.id AS req_version_id
FROM latest_req_version LRQVN
JOIN tlnodes_hierarchy NHRQV
ON NHRQV.parent_id = LRQVN.req_id
JOIN tlreq_versions REQV
ON REQV.id = NHRQV.id AND REQV.version = LRQVN.version
Query failed: errorcode[1146]
    errormsg:Table 'testlink.latest_req_version' doesn't exist
[<<][5bf0c80e84412827432282][DEFAULT][/testlink/install/installNewDB.php][18/Nov/18 02:01:50][18/Nov/18 02:01:52][took 1.588996 secs]
Additional Informationthe module that charges the tables does not create the views using this prefix defined by the user in the previous step, but creates the tables correctly adding it, so the installation stops and return the error message.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MariaDB 10.2.18
BrowserFirefox 62.0.3
PHP VersionPHP 7.2.11
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships

-  Notes
(0028592)
fman (administrator)
2019-03-12 22:45

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/d0fb5b1cb2b5d55dab35fba8e242ed573143ccf5 [^]
(0028593)
fman (administrator)
2019-03-12 22:45

also on branch 1.9.19.01

- Issue History
Date Modified Username Field Change
2018-11-19 17:14 michalexvr New Issue
2019-03-12 22:37 fman Note Added: 0028591
2019-03-12 22:37 fman Note Deleted: 0028591
2019-03-12 22:45 fman Note Added: 0028592
2019-03-12 22:45 fman QA Team - Task Workflow Status => READY FOR TESTING
2019-03-12 22:45 fman Note Added: 0028593
2019-03-12 22:45 fman Status new => resolved
2019-03-12 22:45 fman Fixed in Version => 1.9.20 Raijing DEV
2019-03-12 22:45 fman Resolution open => fixed
2019-03-12 22:45 fman Assigned To => fman



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker