Database Error Occurring Frequently - Are You Experiencing It Too?

  • Thread starter Thread starter lisab
  • Start date Start date
AI Thread Summary
Users are experiencing frequent database errors when trying to open threads or edit posts, with some reporting errors occurring 10% of the time or more. Specific issues include a consistent database error when attempting to edit a particular post, while others report sporadic errors. There are indications that the problems may have started following recent updates to MySQL and PHP, with users noting that certain links produce errors due to formatting issues. Additionally, a warning message regarding a missing cache file has been observed, although it does not seem to affect overall functionality. The community is encouraged to report these issues to assist administrators in troubleshooting.
lisab
Staff Emeritus
Science Advisor
Gold Member
Messages
2,026
Reaction score
623
Lately, when I try to open a thread, I get a database error about 10% of the time (sometimes more often). Looks like this -

20uqu4i.jpg


Seems to happen more and more frequently. Are others getting this as often as I am?
 
Physics news on Phys.org
I get sporadic errors. We'll look into it.
 
I'm getting database error 100% of the time when I try to edit this specific post. It doesn't matter much that I can't. I just wanted to remove the "Hm, that sounds like a lot" comment and end the sentence before it with a period. I can preview the edit just fine, but I can't save it. I have tried several times, and made other posts without problems between the attempts.

As I said, this isn't an important edit. I'm just posting this to let the admins know about this problem, in case they find it useful when investigating other situations where someone gets "database error".
 
Fredrik said:
I'm getting database error 100% of the time when I try to edit this specific post. It doesn't matter much that I can't. I just wanted to remove the "Hm, that sounds like a lot" comment and end the sentence before it with a period. I can preview the edit just fine, but I can't save it. I have tried several times, and made other posts without problems between the attempts.

As I said, this isn't an important edit. I'm just posting this to let the admins know about this problem, in case they find it useful when investigating other situations where someone gets "database error".

How bizarre, I get the same error when editing that post too, but every other post in that thread is fine!
 
I see database errors now and then too, but not as often - say once in every two, three days.
 
I updated mysql last night. I hope that helps the situation. Keep me updated. thanks!
 
Greg Bernhardt said:
I updated mysql last night. I hope that helps the situation. Keep me updated. thanks!
Oh - that's what happened. :biggrin:

I figured someone trip over the cord, or forgot to feed the squirrels.
 
OK, who tripped over the power cord and unplugged PF?

Zz.
 
There's a 5-hr gap between T 10:27 AM and T 03:33 PM, when PF crashed.
 
  • #10
Have it crashed after MySQL update, or for some other reason?
 
  • #11
Borek said:
Have it crashed after MySQL update, or for some other reason?

different reason
 
  • #12
There is some problem with opening threads from the search. I get all the time the following messageQ

Not Acceptable

An appropriate representation of the requested resource /showthread.php could not be found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


https://www.physicsforums.com/showthread.php?t=241386&highlight=Wave%96particle+duality

https://www.physicsforums.com/showthread.php?t=406161&highlight=Wave%96particle+duality

But I can open them through the links without the &highlight=Wave%96particle+duality part...
 
  • #13
%96 is a source of problems, how did it get there?
 
  • #14
Borek said:
%96 is a source of problems, how did it get there?

Right. Take out %96, replace it with a +, and it works ok.
 
  • #15
Not sure if this is the same issue, so I wasn't sure if I should start a new thread. But I get this often, at the very top of the page (above the title):

Warning: unlink(/home/physicsf/cache/www.physicsforums.com-blog_external.php.cache) [function.unlink]: No such file or directory in [path]/includes/init.php(294) : eval()'d code on line 187

It started about a month or so ago, and I think it's getting more frequent. Doesn't seem to affect functionality, though.
 
  • #16
lisab said:
Not sure if this is the same issue, so I wasn't sure if I should start a new thread. But I get this often, at the very top of the page (above the title):

Warning: unlink(/home/physicsf/cache/www.physicsforums.com-blog_external.php.cache) [function.unlink]: No such file or directory in [path]/includes/init.php(294) : eval()'d code on line 187

It started about a month or so ago, and I think it's getting more frequent. Doesn't seem to affect functionality, though.

yeah ever since I upgraded php (which was a month ago) some of our rss feeds have gotten a bit screwed up.
 

Similar threads

Back
Top