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 SQL Server
 Help: Forum Stopped Working
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

hahnsolo1
Starting Member

18 Posts

Posted - 21 July 2002 :  09:23:55  Show Profile

One of the forums on our forums stopped working

We did not install anything in over a month.

Here is the error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Process ID 66 attempting to unlock unowned resource PAG: 8:1:551.

/forum.asp, line 264


u can check it out at www.clanboard.com



How can i fix this?

Thanks

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 21 July 2002 :  09:37:15  Show Profile
Have you tried using a OLEDB driver in your strConnString in config.asp instead of the ODBC driver? I don't know the exact string, but if you do a search on this forum, you'll probably find it.

EDIT - what is the connection string you are using? You can leave out the password and username if you like.

Nikkol

Edited by - Nikkol on 21 July 2002 09:47:39
Go to Top of Page

hahnsolo1
Starting Member

18 Posts

Posted - 21 July 2002 :  11:02:12  Show Profile
its the same string since i had the forum

the other forums work
that 1 sub forum wont work

could it be a corrupted thread

I havent change the string since i been running the forum for a year now


Edited by - hahnsolo1 on 21 July 2002 11:02:48
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 21 July 2002 :  11:17:31  Show Profile
That's fine. But it helps troubleshooting if you let us know what string you are using. Please post it. It could be that your host has made some updates to the web server that may be causing the problem.

Nikkol
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 July 2002 :  13:35:08  Show Profile  Send ruirib a Yahoo! Message
You need to add come changes to your database. These topics describe several things done by a user who had the same problen. Read them and apply the fixes there:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=29858

http://forum.snitz.com/forum/topic.asp?whichpage=2&TOPIC_ID=29902

Basically the fix is to add a clustered index to the T_LAST_POST column in the FORUM_TOPICS table and to the R_DATE column in the FORUM_REPLY table. Installing SQL Server 2000 Service Pack 2 eventually solved the situation for the user with the previous situation, so I'd suggest you do the same. If your not running SQL Server 2000 make sure you have all the service packs installed also.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07