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
 Error '800a0bcd'
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

louie
Starting Member

Ireland
48 Posts

Posted - 15 August 2002 :  17:39:53  Show Profile  Visit louie's Homepage
I have this forum for some time, but today when I checked it out it gave this error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/forum/default.asp, line 77
Users = rs1("U_COUNT")

then this one:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/forum/topic.asp, line 271
rsReplies.cachesize = strPageSize


ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 15 August 2002 :  19:01:31  Show Profile  Send ruirib a Yahoo! Message
Made any changes to the forum or database? It sure is weird that it should happen outta nowhere...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 16 August 2002 :  02:24:38  Show Profile  Visit louie's Homepage
No changes. Never touch it.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 August 2002 :  07:35:21  Show Profile  Send ruirib a Yahoo! Message
Can you have a look at the FORUM_TOTALS table and check if you have records there?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 17 August 2002 :  17:36:25  Show Profile  Visit louie's Homepage
There is nothing in the FORUM_TOTALS.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 August 2002 :  18:56:27  Show Profile  Send ruirib a Yahoo! Message
Then go to Admin Options and choose Update Forum Counts. Then try again.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 19 August 2002 :  01:56:36  Show Profile  Visit louie's Homepage
I did try again but I get the same error.
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/forum/forum.asp, line 245

I am after uploading the forum fresh again, everything worked fine until today when i got this error again. What exactly happens there?

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 August 2002 :  08:24:39  Show Profile  Send ruirib a Yahoo! Message
Sorry, what version are you using now? 3.4?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 19 August 2002 :  13:22:46  Show Profile  Visit louie's Homepage
Version 3.4
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 August 2002 :  13:26:53  Show Profile  Send ruirib a Yahoo! Message
Are you sure? This is my line 245, forum.asp:


strSql3 = strSql3 & " AND T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID "


That error cannot happen with this line. Did you upgrade your forum between yesterday and today? If you didn't, then you're still using 3.3.05. Can you confirm this, please?


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 19 August 2002 13:27:54
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 19 August 2002 :  15:36:02  Show Profile  Visit louie's Homepage
Sorry, you are right there. I am using 3.3.05.

Sorry again.
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 19 August 2002 :  16:21:57  Show Profile  Visit louie's Homepage
I upgreded today to 3.4 and this is the error I get.

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/forum/forum.asp, line 326

this is the same line as before.

rs.cachesize = strPageSize
Go to Top of Page

louie
Starting Member

Ireland
48 Posts

Posted - 19 August 2002 :  16:52:59  Show Profile  Visit louie's Homepage
Sorry again.

It looks like everything works fine at th moment with the new 3.4 version.

By the way *great job.*

Keep up the good work.

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 August 2002 :  18:43:00  Show Profile  Send ruirib a Yahoo! Message
Glad to know that .


Snitz 3.4 Readme | Like the support? Support Snitz too
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07