Advertisement:

 Search results for: The SELECT would examine

Pages: [1] 2 3 4
1
SMF 2.0.x Support / [2.0.11] I can't reach any pages in my forum
« by FluFFeh on December 27, 2018, 08:15:13 AM »

......  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  ......
2
SMF 2.0.x Support / Search problem
« by natasa (NT) on February 26, 2019, 03:13:03 AM »

......  (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  ......
3
SMF 2.0.x Support / Error Message
« by Ronald_1938 on October 09, 2017, 09:49:59 AM »

......  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  ......
4
SMF 2.0.x Support / "It appears that your database may require an upgrade"
« by ArMaP on March 28, 2017, 08:07:45 PM »

......  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:  Quote  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  ............  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?   ......
5
SMF 2.0.x Support / Upgraded to 2.0.12 | Wrong database version?
« by s3cc0 on October 02, 2016, 05:17:46 AM »

......  see this error when trying to use the search form with a long string:  Quote  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  ............  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  ......
6
SMF 1.1.x Support / Database error
« by RC Storick on August 09, 2015, 07:49:06 PM »

......  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  ......
7
SMF 2.0.x Support / Search error
« by a10 on June 24, 2014, 07:29:21 AM »

......  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. ......
8
SMF 1.1.x Support / Error message
« by RC Storick on December 17, 2013, 10:49:26 AM »

......  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  ......

...... . Just want to see if any of you guys have any other ideas.  MeQuote  I'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     ............   Hello,  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    MeQuote  This 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.   HostQuote  Hello 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   MeQuote   ............  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  ......
10
SMF 2.0.x Support / How many files in attachment folders is OK?
« by ltrace on October 27, 2013, 01:32:00 PM »

......  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   ......
11
SMF 1.1.x Support / data base error Help.
« by RC Storick on June 26, 2013, 03:44:05 PM »

......  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  ......
12
SMF 2.0.x Support / Database Error : MAX_JOIN_SIZE rows
« by Fearless Freap on March 25, 2013, 10:52:02 PM »

......  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.   ......
13
SMF 1.1.x Support / I tried to delete a board and get this error
« by RC Storick on March 13, 2013, 12:03:42 PM »

...... 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? ......
14
SMF 1.1.x Support / error message
« by RC Storick on March 11, 2013, 05:19:42 PM »

......  do I fix 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  ............  1.1.18, while your database is at version 1.1.1. The above error might possibly go away if you execute  ......
15
SMF 2.0.x Support / Database Error
« by flipper79 on October 30, 2012, 09:30:34 PM »

......  attachments older than 365 days old!   Code: [SelectThe SELECT would examine more than MAX_JOIN_SIZE  ............ ; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is  ............  Media Gallery (check for orphan files)  Code: [SelectThe SELECT would examine more than MAX_JOIN_SIZE  ............ ; 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        ......
16
SMF 2.0.x Support / MAX_JOIN_SIZE rows database error
« by koop on October 16, 2012, 08:47:25 AM »

......  helpful when searching. In general I understand the cause, but I'm not sure how to fix it. I'm  ............  it's just a value change in a line of code for the file listed. Unfortunately I do not know where  ............  find that file. Any help would be very appreciated. The error is below.   Code: ............  [SelectThe SELECT would examine more than MAX_JOIN_SIZE  ............ ; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is  ............  File: /hermes/waloraweb082/b2083/moo.thebigtenhangoutcom/forum/Sources/geoIP.php Line:  ......

......  to 2.0.2... I finally did so but had to reset the attachments directory. I also lost the  ............  as well. I went to the admin / Attachments and Avatars / File  ............  after about 4% completion I get this error...  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  ............ .php Line: 1009  Can someone point me in the right direction? I know it's working, I did get  ............  attachments, and some of the photos... I just need to get the rest.  Thanks,  - ......
18
SMF 1.1.x Support / Attack of the 503 errors
« by Foster Grant on December 09, 2011, 05:13:37 AM »

...... 've been getting lots of these stupid errors for our forum, which is running  ............  due to budget constraints) ... sent a letter to the registered owner of our forum as follows:  Quote  ............  Siteground  Dear ***,  With this notification we would like to inform you that your account {site  ............ } consumes a very high percentage of the server resources and thus affects the performance  ............  the whole shared server.  In order to maintain the  ............  of the server, we had to temporarily limit the shared  ............  shown on your website.  We are very much aware of the inconvenience this issue may cause you, so we  ............  like to take a moment and explain the reasons for our actions: as you know, your  ............  on a shared hosting server and thus sharing the resources of the server with other customers'  ............  though our shared servers are well optimized, the nature of the shared server is such that no  ............  how powerful or how well optimized the machine is, it is possible that one user and even  ............  application consumes most of the server resources and overloads the machine. Thus  ............  other accounts on the server stop responding and  ............ .  In order to prevent server overload, the source of the high load has to be isolated so  ............  it cannot affect the overall server performance. This is a standard  ............ .  We have conducted a detailed investigation of the reasons for the high resource consumption and it  ............  towards its database, which eventually hogs the server. The server tries to execute your slow  ............  while putting other processes in the queue until some memory is  ............ . While they are waiting however, they stack up and cause  ............  again as soon as possible.  As mentioned before, the problem is caused by slow queries executed  ............  your application's database. There can be many reasons for slow database queries,  ............  the following 3 are the most common ones:  1. Large  ............  3. Large number of internal links that query the database directly.  Here are some of the database  ............  and consume a lot of server resources:  Code: [Select]  Executed 4 min ago for 2 sec on Database  ............ --> thespor3_smf1.  ............    SELECT ID_MSG, ID_MEMBER FROM smf_messages WHERE  ............  Executed 1 min ago for 4 sec on Database --> thespor3_smf1.  ............  Executed 1 min ago for 3 sec on Database --> thespor3_smf1.  ............  Executed 1 min ago for 2 sec on Database --> thespor3_smf1.  ............    SELECT ID_MSG, ID_MEMBER FROM smf_messages WHERE  ............  Executed 1 min ago for 2 sec on Database --> thespor3_smf1.  ............    SELECT ID_MSG, ID_MEMBER FROM smf_messages WHERE  ............  found:  *******_smf1 196Mb.  From the queries above we can conclude that your issue is  ............  by not well written scripts. In order to have the limitations removed, you should optimize your  ............  that is not working properly, or it may be in the application itself.  If the reason is in an  ............ /module, the easiest solution would be to disable/remove it.  ............  can usually be done from the application's admin area.  Please disable the  ............  that is using the queries above to resolve the issue.  If the  ............  is in the application itself, solving it may take much more  ............  advanced programming skills. In such cases it would be best to contact the application's developers  ............  ask for further assistance. They should be able to examine the  ............  and offer a suitable solution for it.  There are some general things you can do to optimize  ............ /websiteperformance/index.htm).  If optimizing the application is not a suitable option for you, we  ............ .com/dedicated_solutions.htm) as an alternative. There all of the system's resources will be dedicated  ............  set up fees -Free website content transfer from the shared server to the dedicated machine -No  ............  downtime during the upgrade  The upgrade process is simple and  ............ -> Upgrade to Dedicated Solution option.  If the problem with your application is not resolved in  ............  days, we will be forced to take further actions in order to ensure the stability of the  ............ ://www.siteground.com/login_page.htm) and comment the ticket that has been automatically open on your  ............  traffic levels, I'm not sure why we're causing them such problems. Of course, I could be a complete  ............  load. We're not running any extra services beyond the HTTP services and the SMF install.  I guess what  ............  really want to know is this: Is there something wrong with the PHP commands "Dimitar"  ............  Is this something where an upgrade to 2.0.x fixes the problem? Am I underestimating how much of a hit  ............ 're putting on the server?  Or is it what we are kind of leaning  ......
19
SMF 1.1.x Support / [ERROR] SELECT would examine more than MAX_JOIN_SIZE?
« by PRaDiUS on November 26, 2011, 12:39:33 PM »

......  solve this problem? Thanks in advance!  Code: [SelectThe SELECT would examine more than MAX_JOIN_SIZE  ............ ; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is  ......
20
EspaƱol (Spanish) / Problema al mover temas
« by daplon on June 15, 2011, 08:17:47 PM »

......  a la vez de un foro a otro, salta este error:   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  ............ .php y aparece esta funcion:   // Move over the mark_read data. (because it may be read and now  ............ );  $request = $smcFunc['db_query']('', '  SELECT lmr.id_member, lmr.id_msg, t.id_topic  FROM { ......
Pages: [1] 2 3 4