Adding options to PowerStore3 products

I am currently building a store and have an item I need to add multiple options too. I need to add a total of 7 option boxes and ran into this error nearing the end of adding my options

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

I know this have something to do with the database but I'm not sure of what to do about it.

Does this need to be fis=xed in the database or one of the corresponding pages on the site, and what would I need to do?

Thanks

See the following thread for details on fixing this issue:
showthread.php?t=14462

Thanks Jason, that seemed to have worked, I am not getting the error message any longer. However, I did notice that when I have added the options that they did not populate into the drop down box once I clicked "add" and even had a server shut down error twice. After adding the code snippet, the response time slowed down quite a bit.

When I clicked finish after managing the drop downs and was back in the "Update Product Information" page, the drop downs are populated with the chioces I added.

Using that many advance options could have a huge impact on the server if the server is not able to process that amount of information.

I recommend looking into using the Simple Options instead of the Advanced Options which should reduce the amount of processing and help in the load time of the page.