| Author |
 Topic  |
|
Alex123
Junior Member
Greece
237 Posts |
 Posted - 09 September 2002 : 13:52:18
|
Hi everybody,
Couple of days ago I upgraded to Active Users 4 from Active Users 3.5.
Then I realized that my "buddy mod" was looking for the "FORUM_ONLINE" table, which was replaced by the "FORUM_ACTIVE_USERS" table, so I used the dbs_activeusers from Active Users 3.5 and recreated the "FORUM_ONLINE" table, hoping that this would fix the problem, but now I get the following error:
Error '80020009'
Exception occurred.
/forum/buddy.asp, line 160
Please help me, I am at a loss, don't know what else to do.
Thank you very much
Regards
Alex
|
Edited by - Alex123 on 09 September 2002 14:14:50 |
|
|
zoomdubai
Starting Member
25 Posts |
Posted - 09 September 2002 : 18:41:19
|
Hi, this bookmark & buddy mod are working fine without Active Users option turned on, but when i turn on the active users option they give lot's of errors, seems it was written to be compatible with AU 3.5, but i've got AU 4 installed.
Can somebody update the MOD to be compatible with AU 4 and SNitz 3.4.. ?
will be waiting for a reply.. cheers! |
 |
|
|
alex042
Average Member
USA
631 Posts |
Posted - 09 September 2002 : 22:54:45
|
quote:
Hi, this bookmark & buddy mod are working fine without Active Users option turned on, but when i turn on the active users option they give lot's of errors, seems it was written to be compatible with AU 3.5, but i've got AU 4 installed.
A you referring to the 3.3 version or the one I just updated? What errors are you getting?
|
Edited by - alex042 on 09 September 2002 22:55:32 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 09 September 2002 : 23:25:11
|
i guess Alex123 still use a old version Buddy Mod..
alex042 already upgrade this mod to 3.4
(also update the table refer from ONLINE to ACTIVE_USERS)
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34468
so if you upgrade Buddy Mode with alex042's new version, i think it should be can solve this problem.. |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 00:33:36
|
quote:
(also update the table refer from ONLINE to ACTIVE_USERS)
There was more than this to update. In fact, I just corrected a few more things and updated the download.
|
|
|
|
zoomdubai
Starting Member
25 Posts |
Posted - 10 September 2002 : 03:42:30
|
Hi alex042,
Actually i fixed that too somehow, anyways downloaded yours which seems to be working fine, but it works perfect on my local computer since i'm the only one online.
But when I upload to my site where there are more than one users online it still shows Online for only 1 person i.e me or anyone else, even there are more than one users online adn adde to my buddy list.
You can check out http://www.janubaba.com/forums
add to your buddy list and u'll find out :( add ppl who are currently online also!
Cheers, |
|
|
|
zoomdubai
Starting Member
25 Posts |
Posted - 10 September 2002 : 04:13:27
|
hi, again here.. just figured out the problem..
hope everybody will get it fixed, download the file bookmarks_refreshed_v111.zip mentioned in this post earlier.
around line 140 ; find this code
strSqlOnline = strSqlOnline & " FROM (" & strMemberTablePrefix & "ACTIVE_USERS INNER JOIN " & strMemberTablePrefix & "MEMBERS ON " & strMemberTablePrefix & "ACTIVE_USERS.MEMBER_ID =" & strMemberTablePrefix & "MEMBERS.MEMBER_ID) INNER JOIN " & strMemberTablePrefix & "BOOKMARKS ON " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strMemberTablePrefix & "BOOKMARKS.BKMRK_ERID"
and replace it with
strSqlOnline = strSqlOnline & " FROM (" & strMemberTablePrefix & "ACTIVE_USERS INNER JOIN " & strMemberTablePrefix & "MEMBERS ON " & strMemberTablePrefix & "ACTIVE_USERS.MEMBER_ID =" & strMemberTablePrefix & "MEMBERS.MEMBER_ID) INNER JOIN " & strMemberTablePrefix & "BOOKMARKS ON " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strMemberTablePrefix & "BOOKMARKS.BKMRK_EEID"
same for pop_buddy.asp then u won't get only 1 online always!
Cheers, i modified a code a bit since AU_LASTPAGE shows only topic.asp or the name of the page so i just wrote there Online - Send PM.. and link! Simple :)
Works greak now!
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 10 September 2002 : 04:40:07
|
thanks for alex042's update & zoomdubai's modification..
i did'nt try it on 3.4 yet...
just think of if the ACTIVE_USERS table work the same as old ONLINE table.. we just can do this.
and i think it's a old problem on Buddy MOD. on my 3.3.x forum, you also need some change to take care the M_AUHIDE value. so if member hide the active user option, he'll not show at buddy list too. |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 05:27:13
|
I guess I forgot to mention that I am using forum version 3.3.05.
So the updated buddy mod doesn't work for me.
So could Please someone help me, if there is a solution, I guess one thing would be to go back to Active Users 3.5, but that mod had so many bugs and this one works so fine that I wish I could keep it, but so far I can't find a way to fix the buddy mod.
I check my .mdb and both of the table ( FORUM_ACTIVE_USERS and FORUM_ONLINE)are there, since I recreated the FORUM_ONLINE table using the dbs_activeusers from Active Users 3.5, but I keep getting the error|:Error '80020009'
Exception occurred.
/forum/buddy.asp, line 160
On line 160 there is:
strSql2 = strSql2 & " FROM " & strMemberTablePrefix & "MEMBERS WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID =" & rsMember("MEMBER_ID")
This propably needs to be changed to soemthing else, but what ?
Thank you for any help
Alex
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 10 September 2002 : 05:36:02
|
find the line that says something like this:
set rsXXXXX = my_Conn.Execute(strSql2)
(should be a few lines below line 160)
and add this line above that:
Response.Write strSql2
(note: the red parts must match)
please post the query that shows up on the screen |
cHosting.nl |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 06:28:51
|
Thank you Crash for your reply,
I did what you said by adding that line but I keep getting the same error, below is the way it looks after I added the new line.
strSql2 = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_STATUS, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strMemberTablePrefix & "MEMBERS.M_LEVEL, " & strMemberTablePrefix & "MEMBERS.M_EMAIL, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, " & strMemberTablePrefix & "MEMBERS.M_HOMEPAGE, " & strMemberTablePrefix & "MEMBERS.M_ICQ, " & strMemberTablePrefix & "MEMBERS.M_YAHOO, " & strMemberTablePrefix & "MEMBERS.M_AIM, " & strMemberTablePrefix & "MEMBERS.M_TITLE, " & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE, " & strMemberTablePrefix & "MEMBERS.M_LASTHEREDATE, " & strMemberTablePrefix & "MEMBERS.M_DATE "
strSql2 = strSql2 & " FROM " & strMemberTablePrefix & "MEMBERS WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID =" & rsMember("MEMBER_ID")
Response.Write strSql2
set rs2 = my_Conn.Execute (strSql2)
Thank you again
Alex
|
Edited by - Alex123 on 10 September 2002 06:34:17 |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 10 September 2002 : 07:14:38
|
| and then visit the page again that gives you the error. what is the query that shows up on the screen? |
cHosting.nl |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 07:35:22
|
HI crash,
I get the same error that I did before :
Error '80020009'
Exception occurred.
/forum/buddy.asp, line 160
Thanks
Alex
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 10 September 2002 : 07:57:41
|
| doesn't it show a query on your screen? |
cHosting.nl |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 08:28:28
|
quote:
/forum/buddy.asp, line 160
Right above that, try changing:
strSql3 = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "ONLINE.UserID "
strSql3 = strSql3 & " FROM " & strTablePrefix & "MEMBERS, " & strTablePrefix & "ONLINE "
strSql3 = strSql3 & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & rs("M_NAME") & "' "
set rsMember = my_Conn.Execute (strSql3)
to this:
strSql3 = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME "
strSql3 = strSql3 & " FROM " & strTablePrefix & "MEMBERS, " & strTablePrefix & "ACTIVE_USERS "
strSql3 = strSql3 & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & rs("M_NAME") & "' "
set rsMember = my_Conn.Execute (strSql3)
|
Edited by - alex042 on 10 September 2002 08:32:28 |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 08:47:17
|
Thank you Alex 
The error is gone and I can see my boddies again.
I can add and delete. The only thing that doesn't work is the online status, it show them all "offline".
Can you help me with that too, PLEASE.
Thank you very much
Alex
P.S Does this needs to be changed ??
'### 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
'###
Thanks
|
Edited by - Alex123 on 10 September 2002 08:57:50 |
|
|
|
Topic |
|
Topic Locked
