Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Archive search causing database lockup.
 New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nick Feakes
New Member

98 Posts

Posted - 21 February 2015 :  18:15:00  Show Profile  Reply with Quote
Following a server crash, searching archived posts causes the database to loop endlessly until the module times out, this takes several minutes (Current posts works OK).
The number in FORUM_A_TOPICS table, field T_REPLIES is not the same as the actual number of replies in FORUM_A_REPLIES.
My questions are:-
1. Should they be the same (it would seem logical to me that they were)?
2. What is the purpose of the table FORUM_A_REPLY_RENAMED?
Nick

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 24 February 2015 :  10:47:30  Show Profile  Send ruirib a Yahoo! Message
A counts update should fix any issue with post and reply counts, even if you may have issues completing it on Access.
The table you mention does not exist. Seems like a copy someone did.

The timeout issue my result of database issues resulting from the server crash. I would recommend a repair, but be sure to keep a backup of the database.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07