...... , I attempted to update the keycaptcha mod and received a slew of test failed  ............  at the uninstall stage. When I examine the changes that  ............  wants to make I find nothing to suggest that it would fail.  For example:  ./Sources/ManageSettings.php  ............ : (Find) [Select]  // KeyCAPTCHA Settings.  array(' ............ / Clever Thomas, who is looking sheepy now? Not I, the mighty sword swinger did say.  Code: (Replace) [ ............ / Clever Thomas, who is looking sheepy now? Not I, the mighty sword swinger did say. ......

......  tried and now I am getting this:  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  ............  1.1.5, while your database is at version 1.1.4. The above error might possibly go away if you execute  ......

......  am getting the following error: -  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  ............  1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute  ......

...... 's relatively low on this site, but knowing how others may choose to use post moderation, I can't rule  ............ .  FWIW, I'd suggest it should be patched in the next 2.0.x branch, not a 2.1 fix.  That said, let  ............  elaborate a bit more now I've had time to examine the code. The offender, this beast in Recent.php:  ............  Code Select Expand  // Find the 10 most recent messages  ............ ?  $request = $smcFunc['db_query']('', '  SELECT m.id_msg  FROM {db_prefix}messages AS m   ............  ); It confirms one supposition and disproves another: it is based solely on m.approved, but I  ............  it would elect not to carry out that test if the user was  ............  not, it simply filters solely on approval.  Now, the reason for that is pure performance: there's no  ............  to the topics table, thus the state of the topic being  ............  does potentially slow it down significantly.  The simplest rewrite to include this would merely be:  ............  Code Select Expand  // Find the 10 most recent messages  ............ ?  $request = $smcFunc['db_query']('', '  SELECT m.id_msg  FROM {db_prefix}messages AS m   ............ ['start'],  'limit' => 10,  ))  ); This would confine it to approved posts only (and still in  ............  boards the user can see) which would close the loophole, but  ............  also remove the ability of moderators (who can approve) from  ............ , I don't think that's a huge deal (considering there are other places where this is already an issue, ............  e.g. in the unread posts where unapproved topics do not turn  ............  IIRC even if you would otherwise have permission to see them) ......

...... :02 PMkb scan gives error below,  Database 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  ............  to ask your host to change if you want to run the file.  Restoring the database does not fix the  ............  your files. You need to clean all your files of the code that has been inserted into them. The  ............  may help. Otherwise you need to speak to your host to make sure  ......

