Forum damage: search function broken

(]UBC[ McNite) #21

Our IT folk know about the problem.

In our company that usually is only the beginning of more problems…

(CrazyGuy) #22

Just tell an tapir that they stolen your Bud Light Beer.

(Nail) #23

[quote=]UBC[ McNite]

Our IT folk know about the problem.

In our company that usually is only the beginning of more problems…[/quote]

getting them to admit there’s a problem is usually at least half the battle :lol:

(nUllSkillZ) #24

Our IT would say:

(kamikazee) #25

So we are all influenced to see general errors? And don’t blame it on swamp gas or weather balloons.

(ouroboro) #26

I sometimes can’t even preview my own posts anymore. And after submitting a post, I’m sometimes redirected to the home page. It’s random and happens in some threads but not others. :angry:

(Nail) #27

random and intermittent, IT guys love those words :lol:

(nUllSkillZ) #28

You can use google to search sites.
So you have to use:


site:splashdamage.com

in the list of words you search.

(jimb0) #29

The problem isn’t only with “word search”. Since all searches are broken, some other functionality doesn’t work, like the “view new posts since your last visit” link… which is actually pretty useful.

(Taddy) #30

hm i want to search something to about beta testing of quakewars but it doesn`t work only some bugs i can see like this:

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1016 Can’t open file: ‘nuke_phpbb_search_results.MYI’ (errno: 145)

DELETE FROM nuke_phpbb_search_results WHERE session_id NOT IN (‘0d07211cd41f28376a909817db025bbd’, ‘d4177fbac7dd17f2a951a3ec60e7d665’, ‘0d978fd9f3a08e5939b0e2bdbc21012f’, ‘d03c6a93954847fb03b802341cd29a13’, ‘dd5c9da55ba136f36beb00387a8e8dc7’, ‘9d13664b0403c78953db46873003f729’, ‘ff0225bbeaa11b3560c664cd9ab00e28’, ‘c89a6de4019714ca8f07718a47098ebe’, ‘87b23ba9e8f4176197cb3c2ef4918039’, ‘bfe2fede5caf127c0df1124c0e27af8f’, ‘56ef0e68db20018fec3899d365297b56’, ‘52d1cdf920e3e04e2592fb493b4119e0’,
…
‘f842f5ed5ad4505181f26d14c340de2d’, ‘9d46b6a321fc3727786465e3a2d5e5e2’, ‘9dbae976845e8e8d12bfada4fac845af’, ‘c0a9f5b1c6fc86cd352eda09d0ea805a’, ‘b7756e5023ebd5c4b5057126f630fa9e’, ‘0ccc1e973920257422b5786ad721651b’, ‘037a885026e3e7bfe3335b30e5d40445’, ‘b7c791f5e84db56971c326dd19a96270’, ‘5b29397f73da43e14d09499c5aefbe19’, ‘d57360b95fe9a9dbee82b71cb5198256’, ‘f4fd2aef5f654084c1674e111512bcfb’, ‘6ee9ed7a909f7421b139d6fbce2a2fbe’)

Line : 638
File : C:\Inetpub\www.splashdamage.com\modules\pnPHPbb2\search.php

maybe it help you…

(kamikazee) #31

That’s the same error I was referring to, I only cut out all id’s as there are way too many.

But they’d better hurry, the list keeps growing with every search made!

Searching Google gave this solution:
Patching search.php: http://www.infomaniak.ch/phpbb2/phpBB2-MySQL5.txt

(kamikazee) #32

:bump:

The villagers are calling to arms. I think it needs more then bringing this to the attention of the IT staff…

(Gringo) #33

Im with u Kami, more drastic methods r required. Blockade SD HQ so as to halt the pie and quiche supplys!

I mean they aint half slow about fixin it, what else could they be doin ? :smiley:

(kamikazee) #34

:bump:

We know that your IT staff knows about. Could they do something about it, or do we need to ask it nicely to one of your tapirs instead?

@Gringo: That’s drastic, but I don’t want any tapir casualties.

(Wils) #35

Our IT staff is on holiday atm :slight_smile:

(Salteh) #36

Well… the fix kamikazee posted says:

Compatible : MySQL 3.23, 4.0, 4.1, 5.0, 5.1

!!! BUGGED ON MySQL 5.0, 5.1 !!!

So my guess is someone upgraded the MySQL server, and that broke stuff.
How something can be compatible with 5.0, 5.1 and be bugged on 5.0, 5.1 at the same time… I have no idea. Perhaps theys are trying to say they are fixing issues in 5.0, 5.1, but the fixes can be used with all version… smuffins… :moo:

someone else on a random forum posted:

You must empty your table phpbb_session .
:eek:

(kamikazee) #37

That could work, but it would make everyone log out. All those guys who checked the “Remember me” checkbox and forgot their password will be mad.

@Corvey: I know what the error looks like. I deliberately shortened it when posting. Could you do the same, please?

(Joe999) #38

i’m curious, how large can that sql string become?

(]UBC[ McNite) #39

Our IT staff is on holiday atm

LOL… v583 v24 i d say
Is he having his sabatical or just the usual 6 weeks summer vacation :bump:

(Ragnar_40k) #40

Nearly 2 weeks now - I hope these “IT folks” are not responsible for any ET:QW related stuff …