+1 vote
in PHP Scripts by
I am getting this error with the open source analytics software Piwik: Nobody on the official forum can help so I hope somebody here will have an answer:

I have been told it is the MYSQL query problem but I don't know how to fix it. Running the latest version of Piwik.

Error is displaying in the widgets on the dashboard:

SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

1 Answer

0 votes
by
he problem was indeed line 4

$select->where('order.customer_id?', $customer->getId());
Has to be

$select->where('order.customer_id=?', $customer->getId());

AnswerHighway.com is a community driven question and answer site - Ask questions and answer questions across a large range of categories

The opinions expressed on this page are the views of the author, and not necessarily the views of AnswerHighway.com, its staff, or its partners.

...