View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
19554Bug reportsInstallationpublic2024-05-05 22:572026-10-26 22:54
Reporterriqcles Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status resolvedResolutionfixed 
Product Version6.5.x 
Summary19554: Plugins - impossible to integrate plugins after migration
Description

Hi there, I noticed that I cannot install plugins after migrating from version 3.22 to 6.5.4

SQL : SQlstate [23502] : Not null violation : 7 ERROR : null value in column "active" of relation "lime_plugins" vilates not-null constraint

DETAIL: Failing row contains (8, statFonctions, null, 0.2.1, null, null, core, 0).

The following command needs to be executed: ALTER TABLE public.lime_plugins ALTER COLUMN active SET DEFAULT 0; However, this fails due to the NOT NULL constraint on the active column and the lack of a default value.

Link in French : https://forums.limesurvey.org/forum/french-forum/154570-plugins-migration-v3-22-6-5-4-et-plus#263253

Denis Chenu say :
the error comes from further away :

github.com/LimeSurvey/LimeSurvey/blob/62...s/Update_175.php#L12
github.com/LimeSurvey/LimeSurvey/blob/18...edb_helper.php#L1170

thank !

Steps To Reproduce

Steps to reproduce

update an old version to 6.5.4
go to plugins
add an existing plugin (like some of core of limesurvey)

Expected result

the plugin is added

Actual result

Crash.

TagsNo tags attached.
Attached Files
2024_05_03_Plugins_migration.pdf (480,199 bytes)
Bug heat2
Complete LimeSurvey version number (& build)LimeSurvey Community Edition Version 6.4.5+240205
I will donate to the project if issue is resolvedNo
BrowserFirefox / Chrome
Database type & versionPostgresql 15
Server OS (if known)centos 7.9
Webserver software & version (if known)Apache/2.4. (CentOS) PHP/8.2
PHP VersionPHP Version 8.2
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2026-10-26 22:53

administrator   ~86884

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=41094
c_schmitz

c_schmitz

2026-10-26 22:54

administrator   ~86885

Fixed for future updates. If you already updated and get this error when installing a plugin, run this once in your PostgreSQL database (replace lime_ if you use a different table prefix):

ALTER TABLE lime_plugins ALTER COLUMN active SET DEFAULT 0;

After that, plugins can be installed normally.

Related Changesets

LimeSurvey: master d2c715a2

2026-10-26 22:52

c_schmitz


Details Diff		 Fixed issue 19554: On PostgreSQL installations upgraded from very old versions, installing a plugin failed with a database error
Dev Update_175 now sets default 0 on plugins.active for pgsql, like on the other databases		 Affected Issues
19554
mod - application/helpers/update/updates/Update_175.php Diff File

Issue History

Date Modified Username Field Change
2024-05-05 22:57 riqcles New Issue
2024-05-05 22:57 riqcles File Added: 2024_05_03_Plugins_migration.pdf
2026-10-26 22:53 c_schmitz Changeset attached => LimeSurvey master d2c715a2
2026-10-26 22:53 c_schmitz Note Added: 86884
2026-10-26 22:53 c_schmitz Assigned To => c_schmitz
2026-10-26 22:53 c_schmitz Status new => resolved
2026-10-26 22:53 c_schmitz Resolution open => fixed
2026-10-26 22:53 c_schmitz Bug heat 0 => 2
2026-10-26 22:54 c_schmitz Note Added: 86885