Ttdfjt

Sci-fi short story: plants attracting spaceship and using them as a agents of pollination between two planets

Why does the salt in the oceans not sink to the bottom?

High income and difficulty during interviews

Raw curve25519 public key points

Is the apartment I want to rent a scam?

Inverse Colombian Function

Other than a swing wing, what types of variable geometry have flown?

Is a sentence true for two substructures also true for their intersection?

How to Trust a Self-Signed Certificate

Is it okay to paraphrase other authors' literature reviews?

Aging LEDs - does their output drop after turn-on?

Travelling from Venice to Budapest, making a stop in Croatia

What is the best word describing the nature of expiring in a short amount of time, connoting "losing public attention"?

Killing a star safely

Are symplectomorphisms of Weil–Petersson symplectic form induced from surface diffeomorphisms?

Why are MEMS in QFN packages?

Short story about a group of sci-fi writers sitting around discussing their profession

What is an Eternal Word™?

My current job follows "worst practices". How can I talk about my experience in an interview without giving off red flags?

What is the purpose of this "red room" in "Stranger Things"?

Why is chess failing to attract big name sponsors?

Historicity doubted by Romans

Is the Game Boy Sharp LR35902 object-compatible with the 8080/Z-80?

In a script how can I signal who's winning the argument?

I am getting an error General error: 1111 Invalid use of group function. What am I doing wrong?

Getting SQLSTATE[HY000]: General error`getLastPageNumber()` returning wrong number of pagesCustomer Group Invalid login and/or password errorMy upgrade code won't work - what I'm doing wrong?Magento model not fetching dataMagento 1.9: How to show instock items first in product listing even after using sortingWhat am I doing wrong in applying patch?Magento 2; joinLeft() not workingPagination count issue in custom varient collectionWhat am I doing wrong with this nested block

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have this code

 $orderModel = Mage::getModel('sales/order');
 $ordercollection = $orderModel->getCollection()
 ->setPageSize(20)
 ->setCurPage(1)
 ->join(array('item' => 'sales/order_item'), 'main_table.entity_id = item.order_id');
 $ordercollection->addFilterToMap('large_total', 'SUM(subtotal_invoiced)');

 $ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');
 $ordercollection->getSelect()->group('main_table.customer_email');

If I take out the line

 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');

then it seems to work fine. I am not sure what I doing wrong here. Thanks!

magento-1.9 error join group

share|improve this question

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

add a comment | 

0

I have this code

 $orderModel = Mage::getModel('sales/order');
 $ordercollection = $orderModel->getCollection()
 ->setPageSize(20)
 ->setCurPage(1)
 ->join(array('item' => 'sales/order_item'), 'main_table.entity_id = item.order_id');
 $ordercollection->addFilterToMap('large_total', 'SUM(subtotal_invoiced)');

 $ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');
 $ordercollection->getSelect()->group('main_table.customer_email');

If I take out the line

 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');

then it seems to work fine. I am not sure what I doing wrong here. Thanks!

magento-1.9 error join group

share|improve this question

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

add a comment | 

I have this code

 $orderModel = Mage::getModel('sales/order');
 $ordercollection = $orderModel->getCollection()
 ->setPageSize(20)
 ->setCurPage(1)
 ->join(array('item' => 'sales/order_item'), 'main_table.entity_id = item.order_id');
 $ordercollection->addFilterToMap('large_total', 'SUM(subtotal_invoiced)');

 $ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');
 $ordercollection->getSelect()->group('main_table.customer_email');

If I take out the line

 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');

then it seems to work fine. I am not sure what I doing wrong here. Thanks!

magento-1.9 error join group

share|improve this question

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

 $orderModel = Mage::getModel('sales/order');
 $ordercollection = $orderModel->getCollection()
 ->setPageSize(20)
 ->setCurPage(1)
 ->join(array('item' => 'sales/order_item'), 'main_table.entity_id = item.order_id');
 $ordercollection->addFilterToMap('large_total', 'SUM(subtotal_invoiced)');

 $ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');
 $ordercollection->getSelect()->group('main_table.customer_email');

 $ordercollection->getSelect()->where('SUM(subtotal_invoiced) >= 200');

