Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007745TestLinkDatabase MS-SQLpublic2016-11-14 16:002016-11-15 11:08
Assigned To 
PlatformOSOS Version
Product Version1.9.15 (2015 Q4) 
Fixed in Version 
Summary0007745: Installing plugin failure on MSSQL
DescriptionColumn name on plugins table incorrect
Invalid column name 'id'. - /* debugMsg */ SELECT id, basename, enabled FROM plugins. plugins table gets created with plugin_id column instead of id column in install\sql\mssql\testlink_create_tables.sql

Cannot insert the value NULL into column 'author_id', table 'testlink.dbo.plugins'; column does not allow nulls. INSERT fails.

The author_id column has a NOT NULL clause in the install\sql\mssql\testlink_create_tables.sql script. Removing the NOT, dropping the table and re-creating with a NULL clause on author_id solves the problem. The insert statement only specifies basename and enabled columns, therefor any NOT NULL columns without a default clause will cause a failure.
Steps To ReproduceInstall on MSSQL after fixing issue according to 0007743
TagsNo tags attached.
Database (MySQL,Postgres,etc)MSSQL
PHP Version
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
buzzlightyear (reporter)
2016-11-15 11:08

Code from lib\functions\plugin_api.php:

$sql = "/* $debugMsg */ INSERT INTO {$tables['plugins']} (basename,enabled) " .

- Issue History
Date Modified Username Field Change
2016-11-14 16:00 buzzlightyear New Issue
2016-11-15 11:08 buzzlightyear Note Added: 0025565

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker