Record of SQL Errors Et Cetera

Your opinion is important to us. Please continue to hold. Just kidding: Post your brainstorms here.

Moderator: Sean

Post Reply
User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Record of SQL Errors Et Cetera

Post by RJDiogenes » Tue Sep 02, 2008 11:55 pm

In hopes of preventing another Apocalypse, we can use this Thread to keep track of any problems that we fear may foreshadow another crash (the previous crash seems to have been preceded by frequent SQL errors).

Today, I had two SQL errors before I could get in. I've experienced one previous SQL error on the revived board, a couple of days ago.

There was also one day where I was experiencing frequent 404 Errors when trying to post (and I had to delete a half a dozen double posts because of it). I think I've experienced at least one initial 404 Error every time I've logged into the Administrator's Control Panel.
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Wed Sep 03, 2008 12:06 am

Today, I've recieve the same 404's as RJ every timen I've tried to post, though the post still gets posted, and 2 SQL errors while logging in, and again after a post.
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
Renie
Our Founder
Our Founder
Posts: 977
Joined: Thu Aug 21, 2008 2:26 pm
Contact:

Re: Record of SQL Errors Et Cetera

Post by Renie » Wed Sep 03, 2008 7:29 pm

Hi everyone,

Hopefully I will be able to look into the errors sometime in the next couple of weeks. I apologize in advance...I was gone all last weekend, and this next weekend I'm moving. There are likely a few fixes I can make to remedy the worst of the errors.

If you could please copy/paste the SQL errors into this thread, that would be great. The messages and code numbers mean different things, implying different fixes.

Sorry about this! :P

:coffee:
:canadian: :james: :wiggle:

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Wed Sep 03, 2008 8:11 pm

^ No problemo. The site seems to work, these things are just little pains in the butt. I get 404 errors saying that the page could not be found every time I return to the index or thread page from a login or a post. I'll copy and paste any SQLs I get.
Not Found

The requested URL http:// was not found on this server.
I just realized that if I hit one of the option buttons that the "your post was entered successfully" page, like "return to thread", instead of letting jy browser redirect me automatically, I don;t get the 404's. I don't know if that is helpfull info, but I figured I'd share it anyway...
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
Renie
Our Founder
Our Founder
Posts: 977
Joined: Thu Aug 21, 2008 2:26 pm
Contact:

Re: Record of SQL Errors Et Cetera

Post by Renie » Wed Sep 03, 2008 11:50 pm

I'm getting those too. I think I accidentally erased something when I was fixing the stylesheets. Thankfully, it seems like mostly a nuisance...but that will be the first thing I get to when I work on the board again. :book:
:canadian: :james: :wiggle:

User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes » Wed Sep 03, 2008 11:57 pm

No problem. This will just hopefully be a helpful record. I thought about copying the SQL code after I started the Thread, but it was too late to go back and get it. :blush:
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
Lupine
Imperator
Imperator
Posts: 32030
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine » Fri Sep 05, 2008 5:26 pm

I had a SQL error pop up today at 9:00 am.

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Sun Sep 07, 2008 1:35 am

At 9h33 ( my local time), I got this SQL error after submitting a post.

General Error
SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql' (13) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I tried hitting my bookmark of the site again to refresh it, and I got the same error. So, I manually typed the address into my address bar, and a page popped up to say that I had a 400 error, and that something was a bad request ( I'm assuming it's referring to the addy I typed).

Hopefully this post will make it through...
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes » Sun Sep 07, 2008 9:24 am

A couple of minutes ago, I got a "Network Connection Interrupted" error. That's a new one. But it went right through a couple of seconds later.
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
Lupine
Imperator
Imperator
Posts: 32030
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine » Sun Sep 07, 2008 3:41 pm

I got a SQL Error message at 8:37 am PST while trying to post in the BBQ thread. I clicked "return to index page" link and the site came back.

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Sun Sep 07, 2008 3:48 pm

When I first logged on, I was brought to the index page, but a simplified text only version of it. I refreshed the page, and got another SQL. This was probably around 11h30 am EST. I tried again a few minutes later, and the site worked fine, although the 404's after posting are still present.
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
mudshark
Centurion
Centurion
Posts: 1199
Joined: Sat Aug 23, 2008 6:31 pm

Re: Record of SQL Errors Et Cetera

Post by mudshark » Sun Sep 07, 2008 3:49 pm

I'm wondering whether the Yahoo! problems people have been experiencing over the last few days are related to the SQL errors we've experienced here? I'm not any sort of website/coding/server ace, so they could be completely separate issues and I wouldn't know -- just thought I'd throw it out there.

EDIT:

Got this error:
Return to index page
General Error
SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql' (13) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
while posting the above post. How conveeeenient!
Methinks Ted Sturgeon was too kind.

