Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Need Help boRg, Internal Server error 500
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Need Help boRg, Internal Server error 500

 Post Reply Post Reply Page  12>
Author
Andersen View Drop Down
Groupie
Groupie


Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
Post Options Post Options   Thanks (0) Thanks(0)   Quote Andersen Quote  Post ReplyReply Direct Link To This Post Topic: Need Help boRg, Internal Server error 500
    Posted: 19 August 2003 at 3:27pm

boRg, I know you´re busy, but could you please read and comment on this thread:

http://forums.webwiz.net/forum_posts.asp?TID=4988&PN=2&get=last#24089

I have no idea how to fix/change this problem. It´s NOT server regarded.

Thx.

Greets
Andersen
Back to Top
Andersen View Drop Down
Groupie
Groupie


Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
Post Options Post Options   Thanks (0) Thanks(0)   Quote Andersen Quote  Post ReplyReply Direct Link To This Post Posted: 19 August 2003 at 6:49pm

Seems like I have found the reason for this error. (And a fix!!!).

A time ago, I upgraded from version 6.x til 7.01. In that upgrade, I used the utility to convert the Access database as well. This convertion went fine, except, several people started reporting, they received mails from the forum about new messages in a thread they have NOT asked for.

I could also see in may mailbox, that my mailserver tried to send alot of mails from the forum to the users. And specially one particular user had an faulty email address in his profile. I (as administrator) edited his profile, removing his email address completely. From this day, the troubble started, (as mentioned in the above link).

Today I came to remember what I had changed, and I edited his profile again, and this time I inserted my administrator email adress insted. Now there is no more Internal Server Error 500 when entering a message in those two specific forums anymore. 

I can reproduce the error, and fix it again (now I know how to).

-boRg-, this has to be a problem with the forum. What I did, anyone can do. Subscripe to Watch a specific forum (or thread) and then remove his email address from the profile. And it will result in the error again.

You might ask, why the hell remove the email address, when have subscriped to watch a thread/forum - Well, in this case I had to, cause the forum tried to send him a message all the time, and it failed, ending up filling my administrator mailbox insted.

I hope you can use this for something or a change in the next version. In case you want to see for yourself, just yell!

An suggestion - It would be good if the Administrator had an option to remove all Watch/Unwatch flags set for an specific user. This might have helped me in this case, rather than to edit the users profile/email address.

 



Edited by Andersen
Greets
Andersen
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2003 at 3:55am

I shall look into it.

I have for the next version added a link in the profile to view that persons email subscriptions and remove them, this is also available for the admin when editing another users profile.

You can see it yourself by clicking the email button at the top of your edit profile page in this forum to view all your email subscriptions.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2003 at 3:59am

Here is a fix for your problem, change line 962 of post_message.asp to:-

If lngEmailUserID <> lngLoggedInUserID AND strUserEmail <> "" Then

Back to Top
Andersen View Drop Down
Groupie
Groupie


Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
Post Options Post Options   Thanks (0) Thanks(0)   Quote Andersen Quote  Post ReplyReply Direct Link To This Post Posted: 26 August 2003 at 3:16pm

Seems to be working for now. Thx. boRg.

 

Greets
Andersen
Back to Top
Andersen View Drop Down
Groupie
Groupie


Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
Post Options Post Options   Thanks (0) Thanks(0)   Quote Andersen Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 2:52pm

Hmm boRg, does this change got something to do with forum showing the wrong number of users online on the forum now?

Please take a look at my forum and the number of online users (down at the right), and click "Aktive Brugere" to show the correct number. There is something wrong somewhere.

My forum:

http://www.nordicreefforum.dk

 

Greets
Andersen
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 4:18pm

If you are using the Access version then thbis is the problem as Access doesn't fully delete entries and slowly becomes corrupted the only way to fix it is to download the database and compact and repair it in access.

However you should keep the active users tuirned off in the access version for this very reason as sometimes the corruption to an access database can mean that all data is lost.

Access simply can not handle the number of updates required for an active user count.

Back to Top
Andersen View Drop Down
Groupie
Groupie


Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
Post Options Post Options   Thanks (0) Thanks(0)   Quote Andersen Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 6:20pm

Hmm.. I see.

Is there anyway to change to SQL insted? (and still have my data in the forum).

 

Greets
Andersen
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.