Reviews to Bands

    • Database error in Bands module every night when cron runs.

      Query:

      SELECT `ta`.* FROM `mz_bands_admins` AS `ta` WHERE 1 AND `ta`.`added` < UNIX_TIMESTAMP() AND `ta`.`expired` <> 0 AND `ta`.`expired` < UNIX_TIMESTAMP()

      Mysql error:

      Unknown column 'ta.expired' in 'where clause'

      Please fix.

      • J

        A patch update has been published.

        • PATCH IS WORSE! Database errors everytime the module is accessed!

          Query:

          SELECT `td`.*, `td`.`group_name` AS `name`, `ta`.`email` AS `account`, `td`.`added` AS `added_ts`, `tp`.`status` AS `status_profile` FROM `mz_bands_data` AS `td` LEFT JOIN `sys_profiles` AS `tp` ON `td`.`id`=`tp`.`content_id` AND `tp`.`type`='mz_bands' LEFT JOIN `sys_accounts` AS `ta` ON `tp`.`account_id`=`ta`.`id` WHERE 1 ORDER BY `added` DESC LIMIT 0, 21

          Mysql error:

          Unknown column 'td.group_name' in 'field list'

        • J

          patch 1.0.9 has been released with further updates for UNA 14.

          Login or Join to comment.