Information is not knowledge. Knowledge is not wisdom. Wisdom is not truth.
Truth is not beauty. Beauty is not love. Love is not music. Music is the best...

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Sun Sep 07, 2008 4:02 pm

These errors are worrying me. I'm going to copy and paste all of my OPs in the writing and PA forums to word documents to back them up...just in case.
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Sun Sep 07, 2008 6:43 pm

I'm not sure if this is the same message I've been getting, but here it is anyway...
General Error
SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql' (13) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes » Sun Sep 07, 2008 7:43 pm

mudshark wrote:I'm wondering whether the Yahoo! problems people have been experiencing over the last few days are related to the SQL errors we've experienced here?
I'll bet they are related.

I got a few SQLs today, too, while working on the new Forum. Same message as above.
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
Cayla
Consul
Consul
Posts: 18777
Joined: Fri Aug 22, 2008 11:58 am
Location: Ohio

Re: Record of SQL Errors Et Cetera

Post by Cayla » Wed Sep 10, 2008 3:52 pm

I got two SQL errors yesterday afternoon when I tried to pull up the site.
It is possible to commit no mistakes and still lose. That is not a weakness; that is life. -Jean Luc Picard

User avatar
jgc
Senator
Senator
Posts: 13471
Joined: Fri Aug 22, 2008 12:27 am
Location: Sunny (usually) Florida!
Contact:

Re: Record of SQL Errors Et Cetera

Post by jgc » Wed Sep 10, 2008 11:14 pm

When I'm using my laptop with the wireless connection, every time I post, when it goes to automatically go back to the forum, I get an error message - Can't find this page type of message.
Imagine by John Lennon

:nh:

User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes » Thu Sep 11, 2008 12:57 am

^^ Just with the wireless? Interesting.

AS thinks there's probably a glitch in the stylesheet. I wish I knew what that meant. :veryhappy:

I got three of the same old SQL errors today.
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
Cayla
Consul
Consul
Posts: 18777
Joined: Fri Aug 22, 2008 11:58 am
Location: Ohio

Re: Record of SQL Errors Et Cetera

Post by Cayla » Thu Sep 11, 2008 1:13 am

I got another SQL this afternoon.
It is possible to commit no mistakes and still lose. That is not a weakness; that is life. -Jean Luc Picard

User avatar
jgc
Senator
Senator
Posts: 13471
Joined: Fri Aug 22, 2008 12:27 am
Location: Sunny (usually) Florida!
Contact:

Re: Record of SQL Errors Et Cetera

Post by jgc » Thu Sep 11, 2008 3:04 am

Yes, I just got three or four in a row..... :mellow:
Imagine by John Lennon

:nh:

User avatar
Cayla
Consul
Consul
Posts: 18777
Joined: Fri Aug 22, 2008 11:58 am
Location: Ohio

Re: Record of SQL Errors Et Cetera

Post by Cayla » Thu Sep 11, 2008 12:37 pm

I went to make a post in Misc. this morning and this is what I got...

SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql' (13) [2003]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
It is possible to commit no mistakes and still lose. That is not a weakness; that is life. -Jean Luc Picard

User avatar
Lupine
Imperator
Imperator
Posts: 32030
Joined: Fri Aug 22, 2008 3:33 pm
Location: The State of Insanity

Re: Record of SQL Errors Et Cetera

Post by Lupine » Thu Sep 11, 2008 6:56 pm

I got a SQL error at 11:51 am PST, then got another at 11:54 while trying to post here.

User avatar
RJDiogenes
Imperator Rex
Imperator Rex
Posts: 56884
Joined: Fri Aug 22, 2008 12:24 am
Location: Boston
Contact:

Re: Record of SQL Errors Et Cetera

Post by RJDiogenes » Sat Sep 13, 2008 8:06 pm

No SQLs for about two days! How's everybody else doing? :)
Please visit My Store and My Gallery and My YouTube Page. :)

:grape:

User avatar
jgc
Senator
Senator
Posts: 13471
Joined: Fri Aug 22, 2008 12:27 am
Location: Sunny (usually) Florida!
Contact:

Re: Record of SQL Errors Et Cetera

Post by jgc » Sat Sep 13, 2008 8:27 pm

I haven't had any today.
Imagine by John Lennon

:nh:

User avatar
Sean
Praetor
Praetor
Posts: 3854
Joined: Thu Aug 21, 2008 4:11 pm
Location: Hamburg, NY
Contact:

Re: Record of SQL Errors Et Cetera

Post by Sean » Sun Sep 14, 2008 1:54 am

Same here. Still getting the 404's after every post though.
"The difference between a violin and a viola is that a viola burns longer."-Victor Borge

"I have been busier than a one armed worm caught in a tape dispenser."- Astrosmurf, Tuesday July 22, 2008

Post Reply