gbadev.org forum archive

This is a read-only mirror of the content originally found on forum.gbadev.org (now offline), salvaged from Wayback machine copies. A new forum can be found here.

OffTopic > forum bug / crash?

#115923 - josath - Sat Jan 20, 2007 9:08 am

Today when I came to the forum, all I got was some SQL error. I fixed it by clearing my cookies, and logging in, leaving the 'remember me' box UNCHECKED. If I check the box, it crashes again.

The error is:
Code:
phpBB : Critical Error

Error updating session key

DEBUG MODE

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

INSERT INTO phpbb_sessions_keys(key_id, user_id, last_ip, last_login) VALUES ('16a7784f9c887bc319d7fc7e5e37706b', 2043, '447f69c0', 1169280947)

Line : 231
File : sessions.php


someone delete the sessions table or something?

#115924 - Firon - Sat Jan 20, 2007 10:01 am

I got the same thing too. I PMed SimonB about it maybe 2 hours ago.

#115929 - Lick - Sat Jan 20, 2007 12:26 pm

I delehted my cookehs and it all works fehn..
_________________
http://licklick.wordpress.com

#115936 - SimonB - Sat Jan 20, 2007 2:49 pm

I upgraded the forum sometime yesterday and it worked fine. Today however I got the same error as you (when logged in). I think I have fixed it now though.

PM's doesnt seem to have been working as I didnt receive yours Firon :)

Simon

#115952 - Firon - Sat Jan 20, 2007 7:22 pm

Yep, it's fixed now, thanks. :P

#115956 - keldon - Sat Jan 20, 2007 7:34 pm

Firon wrote:
Yes, it is fixed now.

Thanks :P

Grammar corrected ^_^

#115971 - Firon - Sat Jan 20, 2007 8:33 pm

keldon wrote:

Grammar corrected. ^_^


You missed a period. :)

#115975 - keldon - Sat Jan 20, 2007 9:24 pm

Smilees replace the punctuation marks ;) See!

#115999 - chishm - Sun Jan 21, 2007 12:42 am

Firon wrote:
keldon wrote:

Grammar corrected. ^_^


You missed a period. :)

Oh no! He's pregnant! :p
_________________
http://chishm.drunkencoders.com
http://dldi.drunkencoders.com

#116005 - Firon - Sun Jan 21, 2007 1:28 am

hah :P

#116019 - Lick - Sun Jan 21, 2007 5:00 am

LOOOOOOOOOOOOOOL
_________________
http://licklick.wordpress.com

#116020 - HyperHacker - Sun Jan 21, 2007 5:06 am

Hm, I was getting a different error. Ah well, works now.

So keldon, when can we expect libBaby V1.0?
_________________
I'm a PSP hacker now, but I still <3 DS.

#116022 - Lynx - Sun Jan 21, 2007 5:07 am

Laugh Out Out Out Out Out Out Out Out Out Out Out Out Out Out Loud?
_________________
NDS Homebrew Roms & Reviews

#116310 - HyperHacker - Wed Jan 24, 2007 9:08 am

Now search seems to have broken.

Quote:
Could not obtain matched posts list

DEBUG MODE

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

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE w.word_text LIKE 'text' AND m.word_id = w.word_id AND w.word_common <> 1

Line : 344
File : search.php

_________________
I'm a PSP hacker now, but I still <3 DS.

#116311 - HyperHacker - Wed Jan 24, 2007 9:11 am

And I can't edit posts at all.

Quote:
Error in deleting post

DEBUG MODE

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

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (116310)

Line : 420
File : functions_search.php


There's also an error when replying, also relating to functions_search.php, which could lead to people double-posting thinking their post wasn't added.
_________________
I'm a PSP hacker now, but I still <3 DS.

#116352 - josath - Wed Jan 24, 2007 6:22 pm

HyperHacker wrote:
There's also an error when replying, also relating to functions_search.php, which could lead to people double-posting thinking their post wasn't added.


Doh...I just double posted due to that :P

Here is my error:
Code:
Could not insert new word matches

DEBUG MODE

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

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 116350, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('linker', 'supported', 'libfat', 'works', 'homebrew', 'limited', 'fit', 'main', 'ram', '4mb', 'total', 'sram', 'applies', 'slot2', 'devices', 'official', 'slot1', 'games', 'eeprom', 'cards', 'emulate', 'nobody', 'uses', 'accessing', 'data', 'beyond', 'loaded', 'options', 'using', 'device', 'append', 'nds', 'file', 'magically', 'gbarom', 'space', 'starting', '0x0800', '0000', 'downside', 'work', 'seperate', 'load', 'essentially', 'doing', 'fopen', 'quot', 'mygame', 'fread', 'libfatsupported', 'current', 'list')

Line : 252
File : functions_search.php


then when i tried to edit my double-post, i got:
Code:

Error in deleting post

DEBUG MODE

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

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (116351)

Line : 420
File : functions_search.php

#116355 - SimonB - Wed Jan 24, 2007 6:38 pm

Hopefully fixed now.

Thanks.

Simon

#116402 - HyperHacker - Thu Jan 25, 2007 8:53 am

Hm, as long as we're discussing bugs/forum upgrades, is there any way to tweak the highlighting of new posts? If I come here one day and read only one forum, all posts in other forums are also marked as read. It'd be nice if this was done on a per-forum or even per-thread basis.
_________________
I'm a PSP hacker now, but I still <3 DS.

#116404 - josath - Thu Jan 25, 2007 8:56 am

I still want a rss feed for new posts. i know there's a phpbb plugin that's real simple, and generates a feed like this: http://forum.dev-scene.com/rss.php

#116786 - keldon - Mon Jan 29, 2007 5:41 pm

It is happening again; this time saying that the table for storing logins/sessions (or something of that nature) is full! I will try to save it next time it happens.

#117206 - HtheB - Fri Feb 02, 2007 10:42 am

I think I'm going to die :'(

Lol!

#117213 - Vich - Fri Feb 02, 2007 12:27 pm

Lynx wrote:
Laugh Out Out Out Out Out Out Out Out Out Out Out Out Out Out Loud?


"lol" is a Dutch word that is used to describe something as fun or funny. So "loooool" would be an extend of that word that could be related to stretching "haha" to "haaahaaa".
So it more or less has the same intend of Laughing Out Loud, but it's more mild in its expression.
_________________
[project website] [personal website]