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

  • 503
  • More
Replies (6)
    Login or Join to comment.