Please contact the board administrator...

Talk about the website, offer suggestions, express opinions, and get help with understanding and using the forums.
User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Please contact the board administrator...

Post by Hardcore »

General Error
SQL ERROR [ mysqli ]

Can't connect to MySQL server on '127.0.0.1' (111) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
](*,)
I received this error when I was trying to view a thread in Mindless Games, I refreshed a few times, and even tried opening the thread in a new tab - nothing. What happened?
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.

SASSZAIN
Moderator
Moderator
Posts: 5266
Joined: Jan 27, 2006 8:09am
Gender: Female
Location: Everywhere and nowhere
Contact:

Re: Please contact the board administrator...

Post by SASSZAIN »

which thread?
"Sometimes being a man means doing things that you don't want to do." - Kazuma Kuwabara
"A Man must face himself, before he can face his Ememies" - Tai Kamiya
Member of the ModSquad 8)

User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Re: Please contact the board administrator...

Post by Hardcore »

There's several. It happened also with the "What're you listening to now" thread in Music discussions. I'm not sure if it's still happening today or not, because I just logged on.

edit: it is.
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.

Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway
Contact:

Re: Please contact the board administrator...

Post by Theo »

I'll look into it. If it happens again can you cut and paste the entire URL from the browser of which page you were on. Some pages have more content and hit the database harder than others.

Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway
Contact:

Re: Please contact the board administrator...

Post by Theo »

Found the problem. It appears that the database has a bad index. If you don't know what that means, don't worry. As a result the database has been restarting itself to try to fix it. I will see if we can rebuild all of the indexes manually if necessary to resolve the problem.

Thanks for reporting this error.

User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Re: Please contact the board administrator...

Post by Hardcore »

You're welcome, do you need the name of some of the threads that do it?
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.

Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway
Contact:

Re: Please contact the board administrator...

Post by Theo »

No. The problem was the database so in this case it was random. When the call to the database encountered a problem it would restart the database, which led to the error that you saw.

User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Re: Please contact the board administrator...

Post by Hardcore »

But several times on only a few threads? :o
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.

Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway
Contact:

Re: Please contact the board administrator...

Post by Theo »

Yes. It was bouncing 5 or 6 times per minute. So, as the database would restart, it would work for a few second and then crash. It was an endless cycle that apparently started in the last 48 hours. Several people probably noticed it but just didn't report it.

Post Reply