mysql gone error and header warning - not sure what is happening?
|
bunnyjen
Joined: 2004-01-27
Posts: 22 |
Posted: Fri, 2007-01-26 20:47
|
|||||
|
My G2 has run flawlessly for ... well, since I installed it (http://www.trevandjen.ca/gallery). I love it. However, a little while ago my server company had a massive hardware failure and my domain was down for a while. It's been up for a bit but I haven't had cause to go use my Gallery (other than a cursory look to see whether it was actually working when it was restored) until today. However, I am getting some really strange errors. I can't replicate them consistently, either, so although I wrote the hosting company I'm not really sure whether they can help me as I am not sure what the issue really is and I don't know whether they have replicated them at all or not. They happen to me both in FF and IE. There are two errors that I am getting. The first is a "mysql gone" error which appears in the upper left-hand corner of my browser. This seems to appear when things are not rendering right or when thumbnails aren't there and I refresh the page. The second error, but seemingly related, is this one: Quote:
mysql gone From what I can see, all of the permissions are correct. I am running another version of G2 on the domain (located at michael.trevandjen.ca) and it doesn't seem to have these errors so I don't think that they have reconfigured anything that would be interfering with Gallery. Could it be corrupted data in the restored version of my SQL DB for my gallery? I was going to try to go through the Gallery install to see if that would fix it but the install keeps hanging up right after authentication. :| I have attached two screenshots showing the errors. I do have a backup of my SQL DB from August 2006. Unfortunately, I forgot to back it up more recently and I have added one album since (not sure if there is a way to extract only the data from one album from a DB and add it so I wouldn't have to redo it again?) but if I have to redo the album that's what I have to do. It's not that big a deal. I just didn't want to do too much damage until I saw if someone else had run across these issues and/or knew what was causing them. Thanks in advance for any help you can give. Jennifer
|
||||||
| Login or register to post comments |
Posts: 22
Hmm. I finally got the installation module to run past the authentication step and things seem to be working OK for now. Here's hoping it's fixed itself!
Posts: 32356
the second error, "Warning: Cannot modify header information - headers already sent by (output started at" is just a consequence of the "mysql gone" issue.
you'd get the second error pretty often as a symptom of another issue, as in this case.
so let's focus on "mysql gone".
it's definitely a mysql related issue. either the mysql server has a problem or some corruption in the database actually kills the connection or the server during an interaction.
have you already run mysqlchk / myisamchk or other tools to check your database?
--------------
Enter the Gallery 2 Theme Contest today!
Posts: 22
I ran a check on the SQL DB through the mysql page and everything came back OK. I wrote the service provider assuming it was some sort of data corruption from when they repaired everything and they are, as I expected, trying to argue it is a script error (likely because of the second error, which is obviously caused by the first error but try arguing that with them... never works no matter how helpful they are I guess) which I know is unlikely but whatever. I haven't run into the problem since I reran the installation module so I don't know if whatever hiccup existed in the SQL file was overwritten somehow or what but I'm not going to argue with it. Thanks for the response, though. I was getting nervous for a minute!