Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › mysql error MAX_JOIN_SIZE

View all replies to this thread

mysql error MAX_JOIN_SIZE

Thread began 7/09/2010 6:35 am by bbolt360986 | Last modified 7/09/2010 1:51 pm by bbolt360986 | 3992 views | 3 replies

7/09/2010 6:35 ambbolt360986

mysql error MAX_JOIN_SIZE

I am using the PowerStore 300 site and while trying to delete an advanced option for one of the products the following error comes up.

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

What is the exact syntax I should put in the php.ini file that would fix this, i have tried SET SQL_BIG_SELECTS=1 and SET SQL_MAX_JOIN_SIZE=10000000 and the error still comes up.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.