Login Problem

Post by **Shonky** » Sun Jul 30, 2006 5:00 pm

Hey folks, found a problem with the the forum, when I try to login I get the error message below. The login cookie is set during the login, because if I go back, and then back again, then click on any forum thread the forum shows that I am logged in.

Tried deleting the cookie, same problem occurs with no cookie saved.

Code: Select all

phpBB : Critical Error

Error updating session key

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_sessions_keys.MYI' (errno: 145)

INSERT INTO phpbb_sessions_keys(key_id, user_id, last_ip, last_login) VALUES ('b984b03acea33d4bb4c35975bf86b612', 170, '3ba7bff4', 1154242617)

Line : 231
File : sessions.php

w00dsy · Post by **w00dsy** » Sun Jul 30, 2006 7:04 pm

i think there's been a database issue today, i doubt it's your end. I've only just been able to get on.

Post by **Big Kev** » Sun Jul 30, 2006 7:34 pm

Yep, I've just repaired the databases. Should be ok now.

Post by **Shonky** » Sun Jul 30, 2006 7:37 pm

All ok now, good job Kev.

Nigel · Post by **Nigel** » Sun Jul 30, 2006 8:58 pm

Big Kev wrote:Yep, I've just repaired the databases. Should be ok now.

I have been trying to work out how the database does that, suddenly loose bits of code.

Post by **Big Kev** » Sun Jul 30, 2006 9:10 pm

Dunno to be honest. Maybe it's a bit like hard drives fragmenting. They get a ton of data in one go when you sign in. It's tracking the topic scores, the posts, your session time, read topics, PMs etc etc. When you log out it can sometimes screw things up a bit and it seems to be cumulative. Then you get to a point where it's all in a mess but table repair scripts seem to 'defrag' it.

Gizmo · Post by **Gizmo** » Mon Jul 31, 2006 7:21 am

for Kev

Post by **Big Kev** » Wed Aug 02, 2006 6:14 pm

Just fixed this again.

I think the word search table is getting too big. It's basically every different word ever used on the forum. I'll sort it out tonight.

Montey · Post by **Montey** » Wed Aug 02, 2006 6:55 pm

Good job.

I spose the following doesn't help then:

Unique lacuna es effrego database.

Post by **Shonky** » Wed Aug 02, 2006 6:57 pm

Post by **Big Kev** » Thu Aug 03, 2006 5:21 am

ok I just removed 69,178 words from the search table

Hopefully that will stop the table corrupting.

r8response · Post by **r8response** » Thu Aug 03, 2006 8:33 am

any idea on what the most searched word was?

Post by **Big Kev** » Thu Aug 03, 2006 8:58 am

The stats grabber isn't great at subdomains but the last time I did the stats in March it looked like this

Top word searches

arse
sim
race
aussie
legends
norbs

Top phrase searches

vilante
gt legends skins
aussie race sim enthusiast
clipsal girls

fp · Post by fp » Fri Aug 11, 2006 4:18 am

speaking of searches.... any idea why the forum search function currently isn't working... and hasn't been working for several weeks?

I'm surprised that no-one else has brought it up yet.

Post by **norbs** » Fri Aug 11, 2006 6:05 am

fp wrote:speaking of searches.... any idea why the forum search function currently isn't working... and hasn't been working for several weeks?

I'm surprised that no-one else has brought it up yet.

It has been working fine for me Dan.

fp · Post by fp » Fri Aug 11, 2006 1:35 pm

That's odd, Todd.

No matter what I search for, even if it's a really common term that should return tens of results, I always get "No topics or posts met your search criteria"...

Post by **norbs** » Fri Aug 11, 2006 4:09 pm

It is odd.

w00dsy · Post by **w00dsy** » Fri Aug 11, 2006 4:32 pm

works for me