CAPTCHA & Deleting Problems
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=23121
Printed Date: 07 April 2026 at 2:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: CAPTCHA & Deleting Problems
Posted By: biggieb
Subject: CAPTCHA & Deleting Problems
Date Posted: 16 April 2007 at 4:52pm
|
I'm having a problem on my forums recently. We can no longer delete posts and the CAPTCHA security logon doesn't work anymore. My web hoster recently moved our SQL database to a new server and this seems to be when the problems started. Users that are able to login can post but new users can't register due to the CAPTCHA problem.
My ISP has been extremely slow in looking into the problem. I have over 400 users and a pretty busy site and I need to fix this problem. I am locked out of the system since I failed to login in 3 times and no matter what I try that CAPTCHA just won't let me through. Below is the error my users receive when trying to delete a post. Any ideas of fixing this?
Microsoft OLE DB Provider for SQL Server error '80004005' Could not find server 'KUNDENMSSQLUS03' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. /Forum/delete_post.asp, line 185
(my forum site http://www.jerseyjam.com/forum/ - http://www.jerseyjam.com/forum/ )
(Using Web Wiz Forums ver. 8.01)
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 16 April 2007 at 6:13pm
|
I do recognise the SQL server name from an email about a month ago with an issue with KUNDENMSSQLUS01 (must have been the first SQL Server they moved as lots of sites that make shopping cart software also had people complaining a month ago about this) so looks like this is the same host who after a month still hasn't got there act together. The issues you are experiencing are not related to the Web Wiz Forums software but rather your web host has not done things correctly AGAIN. The CAPTCHA issues sounds like your hosting server has an issue holding the ASP session and you should get your web host on this straight away. The issue with the SQL Server KUNDENMSSQLUS03 is the same issue they had with KUNDENMSSQLUS01, the name of the SQL Server has been changed which courses configuration issues within SQL Server. I would think your host has not migrated the SQL server correctly, instead of moving installing SQL Server on the new server and then moving across databases using backups of each database they just used an entire server backup of the old server to load onto a new server in the process have screwed up the security settings within SQL server. The following is info on how to fix this:- http://msdn2.microsoft.com/en-us/library/ms190479.aspx - http://msdn2.microsoft.com/en-us/library/ms190479.aspx However, this fix often doesn't work and I find the best course of action is to uninstall SQL Server and reinstall it again. To be quite frank I would have thought this host would have learnt from screwing up the migration of the previous server a month ago, and if you have no luck with them I would certainly suggest looking elsewhere for a better host. ------------- 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: biggieb
Date Posted: 16 April 2007 at 7:44pm
|
Thank you very much :) I have sent out yet another email to them and this time I threatened to cancel my 3 websites with them. Hopefully they will act on this quickly cause I starting to loose users to other competing communities now. |
Posted By: biggieb
Date Posted: 17 April 2007 at 9:20pm
|
I don't seem to be getting anywhere with these people... They claim it's fixed yet it still does'nt work.
The 'control panel' for the web site has an SQL admin. Is there a way I can convert the SQL database to MsAccess so I can get the forum up and running or port the entire forum to some other ISP??
|
Posted By: fractalizer
Date Posted: 17 April 2007 at 10:53pm
|
I ran across this thread from a Google search when I got a nearly identical error on one of our sites. We're not using Web Wiz Forums, but the only difference in my error message is that the server name is 'KUNDENMSSQLUS05'. I called up the hosting company and they claimed there was no problem with their server, it must be the code. But we haven't touched the code in over a year and it used to work just fine. A little investigation shows that your hosting company is the same one we use, 1&1. Unfortunately it seems with their dirt-cheap prices they can't be bothered spending much time investigating these issues. We'll definitely switch hosting if they can't get their act together. |
Posted By: WebWiz-Bruce
Date Posted: 18 April 2007 at 10:08am
|
So these are 1&1's SQL Servers, that says it all. I would certainly recommend changing hosts ASAP, you only need to search this forum and you will see that no-one has a good thing to say about 1&1. ------------- 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: WebWiz-Bruce
Date Posted: 18 April 2007 at 10:21am
Looking at 1&1's prices they are not actually that cheap if you add up what you pay in a year, our own hosting at http://www.webwiz.net - www.webwiz.net actually works out cheaper and you can even have Web Wiz Forums installed on your site by us. Plus you'll get a much better service. ------------- 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 |
fractalizer wrote:Posted By: biggieb
Date Posted: 18 April 2007 at 6:40pm
|
1&1 is still non-responsive, I am losing members and now I'm looking into your hosting plans. I have a few conserns and maybe you can address them.
1) How can I get the entire site moved over and installed with out to much downtime. My registered users are still using my forum and posting messages but new user registration doesn't work and I'm blocked out of the system and can't shut down' the bbs during a host provider move. Bascially I don't want to lose any messages. BTW - I can handle the DNS changes and moving the website files.
2) 1&1's control panel allows me to back up the SQL database. If I elect to use your service would you move the backed database onto your SQL server and config my forum to use it?
3) My site was built using FrontPage 2003 and I would need to continue using it. Do you support it?
4) What's the minimum site package I would need to get my site up and running? The database is on a Microsoft SQL 2005 64bit platform.
Feel free to contact me directly (email address removed to stop spam harvesters)
|
Posted By: WebWiz-Bruce
Date Posted: 18 April 2007 at 7:15pm
|
1. Probally best to lock the forum during the move, if you can't do this in the admin area you may need to do this by adding a redirect in your common.asp file to a page explaining your issues to your users. 2. Not sure what type of backup you can make in your control panel on 1&1, but if you contact us we should be able to find a solution. 3. Yes do support Frontpage Exetensions so you can use Frontpage 2003 4. Only the Elite and Developer Plans currently support SQL Server 2005 at the present time. As long as you can get a backup should be able to get it running without to much trouble. If you contact us via email using the Contact Us forms or by phone to discuss this we should be able to have a look to see if your SQL Sever backup is compatible before you make the move. ------------- 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: biggieb
Date Posted: 19 April 2007 at 3:59pm
|
UPDATE:
I was able to reset my locked-out account by editing the Author table directly in the SQL Database. I set the login attempts for my account back to "0". I did a few tests on the forum and I can post and delete with no problems but I can not login as admin and new users can't register. The only problem seems to be the CAPTCHA security. Is there anything I can do to trouble shoot this problem and fix it or shut it off?
|
Posted By: WebWiz-Bruce
Date Posted: 19 April 2007 at 4:21pm
|
If the CAPTCHA is not working this suggests an issue with the server holding the ASP session. You should contact your hosting company to get them to sortout the problem on the server, but being 1&1 I doubt that would happen. The other option, which does effect performance, is edit the file functions/functions_session_data.asp in notepad and follow the instructions in that file to enable the database to store the session data. ------------- 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: biggieb
Date Posted: 19 April 2007 at 4:50pm
|
Just checked and it looks like I set this a while back, probably when I installed the forum.
"Const blnDatabaseHeldSessions = True"
|
Posted By: WebWiz-Bruce
Date Posted: 19 April 2007 at 7:27pm
|
I had a look at your forum and the issue don't appear to be problem with the CAPTCHA, the error message suggests an issue with the forum be able to track and authenticate the user. This usually occurs if there are problems with IP addresses or the server is has issues and is recycling the application pool. The kangaroo start stop speed at which your site is running also suggests that the application pool is recycling. This could be because there are issues on the server and the admin has set it to continue recycle every few minutes to keep all the sites available or there is an issue with the installation of IIS on the server. I would ask your host if they can not fix the issues that they move your site to another web server that is working correctly. ------------- 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: biggieb
Date Posted: 19 April 2007 at 9:00pm
|
Thanks for taking them time to check it out. I have emailed their support people again and we'll see if they'll do anything. I am on the verge of moving my site but it's such a pain in the butt. I'll keep ya posted.
Thanks!
|
Posted By: biggieb
Date Posted: 17 May 2007 at 3:03pm
|
Is there a way to convert my existing SQL database to MS Access? My site is still broken with the CAPTCHA problem and I performed a test by installing a 2nd Web Wiz forum on the same site using MS Access database and it worked fine and no problems with captcha. So I think there is some sort of problem with the SQL server cause this all started when they updated the MS SQL 2005 64.I'd love to covert the database and any help would be much appreciated!
|
Posted By: WebWiz-Bruce
Date Posted: 17 May 2007 at 3:41pm
|
SQL Server 2005 32 bit and 64 bit are almost identical so this shouldn't have any effect. The difference is that the 64 bit version can handle larger amounts of memory better above 2Gig, so your host is able to cram more databases onto the server. If you are still looking for hosting then the http://www.webwiz.net - Web Wiz Host hosting with SQL Server is very fast, just look at http://www.speakerplans.com/forum - www.speakerplans.com http://www.speakerplans.com/forum - /forum it has over 60 active users most of the time and it flies along. We have also just put another server online, to keep the severs as sparsely populated as possible, so if you sign up today you would be on a new Quad-Core server, with just 2 others sites on it!! We have also just put on a new Corporate Hardware Firewall with improved throughput to speed things up some more and keep everything safe from malicious attack as well as upgrading our network to 1Gbps and providing two 1Gbps network connections from each server. Moving your site shouldn't be to much of an issue we can setup the forum for you and help move the database, you would just need to upload your websites files. ------------- 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: biggieb
Date Posted: 17 May 2007 at 5:01pm
hmmmm.. Just on a whime I changed the setting from TRUE to FALSE and now the site is working perfectly! It's been set to TRUE for a very long time without problems. I wonder if there is some issue with the new version of SQL Server that’s now in use? No doubt that when they upgraded the server the captcha thingy stopped working. At least my site is up and running now and new users can join and I can admin the site.
Any thoughts of this recent discovery?
|
Posted By: WebWiz-Bruce
Date Posted: 17 May 2007 at 5:09pm
|
We have machines ourselves with both the 32bit and 64bit versions of SQL Server on them, the only difference is memory management allowing the 64 bit version to access much more memory and more efficiently, but this has no effect on the databases, which don't care if they are on a 32bit or 64bit version. The only difference is you host can now cram more databases on the 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 |