DB error after upgrade to UNA ver. 13.1.0-RC3
Hi,
after upgrade UNA to latest version there is a problem with Albums....:
Database error in Site
Query:
SELECT `bx_albums_files2albums`.`id` as `id`, `bx_albums_files2albums`.`title` as `title`, `bx_albums_files2albums`.`data`, `bx_albums_files2albums`.`content_id`, `bx_albums_files2albums`.`file_id`, `bx_albums_files2albums`.`order`, `bx_albums_files2albums`.`views`, `bx_albums_files2albums`.`content_id`, `bx_albums_files2albums`.`file_id`, `bx_albums_files2albums`.`author`, `f`.`added` as `added` FROM `bx_albums_files2albums` INNER JOIN `bx_albums_albums` ON `bx_albums_albums`.`id`=`bx_albums_files2albums`.`content_id` INNER JOIN `bx_albums_files` AS f ON `f`.`id`=`bx_albums_files2albums`.`file_id` INNER JOIN `sys_profiles` ON `sys_profiles`.`id`=ABS(`bx_albums_files2albums`.`author`) as `author` WHERE 1 AND `bx_albums_files2albums`.`featured` <>'0' AND `bx_albums_albums`.`status` ='active' AND `bx_albums_albums`.`status_admin` ='active' AND `bx_albums_albums`.`allow_view_to` IN(3,4) AND `sys_profiles`.`status` ='active' ORDER BY `bx_albums_files2albums`.`featured` DESC, `bx_albums_files2albums`.`id` DESC LIMIT 0, 12
Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as `author` WHERE 1 AND `bx_albums_files2albums`.`featured` >'0' AND `bx_albums' at line 1
Called script:
/una/r.php
Request parameters:
array (
'_q' => 'albums-home',
'i' => 'albums-home',
)
Please how can this be solved urgently. If we are going to run our site without Messenger working correctly and now Albums not working our members will leave the site very very quickly.
Kind regards
Mayki
-
- · あたぽ
- ·
Same situation
-
- · Mayki
- ·
I also have demo site (dev site) and it is the same problem on both instances.....
-
-
·
Alex T⚜️
- ·
@Mayki @atapo could you please try the following fix until we release an update:
https://github.com/unaio/una/commit/a8340190d3565482d753ff1496fedcc3dd6b966f
-
·
Alex T⚜️
-
- · Mayki
- ·
@Alex T⚜️ the fix solved the problem. Thank you very much
-
- · Nurke
-
·
In reply to Alex T⚜️
- ·
Is this isolated incident or update issue in this version?
Thanks.
-
- · Mayki
-
·
In reply to Nurke
- ·
Hi @Nurke , I don't believe that this is "isolated incident" since we have same problem on two instances (production and dev=test) of UNA with the same problem after upgrade to UNA ver. 13.0.1-RC3 and here is also @atapo with the same problem. But maybe @Alex T⚜️ can say more about that.