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

Volker Wysk <post-hhF2Jplw28UoZk/[email protected]> Fri, 30 Dec 2022 16:47:49 +0100
Newsgroups	gmane.comp.cms.tiki.user
Message-ID	<[email protected]>
Hi, Tóth Attila.

That problem is likely to be because you're trying it with PHP 8.1. Tiki 25
still needs PHP 7.4. Tiki 26 will work with PHP 8.

See here:
https://doc.tiki.org/Tiki25

Bye,
Volker


Am Freitag, dem 30.12.2022 um 00:33 +0100 schrieb Tóth Attila:
> 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('%%'))
> 
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users

_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
signature.asc (application/pgp-signature, 833 B)