Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008171TestLinkMigration/Upgrade Testlinkpublic2017-12-30 20:512017-12-31 19:01
Reporterlczub 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
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
*[TestLink-Dev]\install\sql\alter_tables\1.9.15\postgres\DB.1.9.15\step1\db_schema_update.sql*
```
CREATE TABLE /*prefix*/plugins (
   plugin_id BIGSERIAL NOT NULL,
```

*[TestLink-Dev]\install\sql\postgres\testlink_create_tables.sql*
```
CREATE TABLE /*prefix*/plugins (
   id BIGSERIAL NOT NULL,
```
TagsNo tags attached.
Database (MySQL,Postgres,etc)psql 9.6.6
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

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

thanks

- 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 - 2018 MantisBT Team
Powered by Mantis Bugtracker