Google Analytics Plugin - DB Error OJS


I noticed that google analytics plugin is saving entries into plugin_settings with setting_type = boolean instead of bool, it’s causing a DB ERROR:

ERROR: value too long for type character varying(6)
STATEMENT: INSERT INTO plugin_settings
(plugin_name, journal_id, setting_name, setting_value, setting_type)
( $1, $2, $3, $4, $5)

And after

LOG: statement: ALTER TABLE “public”.“plugin_settings” ALTER COLUMN “setting_type” TYPE Character Varying( 7 ) COLLATE “pg_catalog”.“default”;

No errors are printed.

This error only happens when I select “Enable this journal’s settings on the site homepage” or “Disable existing settings on the site homepage”

Best regards,

Tarcisio Pereira

This has been submitted as a Git Issue with an attached fix:

Thanks for reporting!

1 Like