[Tiki-users] Problems after upgrading to 25.0 (and PHP 8.1)

I've just recently upgraded to 25.0 from 24.2.
The tiki-install.php still cannot keep database connection active, so I do
it on the console - no problem with that.

But after upgrade the menu list below the header and in the menu module
seem to be constantly expanded - I attach images.
I remember, that Bernard helped me to solve some GUI issues before and it
involved the breadcrumb settings and menu settings, but I cannot recall
the details - sorry Bernard...
I'm using the tikinewt theme.
Please let me know if you have any tips on solving this.

The other issue gives me headaches: file galleries doesn't load. I moved
image galleries before and updated external referring pages.
Now it wouldn't load. The error message is complaining about mixed
collations (utf8mb3_unicode_ci vs utf8mb3_general_ci). The real puzzle
here is that I cannot find any references for utf8mb3_general_ci, except
for the actionlog error entries. The database structure uses unicode_ci
everywhere. The error message states the collations are IMPLICIT. Although
I see some occurences of utf8m4_unicode_ci as well. I'm not sure about the
concept on how I should solve this. Convert everything to general_ci?
Sounds like a bad idea. Collation is missing somewhere and the implicit
choice is general_ci?
Please let me know your ideas on this, what should I change/check to make
the collations correct?


System error.

The following error message was returned:

Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and
(utf8mb3_general_ci,IMPLICIT) for operation 'like'

The query was:
SELECT COUNT(*) FROM ((SELECT 0 as `isgal`, tf.`fileId` as `id`,
tf.`galleryId` as `parentId`, tf.`name`, tf.`description`, tf.`filesize`
as `size`, tf.`created`, tf.`filename`, tf.`filetype` as `type`, tf.`user`
as `creator`, tf.`author`, tf.`hits`, tf.`lastDownload`, tf.`votes`,
tf.`points`, tf.`path`, tf.`reference_url`, tf.`is_reference`, tf.`hash`,
tf.`search_data`, tf.`metadata`, tf.`lastModif` as `lastModif`,
tf.`lastModifUser` as `last_user`, tf.`lockedby`, tf.`comment`,
tf.`deleteAfter`, tf.`maxhits`, tf.`archiveId`, tf.`ocr_state`, '' as
`visible`, '' as `public`, tf.`fileId`, tf.`galleryId`, tf.`filesize`,
tf.`filetype`, tf.`user`, tf.`lastModifUser`, 0 as `icon_fileId`, '' as
`files` FROM `tiki_files` as tf WHERE tf.`archiveId`=0 AND
tf.`galleryId`=? ) UNION ALL (SELECT 1 as `isgal`, tfg.`galleryId` as
`id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`,
tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as
`creator`, '' as `author`, tfg.`hits`, 0 as `lastDownload`, tfg.`votes`,
tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`,
'' as `hash`, tfg.`name` as `search_data`, '' as `metadata`,
tfg.`lastModif` as `lastModif`, '' as `last_user`, '' as `lockedby`, '' as
`comment`, '' as `deleteAfter`, '' as `maxhits`, 0 as `archiveId`, '' as
`ocr_state`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`,
tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`,
tfg.`user`, '' as `lastModifUser`, `icon_fileId`, count(distinct
tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN
`tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) WHERE 1=1 AND
tfg.`parentId`=? GROUP BY tfg.`galleryId`, tfg.`parentId`, tfg.`name`,
tfg.`description`, tfg.`created`, tfg.`name`, tfg.`type`, tfg.`user`,
tfg.`hits`, tfg.`votes`, tfg.`points`, tfg.`name`, tfg.`lastModif`,
tfg.`visible`, tfg.`public`, tfg.`galleryId`, tfg.`parentId`, tfg.`type`,
tfg.`user`, `icon_fileId` )) as tab WHERE (upper(tab.`name`) LIKE upper(?)
OR upper(tab.`description`) LIKE upper(?) OR upper(tab.`filename`) LIKE
upper(?))

Values:

    8
    8
    %%
    %%
    %%

The built query was likely:
SELECT COUNT(*) FROM ((SELECT 0 as `isgal`, tf.`fileId` as `id`,
tf.`galleryId` as `parentId`, tf.`name`, tf.`description`, tf.`filesize`
as `size`, tf.`created`, tf.`filename`, tf.`filetype` as `type`, tf.`user`
as `creator`, tf.`author`, tf.`hits`, tf.`lastDownload`, tf.`votes`,
tf.`points`, tf.`path`, tf.`reference_url`, tf.`is_reference`, tf.`hash`,
tf.`search_data`, tf.`metadata`, tf.`lastModif` as `lastModif`,
tf.`lastModifUser` as `last_user`, tf.`lockedby`, tf.`comment`,
tf.`deleteAfter`, tf.`maxhits`, tf.`archiveId`, tf.`ocr_state`, '' as
`visible`, '' as `public`, tf.`fileId`, tf.`galleryId`, tf.`filesize`,
tf.`filetype`, tf.`user`, tf.`lastModifUser`, 0 as `icon_fileId`, '' as
`files` FROM `tiki_files` as tf WHERE tf.`archiveId`=0 AND
tf.`galleryId`='8' ) UNION ALL (SELECT 1 as `isgal`, tfg.`galleryId` as
`id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`,
tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as
`creator`, '' as `author`, tfg.`hits`, 0 as `lastDownload`, tfg.`votes`,
tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`,
'' as `hash`, tfg.`name` as `search_data`, '' as `metadata`,
tfg.`lastModif` as `lastModif`, '' as `last_user`, '' as `lockedby`, '' as
`comment`, '' as `deleteAfter`, '' as `maxhits`, 0 as `archiveId`, '' as
`ocr_state`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`,
tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`,
tfg.`user`, '' as `lastModifUser`, `icon_fileId`, count(distinct
tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN
`tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) WHERE 1=1 AND
tfg.`parentId`='8' GROUP BY tfg.`galleryId`, tfg.`parentId`, tfg.`name`,
tfg.`description`, tfg.`created`, tfg.`name`, tfg.`type`, tfg.`user`,
tfg.`hits`, tfg.`votes`, tfg.`points`, tfg.`name`, tfg.`lastModif`,
tfg.`visible`, tfg.`public`, tfg.`galleryId`, tfg.`parentId`, tfg.`type`,
tfg.`user`, `icon_fileId` )) as tab WHERE (upper(tab.`name`) LIKE
upper('%%') OR upper(tab.`description`) LIKE upper('%%') OR
upper(tab.`filename`) LIKE upper('%%'))

-- 
dr Tóth Attila, Radiológus, 06-20-825-8057
Attila Toth MD, Radiologist, +36-20-825-8057