Web Wiz Forums - Error creating new thread

Print Page | Close Window

Error creating new thread

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

Topic: Error creating new thread

Posted By: leiti
Subject: Error creating new thread
Date Posted: 21 December 2006 at 9:22am

What's to do when this error come?

There's a problem with indexes and primary keys.

Server Error in Forum Application
An error has occured 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
Die von Ihnen vorgenommenen �nderungen an der Tabelle konnten nicht vorgenommen werden, da der Index, Prim�rschl�ssel oder die Beziehung mehrfach vorkommende Werte enthalten w�rde. �ndern Sie die Daten in den Feldern, die gleiche Daten enthalten, entfernen Sie den Index, oder definieren Sie den Index neu, damit doppelte Eintr�ge m�glich sind, und versuchen Sie es erneut.

Replies:

Posted By: leiti
Date Posted: 21 December 2006 at 12:54pm

Doesn't know anybody what's the matter?

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 1:04pm

The error message is in not in English so it's not possible to tell what the issue is. If you translate the error message could probably help you.

-------------
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: leiti
Date Posted: 21 December 2006 at 1:46pm

The translation by bablefish brought the following:

The changes at the table, made by you, could not be made, there the index, primary key or the relationship several times occurring values were contained. If you change the data in the fields, which contain same data, remove the index, or you redefine the index, thus double entries are possible, and you try it again.

The error occours, when creating a new thread.

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 1:53pm

What version are you using and is this a new install?

-------------
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: leiti
Date Posted: 21 December 2006 at 2:00pm

Forum is running a while without troubles. Since yesterday I got the troubles. Perhaps something in the database is wrong?

I thin it is version 8.02.

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 2:38pm

Thanks leiti, I now know what the issue is from the info you have given.

The problem is that your access database has become corrupted. What you will need to do is download the Access database, open it in MS Access and from the Tools menu select, 'compact and repair database'. Once this is done reupload your database to the server.

While you are at it you should look at upgrading the rest of the files to the latest version 8.05

-------------
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: leiti
Date Posted: 21 December 2006 at 5:38pm

I am sorry. This didn't solve the problem. The database seems to be corrupt.

I thought about updating and would do, as far as the database is stable again ;-)

Any ideas, how to solve this problem exept installing a new one?

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 6:04pm

This is the problem with Access which is why it carries a warning on the download page, because it's a desktop database it's not very good with web sites.

You may need to start again if you can't fix the database, this time use a proper database like the mySQL or SQL Server version as this would not happen with them.

-------------
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: leiti
Date Posted: 21 December 2006 at 6:17pm

Problem only occours when creating a new thread. An answer in an thread is working fine!

mySQL or SQL Server would be used, if provider supports it ...

would it help to delete all indexes?

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 6:48pm

Did you actually download the database and run a compact and repair on it?

-------------
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: leiti
Date Posted: 21 December 2006 at 7:03pm

Yes - but it didn't help!

edit: is there a chance to download a empty database and insert the old records?

Posted By: WebWiz-Bruce
Date Posted: 21 December 2006 at 7:17pm

There isn't sorry.

This is the problem with running Access if the database becomes corrupted and you can't recover it you lose the lot.

You may be able to copy across the members table through, but if you are going to keep running Access there will always be the danger of it happening again.

-------------
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: leiti
Date Posted: 21 December 2006 at 8:07pm

i can't belive this ;-)

there must be a solution.

What does the error mean? How can this error occours?

Is it because of indexes? is it by database design?

Posted By: leiti
Date Posted: 22 December 2006 at 7:21am

Problem was found!

There was a topic in the database with start ID "0" and end ID "0". I deleted the entry and now everything is working.

edit: thanks for helping and investing your time!