You are not logged in.

#26 2005-12-12 18:01:57

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,615
Website

Re: Forum search is broken

I *believe* it is caused by the phpbb_session table being too large. possibly the mysql query is just too big, due to the way that phpbb uses exclusionary clearing.. (just look at the debug message).

I did a cursory google search, and proposed solutions ranged from sacrificing a rubber chicken, to simply clearing the phpbb_session table.

Another thing to check..if a recent upgrade wiped out the max query size that had to be set a while back.. *shrugs*


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#27 2005-12-12 19:01:19

tomk
Forum Fellow
From: Ireland
Registered: 2004-07-21
Posts: 9,835

Re: Forum search is broken

ozar wrote:

Hmm... I don't suppose it would really surprise anyone if I said it doesn't work for me either, so I won't say it.    tongue

Nah - if you want to cause a stir, say this:

"Hey, it's working here!"

There's a chance you might get flamed, of course.... smile

phrak - I'll take that bet, so you owe me $25 - my representative will call on you tomorrow to collect the cash, along with his travel and accommodation expenses, finder's fee, etc.  tongue

Offline

#28 2005-12-12 19:16:39

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Forum search is broken

cactus wrote:

... proposed solutions ranged from sacrificing a rubber chicken ...

Done. Has anyone noticed an improvement yet? (I hope the poor chick didn't die in vain)

Offline

#29 2005-12-12 19:51:39

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,615
Website

Re: Forum search is broken

more research yeilded this..
http://www.phpbb.com/phpBB/viewtopic.php?t=311148

maybe a repair table is the magic incantation..


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#30 2005-12-12 19:57:56

apeiro
Daddy
From: Victoria, BC, Canada
Registered: 2002-08-12
Posts: 771
Website

Re: Forum search is broken

A couple indexes were corrupt... should work now.

Offline

#31 2005-12-12 19:59:22

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Forum search is broken

woo hoo! It's sorted. big_smile

Ta, boss.

Offline

#32 2005-12-12 20:02:14

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,615
Website

Re: Forum search is broken

muchas gracias señor!


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#33 2005-12-12 20:05:09

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Forum search is broken

Personally I think it was the sacrificed chicken that did it. Good call, dude.

Offline

#34 2005-12-12 20:05:42

sudman1
Member
From: Huntingdon, UK
Registered: 2005-02-18
Posts: 143

Re: Forum search is broken

Sweet!


v/r
Suds

Offline

#35 2005-12-12 20:15:52

Moo-Crumpus
Member
From: Hessen / Germany
Registered: 2003-12-01
Posts: 1,441

Re: Forum search is broken

cactus wrote:

more research yeilded this..
http://www.phpbb.com/phpBB/viewtopic.php?t=311148

maybe a repair table is the magic incantation..

...as I told ya ...  :x


Frumpus addict
[mu'.krum.pus], [frum.pus]

Offline

#36 2005-12-12 21:08:44

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,615
Website

Re: Forum search is broken

yes yes..
/me assumes the appropriate procumbent position.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#37 2005-12-12 21:24:28

Moo-Crumpus
Member
From: Hessen / Germany
Registered: 2003-12-01
Posts: 1,441

Re: Forum search is broken

ha smile


Frumpus addict
[mu'.krum.pus], [frum.pus]

Offline

#38 2005-12-13 11:03:58

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Offline

Board footer

Powered by FluxBB