file [SOLVED] Roksproket: SET SQL_BIG_SELECTS=1 or SET SQL_MAX_J

  • HaPf
  • HaPf's Avatar Topic Author
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

Roksproket: SET SQL_BIG_SELECTS=1 or SET SQL_MAX_J was created by HaPf

Hallo,
all is working on my own server, but on the customer server I do get the following message:
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
Customer support of the server told, they can not chance this, but I can chance in the file.
But I do have no idea in which file I should chance this??
3 years 1 month ago #1

Please Log in or Create an account to join the conversation.

  • HaPf
  • HaPf's Avatar Topic Author
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

Replied by HaPf on topic Roksproket: SET SQL_BIG_SELECTS=1 or SET SQL_MAX_J

Found the solution: o fix it i just have to edit the file libraries\joomla\database\driver\mysqli.php
and to insert the line
mysqli_query($this->connection,"SET SQL_BIG_SELECTS = 1;" );
in the function connect after the line 168( mysqli_query($this->connection, "SET @@SESSION.sql_mode = '';");)
3 years 1 month ago #2

Please Log in or Create an account to join the conversation.

  • HaPf
  • HaPf's Avatar Topic Author
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

Replied by HaPf on topic [SOLVED] Roksproket: SET SQL_BIG_SELECTS=1 or SET SQL_MAX_J

Problem solved.
3 years 1 month ago #3

Please Log in or Create an account to join the conversation.

Moderators: joomlaplates

Installations-Service

Don´t waste your time, we install your purchased Template
with the "Demo Content" within the next 24 hours.

Buy Now - 59€

Joomlaplates/Theme-Point is not affiliated with or endorsed by Open Source Matters or the Joomla! Project

Copyright © 2022 JoomlaPlates | Professional Joomla Templates with Uikit 3

Disclaimer & Privacy | License