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

Hello Attila, Hello all and Happy new year !

About problem with menus, I create a ticket for the “always open dropdown”:
https://dev.tiki.org/item8267-Menu-Menu-42-dropdown-stays-open

I just published an article where I explain what I did about upgrading (3) tikis website from Tiki24 to Tiki25.
Menus are one of the topic. ;-)

https://www.bernardsfez.com/article84-Updating-from-Tiki-Wiki-version-24-to-Tiki-25

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

If more help is needed, contact me, I’ll be glad to help as usual with a screen shared session.

Bernard




> On 31 Dec 2022, at 12:56, Tóth Attila <[email protected]> wrote:
> 
> 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 <post-hhF2Jplw28UoZk/[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] <mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users <https://lists.sourceforge.net/lists/listinfo/tikiwiki-users>

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