| Author |
 Topic  |
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
 Posted - 17 September 2003 : 09:56:03
|
hrm... still getting errors when creating new groups... went to show off how cool this MOD is to a friend... and got an error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/forum/admin_usergroups.asp, line 84
still is created... just get an error. |
Reinsnitz (Mike) |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 17 September 2003 : 10:01:46
|
| Mike, can you post a text version of that page? (Only reason is I believe you've made some changes that I won't have in the original MOD files.) |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 17 September 2003 : 10:02:42
|
| actually, you know what I think it is. It's the identity thing I think. I was going to rework that part of the code so that it doesn't use it. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 17 September 2003 : 13:40:16
|
I think it's the MySQL that is hosing it ;) No biggy here... we're up and running and its not anoying for me ;)
But I would be more than happy to test it for you to see if it does not give the error :) |
Reinsnitz (Mike) |
|
|
|
altisdesign
Junior Member
United Kingdom
357 Posts |
Posted - 17 September 2003 : 13:52:22
|
Mike,
I had that problem with a forum I was writing, I rewrote the code that did not work on the MySQL db so it inserted the information in a different way, it seems to work for me and a couple of other users have tried it. You might want to wait for Nikkol to rewrite it tho  , but if not, this link may help: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=46077
-Altis Design |
Altis Design offers all manner of web design services to a variety of commercial and personal clients |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 18 September 2003 : 09:12:56
|
| awesome :) Will take a look, but it is working... just gives an error that doesn't affect functionality much :) and it's only for hte admin not end users... I'll go ahead and wait and help Nikkol to troubleshoot her base code for now though :) |
Reinsnitz (Mike) |
|
|
|
wizard
Junior Member
208 Posts |
Posted - 21 September 2003 : 19:19:42
|
I got this:
ADODB.Recordset error '800a0e79'
Operation is not allowed when the object is open.
/admin_usergroups.asp, line 118
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 21 September 2003 : 22:47:32
|
what were you trying to do when that happened?
have you modified the code on that page?
(as a side note, you should have posted this in the MOD implementation forum) |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 September 2003 : 12:29:09
|
Hey Nikkol, it's my time to try at your mod and post my findings.
Installing the mod for a client. He had EMail Validation turned on. After a user clicks the link in thier email, they get this error:error '80020009'
Exception occurred
/portal/forum/inc_func_common.asp, line 685 Which was:function chkString(pString,fField_Type)
fString = trim(pString) So I figured whatever pString was, the trim function didn't like it. I narrowed it down to your code that was sending fautly data to the chkString function. Line 215 in register.asp.'## Forum_SQL - Delete the Member
strSql = "DELETE FROM " & strMemberTablePrefix & "MEMBERS_PENDING "
strSql = strSql & " WHERE M_KEY = '" & key & "'"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Call UserGroupAutoJoin(chkString(rsKey("M_NAME"),"SQLString")) '####### UserGroup MOD #######Just looking at the code I realized you were still requesting the M_NAME variable from the rsKey connection. But since then, the register page has updated the database twice. So any data in the rsKey connection is erased after those updates.
So rsKey("M_NAME") is invalid and contains no data.
What I did was store the data in a variable (can call it strMemberName) before the database is updated, then use that variable for your code.else
strMemberName = chkString(rsKey("M_NAME"),"SQLString")
'## Forum_SQL
strSql = "INSERT INTO " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & "(M_NAME"And your code woukd look like:Call UserGroupAutoJoin(strMemberName) I hope you understand. If not, I'm not explaining it again.  |
Support Snitz Forums
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 23 September 2003 : 17:14:11
|
I'm a bit lost Davio, We use this Mod also and the call is done before the delete. So i still asume it's not a bug.
Call UserGroupAutoJoin(chkString(rsKey("M_NAME"),"SQLString")) '####### UserGroup MOD #######
'## Forum_SQL - Delete the Member
strSql = "DELETE FROM " & strMemberTablePrefix & "MEMBERS_PENDING "
strSql = strSql & " WHERE M_KEY = '" & key & "'"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 September 2003 : 21:02:36
|
| I don't know. Occording to the readme and the register.asp file that came with the zip file for this mod, it is after the delete query. Unless Nikkol updated the mod since then. |
Support Snitz Forums
|
|
|
|
Topic |
|
Topic Locked
