I'll obtain YOUR common word list, bitch
-
Franz Schubert
- 250 Posts til Somewhere
- Posts: 2714
- Joined: Sun May 25, 2003 9:59 am
- Location: Vienna
I got that error three times in a row while posting in the wasteland.Could not obtain common word list
DEBUG MODE
SQL Error : 1104 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
SELECT word_id FROM phpbb_search_wordmatch GROUP BY word_id HAVING COUNT(word_id) > 56869
Line : 309
File : functions_search.php
There are no 'knowns'. There are thing we know that we know. There are known unknowns. That is to say there are things that we now know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. So when we do the best we can and we pull all this information together, and we then say well that's basically what we see as the situation, that is really only the known knowns and the known unknowns. And each year, we discover a few more of those unknown unknowns.
-
DarkUnderlord
- Paragon
- Posts: 2372
- Joined: Wed May 01, 2002 7:21 pm
- Location: I've got a problem with my Goggomobil. Goggo-mobil. G-O-G-G-O. Yeah, 1954. Yeah, no not the Dart.
- Contact:
The short answer is: There's too much shit in the search word database. Executing that query would take too long so MySQL doesn't do it and outputs an error instead.
At least that's my understanding. Either we change the setting for big selects or, at least thoeretically, ditching half the search word tables would also do the trick albeit an interim measure.
Keep posting when you get the error though. That way I might actually be bothered to do something about it, rather than talking about doing something about it.
*goes back to getting the more info databases online*
At least that's my understanding. Either we change the setting for big selects or, at least thoeretically, ditching half the search word tables would also do the trick albeit an interim measure.
Keep posting when you get the error though. That way I might actually be bothered to do something about it, rather than talking about doing something about it.
*goes back to getting the more info databases online*
