Code: Select all
An error has occurred. 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
I checked phpmyadmin and it says that max_join_size value is 500000000 (seems quite big compared to 300000 and 1000000 which i saw in examples of such problem online). I tried changing update channels, rebuilding "update sites", refreshing cache of "Joomla! Update" component. Can't quite find where and how exactly to insert SQL_BIG_SELECTS=1, which would solve this.