I am using the forum for testing some automation application. I have populated a single forum with 689998 topics. All topics containing single sentence.
When I tried to delete the forum I get the timeout error bellow.
Is there any work around to delete the forum? i am using Snitz version 3.4.06
All Topics in selected Forum/s have been Deleted.
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/Snitz/admin_forums.asp, line 642
not easily no. If you have direct access to the sql server you could try using sql to delete them, it is unlikely that an asp script will be able to delete that many topics without timing out.
I have installed only the default Snitz application as in the download. What tables to delete if I added only one forum and many topics without reply to none of the topics?
I have installed only the default Snitz application as in the download. What tables to delete if I added only one forum and many topics without reply to none of the topics?
Delete FORUM_TOPICS and then run setup.asp again. Use the link on the bottom "Create the database tables.", and then re-enter your credentials (if needed). You will get several errors stating that values already exist, but it should re-install FORUM_TOPICS. Then you can have a clean install again.
Topic Locked
Posted - 28 December 2009 : 04:11:13
