Web Wiz Forums - Unsubscribe link in Notify mails

Print Page | Close Window

Unsubscribe link in Notify mails

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25202
Printed Date: 04 April 2026 at 2:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Unsubscribe link in Notify mails

Posted By: wasp
Subject: Unsubscribe link in Notify mails
Date Posted: 23 January 2008 at 12:25am

Hope someone can shed some light on this one:

When clicking on the unsubscribe (or unwatch) link in a notify mail, it goes to the http500 page though the server seems to be working OK in all other respects.

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 23 January 2008 at 8:56am

If you disable Friendly HTTP Errors in IE you will get a detailed error message which should hlep workout the exact issue.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wasp
Date Posted: 23 January 2008 at 12:38pm

Thanks Bruce,

I get this but I have no idea what it means.

Microsoft OLE DB Provider for SQL Server error '80004005'

Could not find server 'SCL-SQL02\MSSQL2005' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

/forum/email_notify.asp, line 329

-------------
Wasp

Posted By: WebWiz-Bruce
Date Posted: 23 January 2008 at 12:43pm

This is a problem with your SQL Server.

It means that someone at some point has changed the name of the server or migrated the SQL Server to another server.

You can fix this by using sp_addlinkedserver to add in the new server name in SQL Server, however, I have found in the past the best way to fix this issue is to uninstall and then reinstall the SQL Server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wasp
Date Posted: 23 January 2008 at 2:17pm

Thanks bruce,

I'll ask my server chap.

-------------
Wasp