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

Hi Jonny,

2022.December 30.(P) 17:24 időpontban Jonny Bradley via TikiWiki-users ezt
írta:
> Sorry, no idea about the sql errors in php8+, but check the collations on
> the tables, specifically tiki_files and tiki_file_galleries - actually,
> none of them should be utf8mb3_anything, everything should be utf8mb4
> since tiki 19 i thought... hmmm, sounds like something's gone wrong in
> there - how old is this tiki?

Ahh, I see. I have to fix my database regardless of 24.x or 25.x. I may
start doing it manually, but if there are any ideas on how to do it
officially, it would be nice.
The tiki is very, very old. This server hits 20, running a rolling distro
from the very start. As I remember, I started using Tikiwiki around
version 1.7.x in 2003...

> Re the menu layout, i heard that sometimes a vertical menu can become
> horizontal in 25.x, but not seen it myself - try going to
> tiki-admin_modules.php and editing the module and set the "Type" to
> "vert"?

I remember, that I had a problem with menus and breadcrubs around 21.x to
22.x upgrade and Bernard pointed me to an option that solved the look&feel
issue. It wasn't about vertical vs horizontal layout, but some more
general GUI function I cannot remember now...

Bernard: do you happen to have a clue on this? That session you helped me
was quick and effective!

Thanks:
Attila

>
> HTH, happy 23 all
>
> jonny
>
>
>
>
>> On 30 Dec 2022, at 15:47, Volker Wysk <[email protected]> wrote:
>>
>> 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
>
>
>
>
> _______________________________________________
> 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