Our WebWiz forums became severely neglected while our car club board was undergoing some changes and became overrun with spam messages. I took on the job of cleaning them up and deleted a bunch of spammers accounts rather than deleting the messages first, not realizing that in many cases you can delete the messages in bulk with the spam cleaner tool.
This left pages and pages of spam messages authored by "guests". I asked my computer minded son, who was helping us build the new website and move the forums over to it, if he could come up with some sort of batch command to delete all messages by "guests" in a specified date range. He did, and that cleared out hundreds of spam messages.
However, when I tried to post a new topic, this error message showed (and still shows) up:
Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the Forum Administrator.
Support Error Code:- err_SQLServer_save_new_topic_data
File Name:- new_post.asp
Forum Version:- 10.17
At first I thought it was because phantom spam messages were still shown in the "Last Post" column. I tried responding to the last actual post in the various forums and found that I was able to respond to a post (without getting an error) and knock the phantom spam post out of the "Last Post". I did this for the entire forum but still get the above message when trying to create a new post.
I know that there is a new version that we should probably move to:
Lastest Version: 12.06
Release Date: 19th April 2023
Release Notes: Improved the search tool, updated the Rich Text Editor, removed deprecated elements
But I am assuming that we need a fully functioning forum to update the software. I may have more questions about that but I would like to get our forums running again with this software in an effort to prevent data loss when upgrading.
Thank you in advance-
Val
Topic Options
Post Options
Thanks(0)
