1. Fabrik 3.8 has been released. As usual, we strongly recommend that you backup your site (using Akeeba) before upgrading. Report any issues in the forums, we will answer promptly.

Need help for sum function

Discussion in 'Standard Support' started by victorchl, Feb 17, 2017.

  1. victorchl

    victorchl New Member

    Level: Standard
    Hi,

    I found a problem with my element sum function. When I enable it. In the front-end, the following message shown on the top:

    SELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.editorfee AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.editorunpay AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.journalstatus AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY label

    And when I go to the list setting, then group by this element. The sum is 0. I don't know why it's happened. Can anyone help~~~~Thank you!
     

Share This Page