Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008171TestLinkMigration/Upgrade Testlinkpublic2017-12-30 20:512017-12-31 19:01
Assigned To 
PlatformOSOS Version
Product Version1.9.16 (2016 Q4) 
Fixed in Version 
Summary0008171: plugin table structure differs between migrated psql and mysql db
DescriptionSelecting the main menu icon *Plugin* in a TL application, which uses a postgres DB, aborts with a *DB Access Error*.

Problem is reproducable with psql databases, initial build with TL 1.9.15 or migrated from a prior version.

Reason is, that the TL 1.9.15 sql install and migration scripts created a different *plugin* table structure for mysql than for psql and mysql (field *id* vs field *plugin_id*)

Problem does not occur with psql databases, initial build with TL 1.9.16 or latest TL 1.9.17 github commit fb05f46.

But the TL 1.9.15 sql migration scripst, delivered with TL 1.9.16 and latest TL 1.9.17 github commit fb05f46 still creates the wrong *plugin* table structure.
Steps To ReproduceDB Access Error after selecting the main menu icon *Plugin*
#0 database->exec_query(/* debugMsg */ SELECT id, basename, enabled FROM plugins) called at [/usr/local/www/testlink-1.9.16/lib/functions/plugin_api.php:562]
#1 get_all_installed_plugins() called at [/usr/local/www/testlink-1.9.16/lib/plugins/pluginView.php:52]

Additional Information
CREATE TABLE /*prefix*/plugins (
   plugin_id BIGSERIAL NOT NULL,

CREATE TABLE /*prefix*/plugins (
TagsNo tags attached.
Database (MySQL,Postgres,etc)psql 9.6.6
PHP Version
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
fman (administrator)
2017-12-31 19:01


- Issue History
Date Modified Username Field Change
2017-12-30 20:51 lczub New Issue
2017-12-31 19:01 fman Note Added: 0027132

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker