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
 Problem setting up Private Message Mod with mySQL
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Zude
Starting Member

USA
9 Posts

Posted - 14 April 2001 :  01:27:50  Show Profile  Visit Zude's Homepage  Send Zude an ICQ Message
Greetings,

I've been trying to get the PM mod set up on my forum. I'm using mySQL 3.23.33 and have had to tweak a few of the other mods, but this one has me stumped.

I tried the mod_dbsetup.asp to create the PM table, but it failed miserably (didn't like the semicolons or something). So I cleaned that up and did the CREATE TABLE statement manually. This choked on the PM_MAILBOX column which was supposed to be a "byte" type. Doh! mySQL doesn't like that, so I used CHAR(1). Keeping my fingers crossed, I moved on.

OK, at that point, I was able to get private_mess.asp to display just before the statistics section like the readme file described.

I am able to use all of the PM functions except the members list. When I use the members list icon, or the pop-up members list while creating a new message, I get an error like this:

quote:

Error Type:
ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation.
/forum/pm_members.asp, line 207



The line referenced is:
rs.absolutePage = myPage

The error in pop_pm_members.asp is the same.

Now I think I understand what rs.absolutepage does, in that it moves the pointer to the first page in the recordset. What I don't understand is why this isn't working. Is it mySQL? What would be the best workaround?

I am also having the exact same problem with the Active Users mod, so any help here will also solve that problem for me.

Thanks,
Zude


  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