Print Page | Close Window

Problem with ver 9.51

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=26575
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Problem with ver 9.51
Posted By: wasiq
Subject: Problem with ver 9.51
Date Posted: 24 November 2008 at 8:24am
Hello!

I am using webwiz 9.51. While I or any of my user creating a new topic an error occurs.

Quote
Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_Access_save_new_topic_data
File Name:- new_post.asp

Error details:-
Microsoft JET Database Engine
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.



Now what do I have to do to resolve this problem.

Thanks in advance.


-------------
http://www.superdiscountshop.com/" rel="nofollow - Discount Coupons - http://www.articles-heaven.caom/" rel="nofollow - Submit Articles



Replies:
Posted By: WebWiz-Bruce
Date Posted: 24 November 2008 at 12:09pm
You have a corrupted Access database. Download the database open it in Microsoft Access and use the 'Compact and Repair' tool. Then reupload it to the server again.

To prevent these issues you should look at upsizing to SQL Server as Access is a desktop database and is not intended for web server production work.


-------------
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: wasiq
Date Posted: 26 November 2008 at 11:30am
I have done it. But still the same error occurs.

-------------
http://www.superdiscountshop.com/" rel="nofollow - Discount Coupons - http://www.articles-heaven.caom/" rel="nofollow - Submit Articles


Posted By: wasiq
Date Posted: 26 November 2008 at 2:40pm
Please help me ASAP.


Posted By: WebWiz-Bruce
Date Posted: 26 November 2008 at 3:24pm
This is the problem with using an Access database which is why we only make it available for testing purposes only and not for production forums as Access databases often become corrupted.

It may mean you will need to start again, however to prevent these types of errors from occurring you should use the mySQL or SQL Server versions.


-------------
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: rblanda
Date Posted: 06 April 2009 at 2:47pm
I am having the exact same problem and i took your suggestion and getting the same thing.
 
Funny thing is, when i hit back and try again, it works. Then it will continue to work from that point forward.
 
Has anyone resolved this yet?


Posted By: 123Simples
Date Posted: 06 April 2009 at 5:21pm
Common database errors http://www.webwiz.net/kb/asp_knowledgebase/access_database_errors.asp" rel="nofollow - are discussed here - having looked around I would suggest that if people are expecting to have busy forums, that they use SQL or MySQL as their database backend, otherwise they may find that if their forum becomes very busy, they may suffer from different issues, none of which will be related to the software, but more because as Bruce says Access is used for more testing environments

Web Wiz does this make this point clear:

Access Version
This is the slowest version of Web Wiz Forums. Access is a desktop database and is often unable to cope in a production environment leading to database corruption issues. This version should only be used for testing purposes - http://www.webwiz.net/webwizforums/webwizforums_downloads.asp" rel="nofollow - Read Me


-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net