sql_big_selects

Support & Bugs
1

When trying to update our Piwik install to 1.8.4 we get the following error when updating the database

Error trying to execute the query ’ UPDATE
piwik_log_link_visit_action AS link
LEFT JOIN
piwik_log_action_duplicates AS duplicates_idaction_url
ON link.idaction_url = duplicates_idaction_url.before
SET
link.idaction_url = duplicates_idaction_url.after
WHERE
duplicates_idaction_url.after IS NOT NULL;
’.
The error was: 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

Our hosting company has said we need to run the following before the update ‘SET SQL_BIG_SELECTS=1’

How would i go about doing this on Piwik? This is shared hosting with no access to SSH

Thanks

2

Add the SQL in a new query in the file: piwik/core/Updates/1.8.4-b1.php

3

How would i get the query to effect the update query? If i just put it into a normal SQL query it still fails.

Thanks

4

You’d hav eto ask your host why it doesn’t work