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: MOD Implementation
 Buddy List Mod Help		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

hahnsolo1
Starting Member

18 Posts
Posted - 01 June 2002 :  10:28:00  Show Profile

I installed the buddy list mod from the Snitz Exchange mod site.

I get an error on the buddy,asp

There was no documentation to edit that page.

Any Ideas?

The Error on the buddy.asp is

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_ONLINE'.

/buddy.asp, line 96


and Line 96 is

'### Returns Buddies Who Are Online
strSqlOnline = "SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME," & strMemberTablePrefix & "ONLINE.M_BROWSE"
strSqlOnline = strSqlOnline & " FROM (" & strMemberTablePrefix & "ONLINE INNER JOIN " & strMemberTablePrefix & "MEMBERS ON " & strMemberTablePrefix & "ONLINE.UserID =" & strMemberTablePrefix & "MEMBERS.M_NAME) INNER JOIN " & strMemberTablePrefix & "BUDDYS ON " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strMemberTablePrefix & "BUDDYS.BUDMEMBERID"
rsOnline.open strSqlonline, my_Conn
'###



Running SQL 2000


Ty for any help

crash
Advanced Member

Netherlands
2064 Posts
Posted - 01 June 2002 :  18:48:37  Show Profile  Visit crash's Homepage
you don't seem to have that table (FORUM_ONLINE)



Crash's Site | Crash is from
Go to Top of Page

hahnsolo1
Starting Member

18 Posts
Posted - 01 June 2002 :  20:22:06  Show Profile
Did the Active Users 4 mod delete that table?
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts
Posted - 02 June 2002 :  04:17:14  Show Profile  Visit crash's Homepage
yes



Crash's Site | Crash is from
Go to Top of Page

alex042
Average Member

USA
631 Posts
Posted - 03 June 2002 :  08:56:17  Show Profile  Send alex042 an AOL message  Send alex042 a Yahoo! Message
quote:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_ONLINE'.


I believe this is a table for an older version of active users. Active users 4.0 uses FORUM_ACTIVE_USERS. You'll need to change a bit of code to reflect the new table if you've installed Active Users 4.0. If you don't have Active Users installed, you could just install Active Users 3.5 which I believe places the required table in your database.
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.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07