Notice: Home alone tonight?
Topic: Database errors
+Frank Usrs — 13 years ago #25,966
Are they fixed?
+Anonymous B — 13 years ago, 1 minute later[T] [B] #307,310
Did you try to fix them like the error message suggested?
+Anonymous C — 13 years ago, 12 minutes later, 14 minutes after the original post[T] [B] #307,313
+Omen !!hnQvReR0M — 13 years ago, 4 minutes later, 18 minutes after the original post[T] [B] #307,314
Yes.
·Frank Usrs (OP) — 13 years ago, 35 minutes later, 54 minutes after the original post[T] [B] #307,315
@307,310 (B)
Apparently MySQL checks for corrupt tables on startup, so I just restarted MySQL. I've never had to repair a database until now.
@307,313 (C)
I have no idea, that's why I'm asking if things are better for you guys.
·Anonymous B — 13 years ago, 5 minutes later, 59 minutes after the original post[T] [B] #307,316
@previous (Frank Usrs )
Just got this. Goes away after refreshing.
I'm assuming it's the same error.
A database error occurred on line 112 of /home/tinychan/tinychan.org/index.php. Message: "SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_f177_0.MYI'; try to repair it"
+FuckAlms !vX8K53rFBI — 13 years ago, 25 minutes later, 1 hour after the original post[T] [B] #307,320
I get it when I try to use my regular ID.
·Frank Usrs (OP) — 13 years ago, 2 minutes later, 1 hour after the original post[T] [B] #307,321
@307,316 (B)
@previous (FuckAlms !vX8K53rFBI)
Ugh. Working on it.
·Frank Usrs (OP) — 13 years ago, 16 minutes later, 1 hour after the original post[T] [B] #307,323
How about now? Pruned the activity table, so things should be running a lot smoother.
·Frank Usrs (OP) — 13 years ago, 3 minutes later, 1 hour after the original post[T] [B] #307,324
Disregard, /tmp is full, so the errors are probably going to re-appear. Working on fixing it.
·FuckAlms !vX8K53rFBI — 13 years ago, 2 hours later, 4 hours after the original post[T] [B] #307,340
Have you tried running a cron job to get rid of any IDs with zero posts?
You might also want to try dumping the failed postings table.
(Edited 2 minutes later.)
·FuckAlms !vX8K53rFBI — 13 years ago, 2 hours later, 6 hours after the original post[T] [B] #307,363
Ok, so the deal is whenever someone cites a post by your ID, the board breaks for you. Once you go to the topics where you were cited and the flags are cleared, then things work again. And the only way to find the thread seems to be the
replies page.
(Edited 5 minutes later.)
·Anonymous C — 13 years ago, 52 minutes later, 7 hours after the original post[T] [B] #307,369
A database error occurred on line 5 of /home/tinychan/tinychan.org/hot_topics.php. Message: "SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYUo9Aj6' (Errcode: 28)"
A database error occurred on line 112 of /home/tinychan/tinychan.org/index.php. Message: "SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_100a_0.MYI'; try to repair it"
A database error occurred on line 45 of /home/tinychan/tinychan.org/history.php. Message: "SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_100a_0.MYI'; try to repair it"
A database error occurred on line 39 of /home/tinychan/tinychan.org/pm_inbox.php. Message: "SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine"
A database error occurred on line 23 of /home/tinychan/tinychan.org/trash_can.php. Message: "SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_100a_0.MYI'; try to repair it"
Dunno if it helps but there's more now, not just line 112 that was showing up earlier.
+Anonymous F — 13 years ago, 1 hour later, 8 hours after the original post[T] [B] #307,374
@307,363 (FuckAlms !vX8K53rFBI)
So we shouldn't cite anymore?
·Anonymous A (OP) — 13 years ago, 2 hours later, 11 hours after the original post[T] [B] #307,388
Everything's alright now.
lol @ open sores shitware
+Red Creme !Soda7m0OQk — 13 years ago, 18 seconds later, 11 hours after the original post[T] [B] #307,389
Start a new topic to continue this conversation.
Or browse the latest topics.