1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.

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