#1
SMF 2.1.x Support / Error log Database error, how to fix?
December 25, 2022, 10:09:37 PM by Rhindeer...... in the Error Log. |: Does anyone know how I would go about fixing this? Thank you so much for your ............ ! QuoteError message Select Database Error: The SELECT would examine more ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ Select Expand 119: if (!empty($msgOptions[' ............ = $smcFunc['db_query']('', ' 124: SELECT 125: ln.id_member, ln.id_board, ln. ......
#2
SMF 2.1.x Support / Configuration > Notifications = Error
June 12, 2023, 02:18:42 PM by a10...... -Modify.php (Line 3002) Database Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#3
SMF 2.0.x Support / Error code: MAX_JOIN_SIZE
February 05, 2024, 11:26:07 AM by Aernout86...... , I would like your advice with the next problem. Many ............ forum and are getting this message. Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#4
SMF 2.1.x Support / my SMF site down with database instruction showing
August 09, 2023, 10:00:21 AM by KTN...... SMF version 2.1.4 was down only showing this The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#5
Nederlands (Dutch) / Geen toegang meer op het forum - error code
February 04, 2024, 01:41:10 PM by Aernout86...... forum raken en deze melding krijgen. Melding: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#6
SMF 2.1.x Support / Database Error - on login - but I'm not quite sure.
June 15, 2023, 05:43:14 AM by mcmuroni...... . (database error engl.) Datenbankfehler: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ .... Except that the forum is working. Any help would be very very appreciated. ......
#7
SMF 2.0.x Support / Strange behaviour on a search
October 24, 2020, 03:10:22 PM by ArMaP...... words it gives the following error: QuoteThe SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#8
SMF 2.0.x Support / Search problem
February 26, 2019, 03:13:03 AM by natasa (NT)...... putting text in Search box and send it): The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ should I put this peace of code: SET SQL_BIG_SELECTS=1 or MAX_JOIN_SIZE=# I am not a programmer, so ......
#9
SMF 2.0.x Support / Error Message
October 09, 2017, 09:49:59 AM by Ronald_1938...... version: Apache Here is the reported error: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#10
SMF 2.0.x Support / "It appears that your database may require an upgrade"
March 28, 2017, 08:07:45 PM by ArMaP...... inactive members we got this error: QuoteThe SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ if you execute the latest version of upgrade.php. Would copying the upgrade.php and sql files and execute ......
#11
SMF 2.0.x Support / Upgraded to 2.0.12 | Wrong database version?
October 02, 2016, 05:17:46 AM by s3cc0...... use the search form with a long string: QuoteThe SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#12
SMF 1.1.x Support / Database error
August 09, 2015, 07:49:06 PM by RC Storick...... board I get this message. Can anyone help? The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#13
SMF 2.0.x Support / Search error
June 24, 2014, 07:29:21 AM by a10...... error happens with 5 spaces. Database Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#14
SMF 1.1.x Support / Error message
December 17, 2013, 10:49:26 AM by RC Storick...... to delete a board and I get this message. The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#15
SMF 2.0.x Support / How many files in attachment folders is OK?
October 27, 2013, 01:32:00 PM by ltrace...... when trying to delete 4+ pages topic: -- The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ......
#16
SMF 1.1.x Support / data base error Help.
June 26, 2013, 03:44:05 PM by RC Storick...... . I dont know how to update the data base. The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#17
SMF 2.0.x Support / Database Error : MAX_JOIN_SIZE rows
March 25, 2013, 10:52:02 PM by Fearless Freap...... was working fine, then one day, this: The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ............ can be a problem for me when posting. Any help would be appreciated. I have just upgraded to SMF 2.0. ......
#18
SMF 1.1.x Support / I tried to delete a board and get this error
March 13, 2013, 12:03:42 PM by RC Storick...... SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#19
SMF 1.1.x Support / error message
March 11, 2013, 05:19:42 PM by RC Storick...... do I fix this? The SELECT would examine more than MAX_JOIN_SIZE rows; check ............ WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ......
#20
SMF 2.0.x Support / Database Error
October 30, 2012, 09:30:34 PM by flipper79...... attachments older than 365 days old! Code Select Expand The SELECT would examine more than ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ............ SMF Media Gallery (check for orphan files) Code Select Expand The SELECT would examine more than ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ............ -Admin.php Line: 1788 Any help or pointers would be greatly received TIA flip ......