share|improve this question

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

share|improve this question

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

edited Jul 15 at 9:10

Mohit Rane

8721717 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

asked Jun 22 '16 at 20:11

Adam CoburnAdam Coburn

10811 silver badge77 bronze badges

2 Answers
2

active

oldest

votes

0

In MySQL aggregate functions (like SUM) cannot be used as part of a WHERE clause because the values aren't calculated early enough. Instead there is an additional clause called a HAVING clause.

$ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
$ordercollection->getSelect()->group('main_table.customer_email');
$ordercollection->getSelect()->having('SUM(subtotal_invoiced) >= 200');

share|improve this answer

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

add a comment | 

0

SELECT A.CurrentProfit - B.CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily A
JOIN (
SELECT CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily
WHERE Date IN (select min(Date) from kikingo_mt4.AccountLogs_Daily where Date between current_date() and current_date() -7 )
) B
ON A.MT4Account = B.MT4Account
WHERE A.Date = MAX(Date)

//////// Error Code: 1111. Invalid use of group function ////////

share|improve this answer

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f122357%2fi-am-getting-an-error-general-error-1111-invalid-use-of-group-function-what-am%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

In MySQL aggregate functions (like SUM) cannot be used as part of a WHERE clause because the values aren't calculated early enough. Instead there is an additional clause called a HAVING clause.

$ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
$ordercollection->getSelect()->group('main_table.customer_email');
$ordercollection->getSelect()->having('SUM(subtotal_invoiced) >= 200');

share|improve this answer

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

add a comment | 

0

In MySQL aggregate functions (like SUM) cannot be used as part of a WHERE clause because the values aren't calculated early enough. Instead there is an additional clause called a HAVING clause.

$ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
$ordercollection->getSelect()->group('main_table.customer_email');
$ordercollection->getSelect()->having('SUM(subtotal_invoiced) >= 200');

share|improve this answer

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

add a comment | 

In MySQL aggregate functions (like SUM) cannot be used as part of a WHERE clause because the values aren't calculated early enough. Instead there is an additional clause called a HAVING clause.

$ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
$ordercollection->getSelect()->group('main_table.customer_email');
$ordercollection->getSelect()->having('SUM(subtotal_invoiced) >= 200');

share|improve this answer

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

$ordercollection->getSelect()->columns('SUM(subtotal_invoiced) as large_total');
$ordercollection->getSelect()->group('main_table.customer_email');
$ordercollection->getSelect()->having('SUM(subtotal_invoiced) >= 200');

share|improve this answer

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

answered Jun 22 '16 at 20:36

Peter O'CallaghanPeter O'Callaghan

4,35633 gold badges1717 silver badges3131 bronze badges

0

SELECT A.CurrentProfit - B.CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily A
JOIN (
SELECT CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily
WHERE Date IN (select min(Date) from kikingo_mt4.AccountLogs_Daily where Date between current_date() and current_date() -7 )
) B
ON A.MT4Account = B.MT4Account
WHERE A.Date = MAX(Date)

//////// Error Code: 1111. Invalid use of group function ////////

share|improve this answer

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

add a comment | 

0

SELECT A.CurrentProfit - B.CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily A
JOIN (
SELECT CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily
WHERE Date IN (select min(Date) from kikingo_mt4.AccountLogs_Daily where Date between current_date() and current_date() -7 )
) B
ON A.MT4Account = B.MT4Account
WHERE A.Date = MAX(Date)

//////// Error Code: 1111. Invalid use of group function ////////

share|improve this answer

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

add a comment | 

SELECT A.CurrentProfit - B.CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily A
JOIN (
SELECT CurrentProfit
FROM kikingo_mt4.AccountLogs_Daily
WHERE Date IN (select min(Date) from kikingo_mt4.AccountLogs_Daily where Date between current_date() and current_date() -7 )
) B
ON A.MT4Account = B.MT4Account
WHERE A.Date = MAX(Date)

//////// Error Code: 1111. Invalid use of group function ////////

share|improve this answer

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

share|improve this answer

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1

answered Jul 15 at 5:42

Mamiint LimpayarayaMamiint Limpayaraya

1