Can't view layout after upgrade from 3.0.6 to 3.08 (same with 3.0.7)

[caudry59]

To be completed by the original poster:

CMS Version

3.0.8

Installation Method

Custom install, debian stable (11), with apache2

Operating System

debian stable

Issue

since i upgrade from 3.0.6 to 3.0.8 (same with 3.0.7), the CMS doesn’t show the layout content (and some other menu) + error while navigate to parameter (see screenshot)

upgrade instruction :

• get the newest tar.gz via wget url
• extract tar.gz to a temp folder
• chown -R the temp folder (www-data:www-data)
• stop apache2
• delete older file/folder
• copy paste new file/folder
• copy settings in web folder
• run the phinx script
• start apache2
• delete /web/install/something.php

i upgrade xibo since years and this is the first time i got a problem

Provide screenshots where possible!

[caudry59]

btw, downgrade to 3.0.6 (restore all files) works and all function is OK (already do that after updating to 3.0.7)

[caudry59]

i solve my problem using this script :

root@infv0075:~# cat modify_utf8.sh

#!/bin/bash

#mycollate.sh [ ]
#changes MySQL/MariaDB charset and collation for one database - all tables and
#all columns in all tables

#DB=“$1”
#CHARSET=“$2”
#COLL=“$3”

#[ -n “$DB” ] || exit 1
#[ -n “$CHARSET” ] || CHARSET=“utf8mb4”
#[ -n “$COLL” ] || COLL=“utf8mb4_general_ci”

DB=“xibo”
CHARSET=“utf8mb4”
COLL=“utf8mb4_general_ci”

echo $DB
echo “ALTER DATABASE `$DB` CHARACTER SET $CHARSET COLLATE $COLL;” | mysql

echo “USE `$DB`; SHOW TABLES;” | mysql -u usermysql -p’passwordmysql’ -s | (
while read TABLE; do
echo $DB.$TABLE
echo “ALTER TABLE `$TABLE` CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;” | mysql -u mysqluser -p’mysqlpassword’ $DB
done
)

i just install 3.1.1 release, and all seems to work fine