Comment to 'Bands'
Comment 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'