[INTROPAGE] latest version - DB error

[anarkia1976]

Hi @xmacan

2026-02-11 11:52:30 - CMDPHP SQL Backtrace: (/plugins/intropage/intropage.php[47]:process_page_request_variables(), /plugins/intropage/include/functions.php[85]:intropage_reload_panel(), /plugins/intropage/include/functions.php[801]:busiest_cpu(), /plugins/intropage/panellib/busiest.php[226]:db_fetch_assoc(), /lib/database.php[781]:db_fetch_assoc_prepared(), /lib/database.php[801]:db_execute_prepared())
2026-02-11 11:52:30 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1

thanks a lot

[anarkia1976]

2026-02-11 11:55:36 - CMDPHP SQL Backtrace: (/plugins/intropage/intropage.php[47]:process_page_request_variables(), /plugins/intropage/include/functions.php[85]:intropage_reload_panel(), /plugins/intropage/include/functions.php[801]:plugin_syslog_devices(), /plugins/intropage/panellib/syslog.php[395]:syslog_db_fetch_assoc_prepared(), /plugins/syslog/database.php[167]:db_fetch_assoc_prepared(), /lib/database.php[801]:db_execute_prepared())
2026-02-11 11:55:36 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1

[anarkia1976]

2026-02-11 13:36:11 - DBCALL ERROR: Column: height contains an invalid value: normal
2026-02-11 13:36:11 - DBCALL ERROR: Column: height contains an invalid value: normal

[xmacan]

I think it is caused by update code and not db. This can happen when you update from git from a branch and the plugin version is the same.

alter table plugin_intropage_panel_definition drop height;
ALTER TABLE plugin_intropage_panel_definition ADD COLUMN height enum("normal","double","triple") NOT NULL DEFAULT "normal";
alter table plugin_intropage_panel_data drop height;
ALTER TABLE plugin_intropage_panel_data ADD COLUMN height enum("normal","double","triple") NOT NULL DEFAULT "normal"'

[anarkia1976]

Hi @xmacan ,

I didn't quite understand the problem, I also tried reinstalling and rebuilding with a clean clone from git repository but it's not working.

thanks