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: Configurable User Fields
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

stwilson
Junior Member

USA
385 Posts

Posted - 03 May 2001 :  16:21:51  Show Profile  Visit stwilson's Homepage
I installed the 3.1 SR4 version. I recently installed the configurable user fields MOD and am receiving this error after I enable the fields and then try to add a user field:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'my_Conn.execute'

/forum/pop_admin_table.asp, line 16

Any thoughts? Can someone point me in the right direction?

Shannon



@tomic
Senior Member

USA
1790 Posts

Posted - 31 May 2001 :  21:22:04  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
I can't believe no one responded to this or posted it themselves since I found a major typo that should have plagued everyone installing this unless you were the first to try, which I doubt ; )

Change this line(16) in pop_admin_table.asp:
my_Conn.Execute= "INSERT INTO " & strTablePrefix & "USERFIELDS (USR_LABEL,USR_FIELDTYPE,USR_SHORTNAME) Values ('NewLabel','S','User_" & usrNum & "')"

to

my_Conn.Execute("INSERT INTO " & strTablePrefix & "USERFIELDS (USR_LABEL,USR_FIELDTYPE,USR_SHORTNAME) Values ('NewLabel','S','User_" & usrNum & "')")

or just remove the =

@tomic

Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 31 May 2001 :  22:11:29  Show Profile
quote:

I can't believe no one responded to this ...



Ehm, sorry. I didn't any time to install this before .

Think Pink
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 31 May 2001 :  22:23:51  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
Something's still up with this thing. I just crashed the server twice once i got past that error and wanted to try filling out a custom field. Doh!

@tomic

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 June 2001 :  18:31:09  Show Profile  Visit HuwR's Homepage
Sorry I had not seen this previosly.

Are you getting errors ?
There is no reason why it should crash the server.


What database connection string are you using

Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts

Posted - 15 June 2001 :  21:37:18  Show Profile
I just installed the Config User Fields MOD on a fresh Snitz v3.2alpha6 in about 5 minutes and not a problem.

HuwR, is this a different version from the one I have?, because I have no pop_admin_table.asp file

Intrepidone
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 15 June 2001 :  21:39:24  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
I had an error similar to this while setting up the database. This example is copied from another post, because I didn't save the original error.

Updating Forum Values..
DELETE FROM FORUM_MODS WHERE (M_NAME = 'HModEnable' AND M_CODE = 'UserFields')
13 | Type mismatch

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','UserFields','1')

Value(s) updated succesfully
--------------------------------------------------------------------------------

What is interesting is that even after I disabled this MOD in the MOD Commander, it still crashed the server. I had to revert to a prior version of the database.

@tomic

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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07