Issues after Upgrading to UNA 13.0.0-B3
Hello UNA Team,
After successfully upgrating my site from UNA 12.1.0 to 13.0.0-B3 using the Update button in the dashboard as explained here: https://una.io/cmts-view/9b488l?sys=bx_forum&cmt_id=41824 , i am having some issues:
Issue #1
I am having a Database query error on this page:
/page/view-persons-profile?id=1
The log email I received said:
Database error
Query:
SELECT `sys_profiles`.*, `c`.`added` FROM `sys_profiles` INNER JOIN `sys_profiles_conn_subscriptions` AS `c` ON (`c`.`content` = `sys_profiles`.`id` AND `c`.`initiator` = 3) INNER JOIN `sys_profiles` ON (`sys_profiles`.`id` = `c`.`content` AND `sys_profiles`.`status` = 'active') WHERE 1 ORDER BY `c`.`added` DESC LIMIT 0, 7
Mysql error:
Not unique table/alias: 'sys_profiles'
Location:
The error was found in getAllWithKey function in the file /home/xxxxx/public_html/xxxxx/inc/classes/BxDolProfileQuery.php at line 168.
collation_connection:
utf8mb4_unicode_ci
Issue #2:
I am having a 500 Internal Server Error on the Admin Frontend Dashboard,
/page/dashboard-content
Issue #3:
Missing Strings in:
/page/ads-licenses
_bx_ads_menu_item_title_licenses
_bx_ads_grid_column_title_lcs_entry
_bx_ads_grid_column_title_lcs_count
_bx_ads_grid_column_title_lcs_transaction
_bx_ads_grid_column_title_lcs_license
_bx_ads_grid_column_title_lcs_added
Also, in the account Pop-up (at the top right corner of the page), just after the Sign Out link:
_bx_ads_menu_item_title_offers_all
Please, how to fix these issues?
Many Thanks
-
I would clear all cache, also B3 still has errors so don't be alarmed too much. Most mods still aren't compatible right now
-
Hello @OneEagle !
About issues 1 and 3: please specify if all modules were upgraded to the last available versions as both points are correct from my side. About issue 2 - we need to know the latest lines from your error log.
-
Hi @LeonidS
Thanks a lot for your reply.
About issue 1 and 3, Yes all modules were upgraded. The Update button in the dashboard was updating the site incrementally through all versions. After each site update, I was also updating all the modules and so forth. It's like that i proceeded. The proof is the stores > updates > is empty, no modules to update.
Also I have checked both 'Persons' and 'Ads' Apps installed are the lastest version which is: 13.0.4.
I am having those very same issues with two different sites I updated from 12.1.0 to 13.0.0-B3. I suspect that maybe something went wrong with the update/install script. It didn't update well both app's databases: 'Persons' and 'Ads'. (just guessing!)
About issue 2, I have checked the cpanel, there is no error log message. Nothing related to this issue in the Apache error logs. I am just seeing old errors from old dates.
I have checked with both PHP 7.4 and 8.1, the 500 Internal Server Error is still there in the frontend.
-
Any help to my case? @Alex T⚜️ @LeonidS @Anton L
-
About point 1 your suggestion may be right. About point 2 - well, 500 Internal error always leaves the track in the logs. Possibly, you need to ask your hosting support to get the proper error log file to detect it.
-
So, what is the solution to this upgrade issue?
-
Restore your site to your working UNA v12.1.0. A beta version of 13 is not an upgrade of 12.1.0. Production sites should only be on a stable release due to the unpredictable results one can see with beta software; as you found out.
-
Thanks @Will Monte , Everything seems to be working fine except the problems I've mentioned above which can easily be fixed (Well, i think so). @LeonidS is already investigating them. He will come up with a fix soon. He is a smart guy.
-
Hello
Re Issue #1: Thank you for the report. https://github.com/unaio/una/issues/3844
-
UPDATE:
Issue 2: the reason was in the not-properly enabled / disabled Ads module.
-
Thanks a lot for the fix @Anton L I will wait for the next release to apply it.
-
Thanks a lot for the support and for fixing the issue #2 @LeonidS
