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

Hi Volker,

2022.December 30.(P) 16:47 időpontban Volker Wysk ezt írta:
> 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

I was looking at this page:
https://dev.tiki.org/PHP-8 and missed the fact Tiki25 won't come with PHP8
support.
I may revert, but contemplating on moving forward instead...

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

>
> 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
>




_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users