Comment to 'Problem with update from 11.0.1 to latest 12.1'
  • Hello Leonids,

    I have checked log files and noticed that the second issue is caused by the timeline app. Most probably because upgrade was not completed due to the SQL error.

    just for reference :

    [Wed Apr 06 20:46:39.155333 2022] [proxy_fcgi:error] [pid 734302:tid 140087709521664] [client 141.101.68.26:64220] AH01071: Got error 'PHP message: PHP Warning:  require_once(/srv / www . myunasite. com / una / modules / boonex / timeline / classes / BxTimelineUploaderRecordVideoAttach . php): failed to open stream: No such file or directory in / srv / www . myunasite . com / una / inc / classes / BxDolUploader . php on line 149PHP message: PHP Fatal error:  require_once(): Failed opening required ' / srv / www . myunasite . com / una / modules / boonex / timeline / classes / BxTimelineUploaderRecordVideoAttach . php' (include_path='.: / usr / share / php ') in / srv / www . myunasite . com / una / inc / classes / BxDolUploader . php on line 149', referer: https : // myunasite . com /
    

    After (temporarely and for the sake of checking the above hypothesis) disabling the permission to publish things on the timeline, every profile type is able to access the profile pages.

    I now need to solve the sql issue by doing what has been suggested in the thread you've mentioned :

    Then you may try to change the collation of your UNA tables from utf8mb4_general_ci to 
    utf8mb4_unicode_ci and try to update modules again.

    and then be able to resume upgrading the timeline app from 11.0.7 - 12.0.0 and on.

    for reference, the error while trying to upgrade the timeline module from 11.0.7 - 12.0.0 is :

    Operation failed:
    Timeline : Changing database: There are errors in the following MySQL queries:< />Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
    <pre>DELETE FROM `sys_pages_content_placeholders` WHERE `module`=@sName AND `title`='_bx_timeline_page_content_ph_timeline';pre>