Geek Posted August 28, 2002 Share Posted August 28, 2002 On posting a reply I was getting the 'Error Type 500 - internal server error' message. Luckily I checked whether the reply had actually succeeded before trying again. From experience this is caused by a SQL syntax problem and given that the reply is actually getting saved then... does the update routine do anything after adding the reply? Updating the user profile for example? Link to comment Share on other sites More sharing options...
Violet Elizabeth Posted August 28, 2002 Share Posted August 28, 2002 Getting "HTTP 500 - Internal server error " on all replies at the moment. Still posts OK, but is a bit of pain. Link to comment Share on other sites More sharing options...
scooby dooby doo Posted August 28, 2002 Share Posted August 28, 2002 Rob? Have you taken a week off or something 🤔 you've suddenly gone active on cam and blatchat and perked up on tour7.... HOOPY CYCLE WINGS CUCUMBER Link to comment Share on other sites More sharing options...
Red SLR Posted August 28, 2002 Share Posted August 28, 2002 The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. -------------------------------------------------------------------------------- Please try the following: Open the www.blatchat.com home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer ARRRGGGHHH!!! *mad* *mad* X777CAT Link to comment Share on other sites More sharing options...
FH Posted August 28, 2002 Share Posted August 28, 2002 Moi aussi ☹️ I get round multiple postings by opening BlatChat in another window and checking whether or not it has landed, but it's a right pain in the 🙆🏻 Link to comment Share on other sites More sharing options...
Site Manager Posted August 28, 2002 Share Posted August 28, 2002 Rob, yes it does a few things 1) updates the time and date of the last post and the number of replies in this topic 2) updates the time and date of the last post and the number of posts in this forum 3) updates the user's post count 4) updates the total number of posts overall Link to comment Share on other sites More sharing options...
Geek Posted August 28, 2002 Author Share Posted August 28, 2002 Hoops - actually having one of my busiest weeks for quite a while - but hardware problems not software which is giving me a bit of a chance to check emails out... I'll probably go quiet again soon... Link to comment Share on other sites More sharing options...
scooby dooby doo Posted August 28, 2002 Share Posted August 28, 2002 are you coming to Ireland Rob 🤔 HOOPY CYCLE WINGS CUCUMBER Link to comment Share on other sites More sharing options...
Geek Posted August 28, 2002 Author Share Posted August 28, 2002 Mr Site Manager, Sir. There's probably a bit of SQL with dodgy syntax in one of these four actions. I've been having a similar problem(s) with another 7's related site that I'm writing (ASP based as well - I'm using Access as the backend, but not sure what you're using). The method I've evolved of finding where the problem is is to put Response.End fairly high up the page (i.e. before one of the areas where the problem could be occurring) then test and move the Response.End down the page until the problem occurs. It was usually something silly like a data type mismatch (forgot the quotes, etc), or I've changed the backend and not the query. It doesn't tend to happen with a SELECT, just an UPDATE or INSERT. Is it intermittent? Affecting everyone or just particular people? Sorry if I'm teaching you to suck eggs :o) Link to comment Share on other sites More sharing options...
Geek Posted August 28, 2002 Author Share Posted August 28, 2002 D'oh! Just noticed in another thread that someone is reporting a Jet database error - so it does look like you're using Access.... Link to comment Share on other sites More sharing options...
Site Manager Posted August 28, 2002 Share Posted August 28, 2002 seems to be intermittent. ☹️ I don't get it whilst testing here at home or on the test site that I have which is on the same server as BlatChat. There are a couple of potential issues. Of course when I put the views count in, I have increased the workload on the server/database quite considerably, just take a look at the number of views compared with posts and work out how many more database updates there are now. I suspect that the problem might be that I'm running on an Access backend too, and given that there were over 150 people connected earlier on today, the problems might just stem from that. Who knows Also it would be a lot more useful if I had some error messages to go on. Can you turn "friendly error messages" off in your browser and let me know the details when it happens next. Link to comment Share on other sites More sharing options...
Geek Posted August 28, 2002 Author Share Posted August 28, 2002 I've taken the friendly error messages off but of course it's refusing to fall over now Access gets a bit flaky with larger databases, but I wouldn't have thought you'd have reached that point yet. I'll do the same thing with my project and if anything likely raises its head there I'll let you know. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now