Martin Seidl wrote:
what does this error message mean?
It means the results returned is very large and your hosting company has set restrictions on this in the MYSQL setup
Martin Seidl wrote:
is it connected to php configuration?
No, MYSQL configuration.
To fix this your host will need to edit your server connection and in the "MySQL Options" tab, set a reasonable value for "Automatically limit SELECT queries to" and set the value for "Maximum Join Size" to 1000000.
Martin Seidl wrote:
what kind of limit does our hoster provide?
The limit identified in the error message.
Martin Seidl wrote:
what should be considered with a new hoster?
To not have that limitation.
Martin Seidl wrote:
or can I write an override so that this code will not be overwritten after each Joomla Update?
You could but that's a bad idea since every Joomla update you will have to check whether the program you are patching has been changed by Joomla and reapply your fix anyway.
Regards, Mark.