bluecherry 3:3.1.9
Debian12 package install
no layouts in database; save new layout with random name.
Saving a new one only seems a problem in brave browser.
==> /var/log/nginx/bluecherry-error.log <==
"https://192.168.10.73:7001/liveview"
2025/03/10 20:01:51 [error] 1934#1934: *367 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Data too long for column 'layout' at row 1 in /usr/share/bluecherry/www/lib/lib.php:245
Stack trace:
#0 /usr/share/bluecherry/www/lib/lib.php(245): mysqli_query()
#1 /usr/share/bluecherry/www/lib/lib.php(266): database->fetchAll()
#2 /usr/share/bluecherry/www/ajax/layouts.php(52): data::query()
#3 /usr/share/bluecherry/www/ajax/layouts.php(15): layouts->newLayout()
#4 /usr/share/bluecherry/www/ajax/liveview.php(16): layouts->postData()
#5 /usr/share/bluecherry/www/lib/Controller.php(119): liveview->postLayouts()
#6 /usr/share/bluecherry/www/lib/Route.php(75): Controller->start()
#7 /usr/share/bluecherry/www/index.php(16): Route->start()
#8 {main}
thrown in /usr/share/bluecherry/www/lib/lib.php on line 245" while reading response header from upstream, client: 192.168.10.59, server: , request: "POST /liveview/layouts HTTP/1.1", upstream: "fastcgi://unix:/etc/alternatives/php-fpm.sock:", host: "192.168.10.73:7001", referrer: "https://192.168.10.73:7001/liveview"
firefox does save layouts, but those are not loading.
2025/03/10 20:08:09 [error] 1937#1937: *1285 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "{test2}" in /usr/share/bluecherry/www/ajax/layouts.php on line 72" while reading response header from upstream, client: 192.168.10.59, server: , request: "POST /liveview/layouts HTTP/1.1", upstream: "fastcgi://unix:/etc/alternatives/php-fpm.sock:", host: "192.168.10.73:7001", referrer: "https://192.168.10.73:7001/liveview"
MariaDB [bluecherry]> select * from userLayouts;
+----+---------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | user_id | layout_name | layout |
+----+---------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3 | 1 | test2 | {\"live_view11\":\"blob:https://192.168.10.73:7001/466f6953-8bd0-4fcc-8fc6-78c959fe36dd\",\"live_view12\":\"blob:https://192.168.10.73:7001/ed638e84-a6d2-4f2d-888c-ea02b2f937d2\"} |
+----+---------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
bluecherry 3:3.1.9
Debian12 package install
no layouts in database; save new layout with random name.
Saving a new one only seems a problem in brave browser.
firefox does save layouts, but those are not loading.