| Author |
 Topic Search  Topic Options
|
diveboard 
Newbie
Joined: 10 October 2007
Status: Offline
Points: 33
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error when guest tries to post
Posted: 25 June 2008 at 9:14pm |
I opened up a "guest Book" type thread where people can post even if they aren't logged in. When I try to use this section and click to post I get the following error. Can anybody help with this???
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 8:13am |
|
This error happens when the Access database become corrupted. Download the Access database, open in MS Access, and select the 'Compact and Repair Database' Tool, then reupload the database to the server.
Corrupted Access databases are quite common as Access is designed for the desktop not the web. If you can use the SQL Server or mySQL database version instead.
|
|
|
|
diveboard
Newbie
Joined: 10 October 2007
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 1:46pm |
Ok, I just tried that and it still does the same thing. I now also get this error frequently when trying to administer the forum
| Error |
| Only members with sufficient permission can access this page. |
I then deleted the database and uploaded a completely new fresh database and I still get the above error.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 1:49pm |
|
The Access database version is not supported in the production environment as Access isn't up to the job as it is a desktop database. The Access version is for testing purposes only.
If you are wanting to use Web Wiz Forums in a production environment you should use the SQL Server or the mySQL version.
|
|
|
|
diveboard
Newbie
Joined: 10 October 2007
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 1:54pm |
|
I may try the sql version.
|
|
diveboard
Newbie
Joined: 10 October 2007
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 4:21pm |
Ok, I installed the SQL version and the issue with guests posting to the guest book has been resolved, However, now I cant get the licenses to install. I get the following error.
| Error |
The Premium Edition License Key has not been applied
Error Connecting to License Server.
Server Response: 12029 - Unknown
If Web Wiz Forums is running on a server behind a Firewall check that TCP Port 80 is open. |
|
|
diveboard
Newbie
Joined: 10 October 2007
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 4:22pm |
|
Just FYI, I did not get this error when activating the the Access version
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 June 2008 at 5:20pm |
|
The Access version and the SQL Server version work in exactly the same way for this part.
The error means that your site is unable to connect to the license activation server. Check that your site is not behind a firewall with outbound port 80 closed and that you are not going through a proxy for outbound traffic.
|
|
|
|
