|
Author |
Message |
eveofthewar
|
Post subject: Debug Problem Posted: Wed Aug 31, 2005 9:07 am |
|
|
Martian War Lord |
Joined: Wed Jan 12, 2005 7:01 pm Posts: 1259 Location: UK
|
|
|
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
Lee
Eve Of The War Webmaster
http://www.eveofthewar.co.uk
"The War Of The Worlds Website"
|
|
Top |
|
|
Sam
|
Post subject: Posted: Wed Aug 31, 2005 2:26 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
Thanks very much for clearing that up, Lee!
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
oever532
|
Post subject: Posted: Wed Aug 31, 2005 3:24 pm |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
|
Top |
|
|
Loz
|
Post subject: Posted: Wed Aug 31, 2005 9:13 pm |
|
|
Martian War Lord |
Joined: Sun Feb 13, 2005 10:00 pm Posts: 2870 Location: Liverpool, UK
|
|
|
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
Bah bah black sheap April diamond spheres, Rigsby, Rigsby, Eight sided Pears.
|
|
Top |
|
|
Sam
|
Post subject: Posted: Wed Aug 31, 2005 9:29 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
Yeah that!
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
eveofthewar
|
Post subject: Posted: Thu Sep 01, 2005 3:58 pm |
|
|
Martian War Lord |
Joined: Wed Jan 12, 2005 7:01 pm Posts: 1259 Location: UK
|
|
|
Loz wrote: Just got it again. Posted lots and lots of emoticons
GRRRRR!!!! might run a repair on all the tables then.... mmmm
Lee
Eve Of The War Webmaster
http://www.eveofthewar.co.uk
"The War Of The Worlds Website"
|
|
Top |
|
|
Lonesome Crow
|
Post subject: Posted: Thu Sep 01, 2005 8:08 pm |
|
|
Martian War Lord |
Joined: Mon Jan 17, 2005 10:31 pm Posts: 3365 Location: N.Humberside.UK
|
|
|
|
Top |
|
|
Sam
|
Post subject: Posted: Thu Sep 01, 2005 8:44 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
Yup. Just got it again. Heres a screenshot if it helps
Attachments: |
debug mode.JPG [ 160.64 KiB | Viewed 14544 times ]
|
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
Sam
|
Post subject: Posted: Thu Sep 01, 2005 8:50 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
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
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
oever532
|
Post subject: Posted: Thu Sep 01, 2005 8:51 pm |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
So, what post is the main culprit (in the meaning of: what causes that debug mode), according to you?
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
Sam
|
Post subject: Posted: Thu Sep 01, 2005 8:54 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
It was actually the one where me and you were talking about Road Runner lol.
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
oever532
|
Post subject: Posted: Thu Sep 01, 2005 8:55 pm |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
That's funny, I never had trouble during that.
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
Sam
|
Post subject: Posted: Thu Sep 01, 2005 9:11 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
Its odd. Really odd...
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
oever532
|
Post subject: Posted: Fri Sep 02, 2005 8:10 am |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
It really is. I wonder what it caused it...
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
Loz
|
Post subject: Posted: Fri Sep 02, 2005 8:31 am |
|
|
Martian War Lord |
Joined: Sun Feb 13, 2005 10:00 pm Posts: 2870 Location: Liverpool, UK
|
|
|
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
Bah bah black sheap April diamond spheres, Rigsby, Rigsby, Eight sided Pears.
|
|
Top |
|
|
oever532
|
Post subject: Posted: Fri Sep 02, 2005 9:43 am |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
So irritating. And I reckon that everyone here agrees with me on that!
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
Loz
|
Post subject: Posted: Fri Sep 02, 2005 9:59 am |
|
|
Martian War Lord |
Joined: Sun Feb 13, 2005 10:00 pm Posts: 2870 Location: Liverpool, UK
|
|
|
Yes, There are some differences between the two, can you spot them?
Bah bah black sheap April diamond spheres, Rigsby, Rigsby, Eight sided Pears.
|
|
Top |
|
|
eveofthewar
|
Post subject: Posted: Fri Sep 02, 2005 10:27 am |
|
|
Martian War Lord |
Joined: Wed Jan 12, 2005 7:01 pm Posts: 1259 Location: UK
|
|
|
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
Lee
Eve Of The War Webmaster
http://www.eveofthewar.co.uk
"The War Of The Worlds Website"
|
|
Top |
|
|
oever532
|
Post subject: Posted: Fri Sep 02, 2005 11:24 am |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
I hope so...
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
oever532
|
Post subject: Posted: Fri Sep 02, 2005 3:22 pm |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
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!
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
eveofthewar
|
Post subject: Posted: Sat Sep 03, 2005 1:40 pm |
|
|
Martian War Lord |
Joined: Wed Jan 12, 2005 7:01 pm Posts: 1259 Location: UK
|
|
|
|
Top |
|
|
Sam
|
Post subject: Posted: Sun Sep 04, 2005 12:40 pm |
|
Tripod King |
Joined: Wed Jan 12, 2005 9:17 pm Posts: 828 Location: Wales, United Kingdom
|
|
|
It's going on about a word count. does a particular word trigger the error?
There are three types of people in this World. Those who can count, and those who can't
|
|
Top |
|
|
oever532
|
Post subject: Posted: Sun Sep 04, 2005 12:42 pm |
|
|
Martian War Lord |
Joined: Sun May 29, 2005 5:02 pm Posts: 3114 Location: Ridderkerk, the Netherlands
|
|
|
I don't know.
The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
|
|
Top |
|
|
Loz
|
Post subject: Posted: Fri Sep 09, 2005 9:33 pm |
|
|
Martian War Lord |
Joined: Sun Feb 13, 2005 10:00 pm Posts: 2870 Location: Liverpool, UK
|
|
|
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
Bah bah black sheap April diamond spheres, Rigsby, Rigsby, Eight sided Pears.
|
|
Top |
|
|
|
|