Categories
View Replies (2)

Resolved RO CSVI MySQL error – MAX_JOIN_SIZE

  1. New
  1. Zenon73
    Zenon73
  2. RO CSVI
  3. Sunday, 26 April 2026
  4.  Subscribe via email
Hi Ronald,

We are encountering the following MySQL error during RO CSVI export ( more image addtionel 7)

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

Could you please advise what is causing this and how we can resolve it?
Joomla! Version 5.2.5
PHP Version 8.2.30
virtuemart 4.4

Kind regards,

Zenon
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Zenon,

Could you please advise what is causing this and how we can resolve it?
The error message is very clear on what needs to be done. Either enable big selects or increase the number of joins. The thing is, RO CSVI already sets the big selects before an export is started.

There is no image attached. What export are you running? Do you have logging enabled? Is there anything in the debug log for this export?

Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 6 hours ago
  2. RO CSVI
  3. # 1
Zenon73
Zenon73
Accepted Answer Pending Moderation
thank you , check atachments please
Attachments (8)
AF0CA0DC-6AB5-41A6-966C-AE6079F91A4F.png AF0CA0DC-6AB5-41A6-966C-AE6079F91A4F.png
3BA09619-EF9E-4556-81FF-44733F99DFC5.png 3BA09619-EF9E-4556-81FF-44733F99DFC5.png
0B7524E9-0464-419C-AC23-44C52517BA3B.png 0B7524E9-0464-419C-AC23-44C52517BA3B.png
87C39BB5-139D-49C0-859D-4A3BF9162DE5.png 87C39BB5-139D-49C0-859D-4A3BF9162DE5.png
8A92BC25-C5B5-4B87-A31A-1F0F42440246.png 8A92BC25-C5B5-4B87-A31A-1F0F42440246.png
44959AB6-7702-43B5-BADC-796B3D4350D3.png 44959AB6-7702-43B5-BADC-796B3D4350D3.png
28ABBC48-118C-4D6F-8AEA-423E276C3D5E.png 28ABBC48-118C-4D6F-8AEA-423E276C3D5E.png
94AB8A93-DBF3-46F9-818A-39D2A7B15947.png 94AB8A93-DBF3-46F9-818A-39D2A7B15947.png
  1. 1 hour ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!