| Eve Of The War http://www.focusgaming.co.uk/eveofthewar/ |
|
| Debug Problem http://www.focusgaming.co.uk/eveofthewar/viewtopic.php?f=20&t=994 |
Page 1 of 2 |
| Author: | eveofthewar [ Wed Aug 31, 2005 9:07 am ] |
| Post subject: | Debug Problem |
In response to the debug problem some of you have been having, I have found some information that states the usual cure to this problem and similar ones is to do a repair on some of the database tables. I have done the repairs stated. So please let me know (on this thread) if you get the error message again, also copy and paste the text into this thread as well. Thanks for your patience in the matter 
|
|
| Author: | Sam [ Wed Aug 31, 2005 2:26 pm ] |
| Post subject: | |
Thanks very much for clearing that up, Lee! 
|
|
| Author: | oever532 [ Wed Aug 31, 2005 3:24 pm ] |
| Post subject: | |
I second that!  
|
|
| Author: | Loz [ Wed Aug 31, 2005 9:13 pm ] |
| Post subject: | |
Just got it again. Posted lots and lots of emoticons Forum Index || Memberlist || Usergroups || Search || You have no new messages General Error General Error 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) > 4005 Line : 309 File : functions_search.php |
|
| Author: | Sam [ Wed Aug 31, 2005 9:29 pm ] |
| Post subject: | |
Yeah that! 
|
|
| Author: | oever532 [ Thu Sep 01, 2005 6:11 am ] |
| Post subject: | |
That's that  thing bothering us if it gets the chance!!!!
|
|
| Author: | eveofthewar [ Thu Sep 01, 2005 3:58 pm ] |
| Post subject: | |
Loz wrote: Just got it again. Posted lots and lots of emoticons
GRRRRR!!!! might run a repair on all the tables then.... mmmm |
|
| Author: | Lonesome Crow [ Thu Sep 01, 2005 8:08 pm ] |
| Post subject: | |
Oh' it's an "SQL Error : 1104"  why didn't you say so before 
|
|
| Author: | Sam [ Thu Sep 01, 2005 8:44 pm ] | ||
| Post subject: | |||
Yup. Just got it again. Heres a screenshot if it helps
|
|||
| Author: | Sam [ Thu Sep 01, 2005 8:50 pm ] |
| Post subject: | |
Btw, if this helps too, it is brought on by certain posts, because i got that message, then i went to reply to some other topics which worked, then I came back after five minutes, replied to the topic again and it displayed the message again |
|
| Author: | oever532 [ Thu Sep 01, 2005 8:51 pm ] |
| Post subject: | |
So, what post is the main culprit (in the meaning of: what causes that debug mode), according to you? |
|
| Author: | Sam [ Thu Sep 01, 2005 8:54 pm ] |
| Post subject: | |
It was actually the one where me and you were talking about Road Runner lol. |
|
| Author: | oever532 [ Thu Sep 01, 2005 8:55 pm ] |
| Post subject: | |
That's funny, I never had trouble during that. 
|
|
| Author: | Sam [ Thu Sep 01, 2005 9:11 pm ] |
| Post subject: | |
Its odd. Really odd... |
|
| Author: | oever532 [ Fri Sep 02, 2005 8:10 am ] |
| Post subject: | |
It really is. I wonder what it caused it... |
|
| Author: | Loz [ Fri Sep 02, 2005 8:31 am ] |
| Post subject: | |
here we go again - Forum Index || Memberlist || Usergroups || Search || You have no new messages General Error General Error 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) > 4092 Line : 309 File : functions_search.php |
|
| Author: | oever532 [ Fri Sep 02, 2005 9:43 am ] |
| Post subject: | |
So irritating. And I reckon that everyone here agrees with me on that! |
|
| Author: | Loz [ Fri Sep 02, 2005 9:59 am ] |
| Post subject: | |
Yes, There are some differences between the two, can you spot them? |
|
| Author: | eveofthewar [ Fri Sep 02, 2005 10:27 am ] |
| Post subject: | |
RIGHT!!! I have now run "repair" on all database tables, twice. I have run "analyse" on all database tables. And ran "optimize" on all database tables. I hope that cures it ](./images/smilies/eusa_wall.gif "Brick wall")
|
|
| Author: | oever532 [ Fri Sep 02, 2005 11:24 am ] |
| Post subject: | |
I hope so... |
|
| Author: | oever532 [ Fri Sep 02, 2005 3:22 pm ] |
| Post subject: | |
You're not gonna believe this, Lee: General Error General Error 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) > 4115 Line : 309 File : functions_search.php I just got this! |
|
| Author: | eveofthewar [ Sat Sep 03, 2005 1:40 pm ] |
| Post subject: | |
|
... I shall keep looking ... |
|
| Author: | Sam [ Sun Sep 04, 2005 12:40 pm ] |
| Post subject: | |
It's going on about a word count. does a particular word trigger the error? |
|
| Author: | oever532 [ Sun Sep 04, 2005 12:42 pm ] |
| Post subject: | |
I don't know. |
|
| Author: | Loz [ Fri Sep 09, 2005 9:33 pm ] |
| Post subject: | |
Heres another just happened now I wrote - Says who? Forum Index || Memberlist || Usergroups || Search || You have no new messages General Error General Error 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) > 4275 Line : 309 File : functions_search.php Powered by phpBB © 2001/3 phpBB Group :: Labs by Port-All :: All times are GMT |
|
| Page 1 of 2 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|