Post editing is not borked anymore

Post by **grinvader** » Sun Jan 18, 2009 10:18 am

Thanks to _demo_.

Post by **grinvader** » Sun Jan 18, 2009 10:40 am

Additional info: deleting posts can still be done, although it also brings up the error.

Gil_Hamilton · Post by **Gil_Hamilton** » Sun Jan 18, 2009 11:10 am

THE END IS NEAR!

ZH/Franky · Post by **ZH/Franky** » Sun Jan 18, 2009 12:30 pm

The apocolypse is in sight. For it is then and now that zombies begin to walk, demons ravish the streets... humanity is doomed.

...being serious for a moment: admins, mods, etc: this is a GREAT opportunity to upgrade to phpBB3!

Post by **Agozer** » Sun Jan 18, 2009 1:04 pm

Just make sure that you don't make any huge mistakes before you click the submit button and everything will be just peachy.

franpa · Post by **franpa** » Sun Jan 18, 2009 1:35 pm

Franky wrote:The apocolypse is in sight. For it is then and now that zombies begin to walk, demons ravish the streets... humanity is doomed.

...being serious for a moment: admins, mods, etc: this is a GREAT opportunity to upgrade to phpBB3!

Wow, only need _demo_ for that... but if he is here, why bother when he can just fix what is already here?

85cocoa · Post by **85cocoa** » Sun Jan 18, 2009 9:22 pm

Just for the record, I tried to edit this post to add "Clarification requested" as the post subject (admittedly a stupid reason for an edit) and got the following error message on at least two of my attempts:

board.zsnes.com wrote:FIXME - will be back to insert a copy of the message in a sec

The edit did not succeed.

Note that my first edit attempt triggered flood control (i.e., the restriction on the minimum amount of time between posts); the other attempts came after that.

85cocoa · Post by **85cocoa** » Sun Jan 18, 2009 9:25 pm

Oops, forgot that I can't edit posts, which is what we're discussing here, so I can't insert the error message in the post above...

Anyway, a copypaste of the error message is as follows:

board.zsnes.com wrote:General Error

Error in deleting post

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_search_wordmatch'; try to repair it

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (185835)

Line : 419
File : functions_search.php

Also, if it wasn't clear, the words "this post" in the above post are a link to a post I made in the "bsnes v0.039 released" thread.

blargg · Post by **blargg** » Sun Jan 18, 2009 10:10 pm

When I got that error, I got scared. Database errors are bad, but whenever a computer mentions it's trying to "fix" a problem, it usually FUBARs everything.

adventure_of_link · Post by **adventure_of_link** » Sun Jan 18, 2009 10:15 pm

grinvader wrote:Additional info: deleting posts can still be done, although it also brings up the error.

Eh... I thought we can't delete posts anyway (unless you're mod/admin?)

That being said, never knew it needed memory to make a database backup.. I thought it just compiled all the tables, data, etc and make it into a downloadable file

Post by **grinvader** » Sun Jan 18, 2009 11:53 pm

And all that is made with bits taken from thin air. Righto.

"Deleting can be done" doesn't mean everyone and their mother can do it. It means it CAN BE DONE. Period. Don't try to read between the lines when there's only one.

@blargg: note it mentions to the user to try to repair it, not that it's trying to auto-repair itself.

kode54 · Post by **kode54** » Mon Jan 19, 2009 5:06 am

grinvader wrote:The server doesn't have enough free memory to dump a proper backup either.

Dump it without using compression. That way, you won't hit any memory limitation. At least, that's what I always used to do back when I had administrator access.

FitzRoy · Post by **FitzRoy** » Mon Jan 19, 2009 6:32 am

The last time I tried to delete a post, it took the thread with it. And no, I didn't hit the delete thread button.

Rashidi · Post by **Rashidi** » Mon Jan 19, 2009 8:42 am

Gil_Hamilton wrote:THE BOARD RESET IS NEAR!

fixed

AamirM · Post by **AamirM** » Mon Jan 19, 2009 12:13 pm

Rashidi · Post by **Rashidi** » Mon Jan 19, 2009 12:17 pm

AamirM wrote:

lol unix (linux?) epoch

Post by **Agozer** » Mon Jan 19, 2009 12:23 pm

Rashidi wrote:
AamirM wrote:
lol unix (linux?) epoch

That happened when I got rid of a spambot.

Post by **grinvader** » Mon Jan 19, 2009 7:48 pm

FitzRoy wrote:The last time I tried to delete a post, it took the thread with it. And no, I didn't hit the delete thread button.

Announcement of sorts: if you want something deleted, engage forum moderation mode, enter the correct topic, split the posts to be deleted into a new thread, and delete said thread.

Post by **grinvader** » Mon Jan 19, 2009 8:01 pm

kode54 wrote:Who's your daddy now bitch

Thanks. ^^

creaothceann · Post by **creaothceann** » Tue Jan 20, 2009 10:19 pm

Would a board pruning help?

adventure_of_link · Post by **adventure_of_link** » Tue Jan 20, 2009 11:47 pm

Or perhaps a cache flush?

kode54 · Post by **kode54** » Wed Jan 21, 2009 7:21 am

Fun: You can try feeding REPAIR TABLE commands to the database through the database restore feature, since it just accepts raw SQL dumps. You may want to back it up before attempting repair, though.

Post by **grinvader** » Wed Jan 21, 2009 9:16 pm

I merely backed it up, I'll let the sql whizzes have fun with that (if they ever get around).

franpa · Post by **franpa** » Sat Jan 24, 2009 1:04 am

So, when does Franky get banned? :/

Neo Kaiser · Post by **Neo Kaiser** » Sat Jan 24, 2009 6:02 am

So only this _Demo_ have the master password from the whole website? I thought that he leaved Pagefault in charge... BTW I miss Pagefault. Where is him?

ZSNES board

Post editing is not borked anymore

Post editing is not borked anymore

Re: Post editing is borked

Re: Post editing is borked