Error adding new records
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=28424
Printed Date: 01 April 2026 at 11:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error adding new records
Posted By: proware
Subject: Error adding new records
Date Posted: 15 March 2010 at 5:15am
|
I get the following error when add ing new records to Webwiz. 9.66 I checked the access table and noticed that thread_id is not set to auto increment ( i thought it was like this in an older version). Is this my problem? If not, any ideas what is going on? I changed it to be not required and it saves with a Null (which is obviously not right). Any ideas what I should do? Cheers David 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_post_data File Name:- new_post.asp Error details:- Microsoft JET Database Engine The field 'tblThread.Thread_ID' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.  Edition: Free Express Edition Running Version: 9.66 Database Backend: Access |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 15 March 2010 at 8:54am
|
The field tblThread.Thread_ID should be an auto increment field in access and also a primary key. If this is a new installation download the forum again and use a new copy of the database, as you r database is corrupted. If this is an existing Web Wiz Forums Access database then chnage the field to an auto increment field and set it as the primary key. You should then also compact and repair the database to fix whatever corruption in the database has caused this 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: proware
Date Posted: 15 March 2010 at 10:22pm
|
This is not a new installation. It was upgraded from an older version of Web Wiz to version 9. Access will not let me convert an existing column to AutoIncrement if it already has data. So I am a bit stuck. Any other ideas? Cheers David |
Posted By: WebWiz-Bruce
Date Posted: 16 March 2010 at 1:44pm
|
Your only option would be to go back to a previous database backup before the database became corrupted. This is one of the pitfalls of using Access it does easily become corrupted, which is why it is recommended to use SQL Server or even mySQL instead. ------------- 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: Putz22
Date Posted: 16 March 2010 at 6:37pm
| Bruce is right.. Hopefully you kept a backup of your DataBase... If not then you might have to reinstall the WWF again.. with a clean install.. not unless you want to go through line by line to fix the code in your Database. |