......  statistics... Unsuccessful! This query:   SELECT t.ID_TOPIC, COUNT(m.ID_MSG) AS numMsg  FROM ` ............   HAVING numMsg = 0  LIMIT 0, 200;  Caused the error:   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  ............   Big_Selects is not a major issue, I just need to find where  ............  shove the " db_query("SET @@SQL_BIG_SELECTS = 1", __FILE__,  ............ ); " like I did in the RepairBoards.php (Or perhaps you could tell me ) ............  Either that or I run repair / recount etc from Admin.    ............ ||Circuit|1198758919|Hi,<br /><br />Could you send the electronic circuit with all the IC's to rpleum@ ............ |Sure, I think I have one I drew that starts at the USB input, and goes thru to the 40 outputs to the  ............  drive at home, so I will dig it up and post it on the forum. <br /><br />Ive decided to create a new  ............ |1198808115|0|124.186.41.133|s||| Looking at another members .msg file in YABB,  Quotejon|Re: Westsim| ............ |hi|1198413077|121.221.193.9|1 So it seems there are 2 file formats in the folder.  Bear in mind  ............  converted from YABB2.1 to YABB2.2 but just copied the Members and Messages folders to the new install.  ............  I have edited this post so many times! Perhaps the 2 versions of YABB use different formats, and it  ............  them the first time you access them in YABB2.2........ ............ .....    temp_toName still contains data in the XXX_personal_Messages table and the rest of the  ............  is all out of order The First 430 or so are like this QuoteID_PM  ............  211.26.76.166 joshstone The rest (about a 60) or so are like this. They are  ............  mine, which leads me believe that they ARE being changed by YABB as these files were  ............  into the directory from a backup tonight.   QuoteID_PM  ............  Circuit Hi,<br /><br />Could you send the electronic circu... jon The forum is locked,  ............  I am the only one who has been there, and I have checked  ............  PM's in YABB. I will go and compare the files from the backup.................  My backup  ............  the YABB2.1 board has this format Member|subject| ............ |body|another timestamp|IP Address And the same file from  ............  Timestamp|Member(Author)|Member(recipient)|another timestamp|body|another timestamp|IP Address||(s)| ............ (r)|(null)|(null)]   They may not be timestamps, they may be post  ............ . Not sure what they are, but I guess you will   I had a look at  ............  outbox folders and they too change with the YABB update in the same way.  ............  Perhaps the converter needs to look at the data, decide what  ............  it is in, then process it accordingly.  More than happy to zip  ............  and email some of the complete files (.outbox .msg .ims etc) of a  ............  ones you want. Or, I could give you ftp access to the YABB folder on the server.    Jon    ......

......  i use kb scan i got this type of error   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  ......

......  have 2 IPB sites  I have tried to convert one of them right now after installing SMF in the same  ............  and chosing to convert to utf8  The conversion was incomplete with the following  ............  :   Code Select Expand Converting topics... Unsuccessful! This  ............ :   SELECT  t.tid AS ID_TOPIC, t.pinned AS isSticky, t. ............  ID_LAST_MSG != 0  LIMIT 28000, 500;  Caused the error:   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  ............  Now, I will try to convert the other site . It is hosted by another server   ......

...... : dimensions on July 09, 2007, 10:38:02 AMQuoteThe 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  ......

......  Who.php that automatically subtracts 2 hours from the time.  That's the only thing I can think of that  ............  downloading 1.0.7 from our site, extracting the files to your site, and then (using your FTP  ............ ) renaming Who.php to Who.php.bak, and then uploading the fresh copy of Who.php.  See if  ............  fixes the problem.  Or, you can send me your FTP info and I' ............  make the change and then examine your copy of Who.php.  I  ............  the Who.php to my desktop to take a look at it. I  ............  very little about this stuff, but I think this is the section where I need to look:  // Look for people  ............ , provided they don't mind if you see they are.  $request =  ............ ("  SELECT  UNIX_TIMESTAMP(lo.logTime) AS logTime,  ............ , 1) AS showOnline, lo.session, mg.onlineColor  Is the UNIX_TIMESTAMP pulling this time from the server?  ......

......  while executing kb scan i got this error  Code Select Expand Database Error The SELECT would examine  ............  rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is  ............ /kb_scan.php Line: 163   I tried searching SQL_BIG_SELECTS and SET SQL_MAX_JOIN_SIZE in kb scan file but  ............  arn't in the source?? Bdw i dont think  I am getting this  ............  due to Krisbarteo as Krisbarteo was the member no. 7721 in my forum it means he  ......

...... , let's look at this:  SELECT *, COUNT(pk_corp) AS pk_count FROM pk_mails GROUP  ............  you're ordering by a count. This forces MySQL to examine a lot more rows than it would have to otherwise.  ............  always slow, although a few seconds is bad.  I would check key usage. What do you get if you run the  ............  "EXPLAIN " in front of it? It should tell you the key usage on the pk_mails table.  A possibility  ............  and a pk_mail. I really have no idea what these are, but the idea would be to put the count of  ............  per pk_corp in the pk_corps table, and make it an index. You could  ............  order by this, reducing significantly the number of examined rows.  -[Unknown] ......

......  tablas de errores,por ahora tenemos sólo:  Code Select Expand Search --->> Reparando Tags----->>  ............  dos.. casi TOPS:--- Error en la Base de Datos  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  ......