Eve Of The War

A forum for all 'War Of The Worlds' fans
Home Page Home Page Home Page Home Page
Login 
View unanswered posts View active topics

Delete all board cookies

All times are UTC




Home Page Home Page  [ 29 posts ]  Go to page
1, 2
 >> Next 
  Print view
Previous topic | Next topic 
Author Message
Offline 
 Post subject: Debug Problem
PostPosted: Wed Aug 31, 2005 9:07 am 
User avatar
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 :mrgreen:


Lee
Eve Of The War Webmaster
http://www.eveofthewar.co.uk
"The War Of The Worlds Website"

Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Wed Aug 31, 2005 3:24 pm 
User avatar
Martian War Lord

Joined: Sun May 29, 2005 5:02 pm
Posts: 3114
Location: Ridderkerk, the Netherlands
I second that! :D =D>


The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Wed Aug 31, 2005 9:13 pm 
User avatar
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
 Profile  
 
Offline 
 Post subject:
PostPosted: 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! :a016:


There are three types of people in this World. Those who can count, and those who can't
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Thu Sep 01, 2005 6:11 am 
User avatar
Martian War Lord

Joined: Sun May 29, 2005 5:02 pm
Posts: 3114
Location: Ridderkerk, the Netherlands
That's that :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: :a013: thing bothering us if it gets the chance!!!!


The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Thu Sep 01, 2005 3:58 pm 
User avatar
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"

Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Thu Sep 01, 2005 8:08 pm 
User avatar
Martian War Lord

Joined: Mon Jan 17, 2005 10:31 pm
Posts: 3365
Location: N.Humberside.UK
Oh' it's an "SQL Error : 1104" 8) why didn't you say so before :roll:


Image
http://www.youtube.com/watch?v=DldFBFJgWmw&feature=player_embedded


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
debug mode.JPG [ 160.64 KiB | Viewed 14125 times ]


There are three types of people in this World. Those who can count, and those who can't
Image
Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Thu Sep 01, 2005 8:51 pm 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Thu Sep 01, 2005 8:55 pm 
User avatar
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. :-k


The Tempest is an advanced assault vehicle, which carries two heavy Heat-Rays and a Canister Launcher.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 8:10 am 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 8:31 am 
User avatar
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
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 9:43 am 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 9:59 am 
User avatar
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
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 10:27 am 
User avatar
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"

Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 11:24 am 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 02, 2005 3:22 pm 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Sat Sep 03, 2005 1:40 pm 
User avatar
Martian War Lord

Joined: Wed Jan 12, 2005 7:01 pm
Posts: 1259
Location: UK
](*,) ](*,) ](*,)

... I shall keep looking ...


Lee
Eve Of The War Webmaster
http://www.eveofthewar.co.uk
"The War Of The Worlds Website"

Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: 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
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Sun Sep 04, 2005 12:42 pm 
User avatar
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.
Image


Top
 Profile  
 
Offline 
 Post subject:
PostPosted: Fri Sep 09, 2005 9:33 pm 
User avatar
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
 Profile  
 
Search for:
Display posts from previous:  Sort by  
Home Page Home Page  [ 29 posts ]  Go to page
1, 2
 >> Next 

All times are UTC


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
Jump to:  

cron
Powered by Skin-Lab © Alpha Trion