#1
SMF 2.1.x Support / Error log Database error, how to fix?
December 25, 2022, 10:09:37 PM by Rhindeer...... there! I'm not sure how to fix this error, but it's ............ me hundreds of entries in the Error Log. |: Does anyone know how I would go ............ you so much for your time! 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[' ............ '])); 121: 122: // Find the people interested in receiving notifications for ............ = $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...... /Profile-Modify.php (Line 3002) Database Error: 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 ......
#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 ............ collectors who created a forum to discover the variants of the coins and banknotes of Belgium ............ Belgian Congo. The roles were very well defined. One person did ............ regarding the IT management of the web hosting and the forum. ............ I was concerned with the layout and content of the forum. However, due ............ family/medical reasons, the other person can no longer be involved or provide ............ knowledge... I have two questions here: 1) Is there a free manual course or webinar here somewhere, ............ the operation of the whole thing can be explained ............ important to be able to do updates and other essential things that need to be done... 2) The ............ , certainly not all, are no longer accessing the forum and are getting this message. Message: The ............ would examine more than MAX_JOIN_SIZE rows; check your ............ and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ no idea what to do nor where to start looking for the solution. For the time being I have been able to ............ is causing this as I have not changed anything in the settings. Thanks in advance for your own ......
#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 your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ title. Please try to give a quick idea of what the problem is in your topic title in the future. ......
#5
Nederlands (Dutch) / Geen toegang meer op het forum - error code
February 04, 2024, 01:41:10 PM by Aernout86...... het forum raken en deze melding krijgen. Melding: 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 ......
#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...... my forum from Version 2.019 first to 2.1.3 and then few days ago to 2.1.4. Long before that I ............ my database from mysql 5.1 to 5.7. and the 2.019 version was working fine with 5.7. The ............ without any error messages. I also had tested the large upgrade on a copy of the forum in the same ............ . So I thought everything is fine and updated the live version. Suddenly these error messages ............ only in the live version. I thing its somehow connect to log ............ member. (database error engl.) Datenbankfehler: 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 ............ /CreatePost-Notify.php (row 139) attched are the screenshots - in german I'm using the NameX Theme ............ in SQL, PHP and so on.... Except that the forum is working. Any help would be very very ......
#7
SMF 2.0.x Support / Strange behaviour on a search
October 24, 2020, 03:10:22 PM by ArMaP...... . If I a search phrase with several words it gives the following error: QuoteThe SELECT would examine ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ 2.0.17, while your database is at version 2.0.13. The above error might possibly go away if you execute ............ latest version of upgrade.php. If I reduce the number the number of words on the search it works ............ expected. Is there something wrong on the forum configuration or ............ ? As a second question, where can I find what is the database version? Thanks in advance. ......
#8
SMF 2.0.x Support / [2.0.11] I can't reach any pages in my forum
December 27, 2018, 08:15:13 AM by FluFFeh...... there! Suddenly my forum is not working well, I can' ............ reach any pages. There is only 1 error message: TheSELECT would ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ......
#9
SMF 2.0.x Support / Search problem
February 26, 2019, 03:13:03 AM by natasa (NT)...... (after putting text in Search box and send it): 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 ............ should I put this peace of code: SET SQL_BIG_SELECTS=1 or MAX_JOIN_SIZE=# I am not a programmer, so ......
#10
SMF 2.0.x Support / Error Message
October 09, 2017, 09:49:59 AM by Ronald_1938...... of the Admin. reported this error to me this morning. ............ -lve PHP: 5.6.31 Server version: Apache Here is the reported 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 ............ 2.0.14, while your database is at version 2.0.12. The above error might possibly go away if you execute ......
#11
SMF 2.0.x Support / "It appears that your database may require an upgrade"
March 28, 2017, 08:07:45 PM by ArMaP...... a new forum at version 2.0.13 and pointed it to the old database. Now, when trying to delete inactive ............ we got this error: QuoteThe 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 ............ 2.0.13, while your database is at version 2.0. The above error might possibly go away if you execute ............ latest version of upgrade.php. Would copying the upgrade.php and sql files and execute ............ upgrade.php solve the problem? Or is it more complicated than that? ......
#12
SMF 2.0.x Support / Upgraded to 2.0.12 | Wrong database version?
October 02, 2016, 05:17:46 AM by s3cc0...... see this error when trying to use the search form with a long string: QuoteThe SELECT ............ examine more than MAX_JOIN_SIZE rows; check your WHERE ............ use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ 2.0.12, while your database is at version 2.0.7. The above error might possibly go away if you execute ............ latest version of upgrade.php. But there's more. It only happen at the first search. If ............ repeat the search after getting the error it won't happen ............ It will show up again trying a new search with another query (4 or 5 words). Searching with a short ......
#13
SMF 1.1.x Support / Database error
August 09, 2015, 07:49:06 PM by RC Storick...... a board I get this message. Can anyone help? 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 ............ 1.1.21, while your database is at version 1.1.1. The above error might possibly go away if you execute ......
#14
SMF 2.0.x Support / Search error
June 24, 2014, 07:29:21 AM by a10...... ok, error happens with 5 spaces. Database Error: 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 ............ Filter: Only show the errors from this file File: /customers/1***/httpd. ......
#15
SMF 1.1.x Support / Error message
December 17, 2013, 10:49:26 AM by RC Storick...... trying to delete a board and I get this message. 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 ............ 1.1.19, while your database is at version 1.1.1. The above error might possibly go away if you execute ............ clue as to how to fix it? Where I can download the ......
#16
SMF 2.0.x Support / 2.0.6: Export from DB A & Import to exact mirror DB B... SQL Error ?
October 29, 2013, 05:42:20 PM by MoreBloodWine...... . Just want to see if any of you guys have any other ideas. MeQuoteI've tried this upload with two ............ me what was wrong after fixing it, Ty. Error There is a chance that you may have found a bug in ............ SQL parser. Please examine your query closely, and check that the quotes are ............ and not mis-matched. Other possible failure causes may be that you are ............ quoted text area. You can also try your query on the MySQL command line interface. The MySQL server ............ output below, if there is any, may also help you in diagnosing the ............ . If you still have problems or if the parser fails where the command line interface ............ , please reduce your SQL query input to the single query that causes problems, and submit a ............ report with the data chunk in the CUT section below: ----BEGIN ............ - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ............ for the right syntax to use near '' at line 1 ............ , Please supply us with the a step-by-step instruction along with the SQL ............ you run so that we can reproduce the issue on this end. Should you require any ............ Administrator MeQuoteThis was all done from the client side of things so here's the user info. ............ : Export Step 3: Method Custom Step 4: Highlight / select only smf_tp_shoutbox Step 5: Selecta Data Step 6: ............ existing data Step 9: Import Step 10: Browse / select file Step 11: Click go Result: Error There is a ............ that you may have found a bug in the SQL parser. Please examine your query closely, ............ check that the quotes are correct and not mis-matched. Other ............ quoted text area. You can also try your query on the MySQL command line interface. The MySQL server ............ output below, if there is any, may also help you in diagnosing the ............ . If you still have problems or if the parser fails where the command line interface ............ , please reduce your SQL query input to the single query that causes problems, and submit a ............ report with the data chunk in the CUT section below: ----BEGIN ............ - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ............ for the right syntax to use near '' at line 1 ------- I' ............ tried this several different ways with the same end result. HostQuoteHello Carol, It ............ that you are just trying to import the data from the file to the table with the existing ............ enabling of LOCAL INFILE support in MySQL. We would not recommend going with this function as it has ............ issues. But if you decide to enable it, you would need to add local-infile to /etc/my.cnf and make ............ to get it working. Should you require any further assistance, please don't hesitate to contact us. ............ check and let s know how you wish to proceed further. We are looking forward to your reply. Thank ............ team. Please feel free to contact us for further help. Ionut Jar L2 Technical Support MeQuoteI ............ are effectively never possible. Ok, so notice in the hosts one reply "in red" he says this may require. ............ with that enable, but it's not something I'd rather do if it's a security risk. Not to mention ............ I need to import something I would have to enable what he said to enable and then ......
#17
SMF 2.0.x Support / How many files in attachment folders is OK?
October 27, 2013, 01:32:00 PM by ltrace...... there, just get database error when trying to delete ............ + pages topic: -- 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 ............ in ManageAttachments.php file -- There was a limit in my.cnf max_join_size = 1000000 ......
#18
SMF 1.1.x Support / data base error Help.
June 26, 2013, 03:44:05 PM by RC Storick...... try to delete a board. I dont know how to update the data base. The SELECT would examine more than ............ rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ............ 1.1.18, while your database is at version 1.1.1. The above error might possibly go away if you execute ......
#19
SMF 2.0.x Support / Database Error : MAX_JOIN_SIZE rows
March 25, 2013, 10:52:02 PM by Fearless Freap...... an odd situation. Everything was working fine, then one day, this: The SELECT would examine more ............ rows; check your 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. ............ No special themes some mods, but it happens regardless of mods. ......
#20
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...... 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 ............ 1.1.18, while your database is at version 1.1.1. The above error might possibly go away if you execute ............ latest version of upgrade.php. Is there anyone who can help me? ......