Anyone else seeing this error?
Moderators: alietr, trainman, econgator, dhkendall
- econgator
- Let's Go Mets!
- Posts: 10689
- Joined: Fri Jul 01, 2011 10:32 am
Anyone else seeing this error?
General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
===========================================================================
Seems to happen only if I edit a post or try to delete a post.
If I edit the post and see this error, I can hit the BACK button on my browser and the edit goes through just fine.
If I try to delete a post, again I can hit the BACK button and the post is deleted, but the LAST POST column still shows that I was the last poster, even though the post is gone.
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
===========================================================================
Seems to happen only if I edit a post or try to delete a post.
If I edit the post and see this error, I can hit the BACK button on my browser and the edit goes through just fine.
If I try to delete a post, again I can hit the BACK button and the post is deleted, but the LAST POST column still shows that I was the last poster, even though the post is gone.
-
- Loyal Jeopardista
- Posts: 196
- Joined: Mon Feb 04, 2019 10:33 pm
Re: Anyone else seeing this error?
Been getting various SQL errors for a couple days now. I figured TPTB already knew about it.econgator wrote: ↑Fri Jan 31, 2020 2:57 pm General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
===========================================================================
Seems to happen only if I edit a post or try to delete a post.
If I edit the post and see this error, I can hit the BACK button on my browser and the edit goes through just fine.
If I try to delete a post, again I can hit the BACK button and the post is deleted, but the LAST POST column still shows that I was the last poster, even though the post is gone.
--
Drowning in the pool
Drowning in the pool
- alietr
- Site Admin
- Posts: 9006
- Joined: Thu Jun 30, 2011 1:20 pm
- Location: Bethesda, MD
Re: Anyone else seeing this error?
Yeah, there are problems with editing posts at the moment.
-
- Loyal Jeopardista
- Posts: 196
- Joined: Mon Feb 04, 2019 10:33 pm
Re: Anyone else seeing this error?
For what it's worth, there's another squirrely issue I'm seeing too - no matter how many times I read it or mark it read, the January 28th online test thread (all six pages of it now) show unread. Nothing I can do will mark that thread read, even marking the entire forum read. Not sure if it's related or not, just throwing that out there. Yes, I've tried multiple browsers (Chrome, Edge, IE, FireFox and Android Chrome). Not really problematic, but an anomaly that may or may not help you troubleshoot.
--
Drowning in the pool
Drowning in the pool
-
- Undefeated in Reruns
- Posts: 8965
- Joined: Fri Jul 01, 2011 9:31 am
Re: Anyone else seeing this error?
This seems to be the issue econgator is alluding to in his last paragraph.ParrotRob wrote: ↑Fri Jan 31, 2020 3:37 pmFor what it's worth, there's another squirrely issue I'm seeing too - no matter how many times I read it or mark it read, the January 28th online test thread (all six pages of it now) show unread. Nothing I can do will mark that thread read, even marking the entire forum read. Not sure if it's related or not, just throwing that out there. Yes, I've tried multiple browsers (Chrome, Edge, IE, FireFox and Android Chrome). Not really problematic, but an anomaly that may or may not help you troubleshoot.
- AndyTheQuizzer
- Lots and Lots of Interviews
- Posts: 2606
- Joined: Fri Jul 01, 2011 11:01 am
- Location: St. John's, Newfoundland and Labrador, Canada
- Contact:
Re: Anyone else seeing this error?
Yes, the server crashed as I was attempting to post the answers to last night's test. I think some PHPBB files may have been corrupted in the process.econgator wrote: ↑Fri Jan 31, 2020 2:57 pm General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
===========================================================================
Seems to happen only if I edit a post or try to delete a post.
If I edit the post and see this error, I can hit the BACK button on my browser and the edit goes through just fine.
If I try to delete a post, again I can hit the BACK button and the post is deleted, but the LAST POST column still shows that I was the last poster, even though the post is gone.
- Robert K S
- Jeopardy! Champion
- Posts: 5313
- Joined: Thu Jun 30, 2011 1:26 pm
- Location: Cleveland, Ohio
- Contact:
Re: Anyone else seeing this error?
Maybe we should just delete that thread and re-post?
- VaBanque
- Contributor
- Posts: 24
- Joined: Wed Jan 29, 2020 1:26 pm
- Location: Poland
- Contact:
Re: Anyone else seeing this error?
My thread "Interesting trivia..." stay in thread list after delete. Post from this delete thread I replace in another place.
-
- Loyal Jeopardista
- Posts: 182
- Joined: Thu Mar 20, 2014 9:55 am
Re: Anyone else seeing this error?
I see the error whenever I edit now. However, I find the edits have always gone through when I navigate back to the post.
- Category 13
- Wagering Viking
- Posts: 1912
- Joined: Fri Jun 06, 2014 1:43 pm
- Location: This side of paradise
Re: Anyone else seeing this error?
Same here.True North wrote: ↑Fri Jan 31, 2020 8:08 pm I see the error whenever I edit now. However, I find the edits have always gone through when I navigate back to the post.
First occurrance was early A.M. this morning.
- MinnesotaMyron
- JBOARDIE OF THE MONTH!
- Posts: 3461
- Joined: Fri Jul 01, 2011 12:53 pm
Re: Anyone else seeing this error?
When I try to search:
General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
+++++
I'm not having any problem marking the board threads "read", though.
General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
+++++
I'm not having any problem marking the board threads "read", though.
- MarkBarrett
- Watches Jeopardy! Way Too Much
- Posts: 16556
- Joined: Fri Jul 01, 2011 10:37 am
- Location: San Francisco
Re: Anyone else seeing this error?
That's what I got when trying a search for "poll request" to see if there are any requests for the weekly poll. Using Google with the site:jboard.tv is the extra annoying step to take.MinnesotaMyron wrote: ↑Sat Feb 01, 2020 4:33 pm When I try to search:
General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
+++++
I'm not having any problem marking the board threads "read", though.
- MinnesotaMyron
- JBOARDIE OF THE MONTH!
- Posts: 3461
- Joined: Fri Jul 01, 2011 12:53 pm
Re: Anyone else seeing this error?
That's what I had to do too. But no worries, since I finally just bookmarked the FJ resource, instead of searching for it every time I want to reference it for the last 4 or 5 years or whatever.MarkBarrett wrote: ↑Sat Feb 01, 2020 4:50 pmThat's what I got when trying a search for "poll request" to see if there are any requests for the weekly poll. Using Google with the site:jboard.tv is the extra annoying step to take.MinnesotaMyron wrote: ↑Sat Feb 01, 2020 4:33 pm When I try to search:
General Error
SQL ERROR [ mysqli ]
Table './agefen_phpBB/phpbb_search_wordmatch' is marked as crashed and last (automatic?) repair failed [144]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
+++++
I'm not having any problem marking the board threads "read", though.
- alietr
- Site Admin
- Posts: 9006
- Joined: Thu Jun 30, 2011 1:20 pm
- Location: Bethesda, MD
Re: Anyone else seeing this error?
I am trying to get this resolved.
-
- Undefeated in Reruns
- Posts: 8965
- Joined: Fri Jul 01, 2011 9:31 am
Re: Anyone else seeing this error?
Another symptom seems to be that the last post on a page with a deleted post also appears as the first post on the following thread.
- Robert K S
- Jeopardy! Champion
- Posts: 5313
- Joined: Thu Jun 30, 2011 1:26 pm
- Location: Cleveland, Ohio
- Contact:
Re: Anyone else seeing this error?
We might have... fixed it? Please post here with any lingering issues.
- econgator
- Let's Go Mets!
- Posts: 10689
- Joined: Fri Jul 01, 2011 10:32 am
Re: Anyone else seeing this error?
So far, the only issue I see is that the mod "?" doesn't go away on old posts even though there is nothing left to moderate.
- MarkBarrett
- Watches Jeopardy! Way Too Much
- Posts: 16556
- Joined: Fri Jul 01, 2011 10:37 am
- Location: San Francisco
Re: Anyone else seeing this error?
Today I could do a search and I was able to edit my "reserved" placeholder post to add in my comments. Thanks for the fix, gentlemen.
- Robert K S
- Jeopardy! Champion
- Posts: 5313
- Joined: Thu Jun 30, 2011 1:26 pm
- Location: Cleveland, Ohio
- Contact:
Re: Anyone else seeing this error?
We noticed that, and short of doing manual surgery on the database there is probably no way to address it, so we're going to leave that one go.
- alietr
- Site Admin
- Posts: 9006
- Joined: Thu Jun 30, 2011 1:20 pm
- Location: Bethesda, MD
Re: Anyone else seeing this error?
Those resulted from me deleting spammers, and presumably those will start going away as those threads age.Robert K S wrote: ↑Thu Feb 06, 2020 1:14 pmWe noticed that, and short of doing manual surgery on the database there is probably no way to address it, so we're going to leave that one go.