I tried to delete a board and get this error

[RC Storick]

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
File: /home1/stunthan/public_html/smf/Sources/ManageAttachments.php
Line: 571

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.18, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.



Is there anyone who can help me?

[Oldiesmann]

The error is because the number of rows returned by the query to get all the attachments from posts in that board (so they can be removed) is larger than whatever the "max_join_size" variable is set to in MySQL.

The easiest way to deal with this is to just delete/move the topics manually (which will take longer), then delete the board once you've deleted and/or moved all the topics within that board.

[Kailash Aghera]

Looks like you have large number of posts in a board hence you are facing this problem. You can move the topics manually to other board and then try to delete it.

Kailash