| Author |
 Topic  |
|
|
Rob.B
New Member
Netherlands
93 Posts |
 Posted - 19 September 2002 : 07:07:36
|
Okay, i know it's an old version of snitz but yesterday i installed snitz 3.3.05. so far so good but today i want to install the usergroup mod.
I got this error:
-----------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/3.3/admin_usergroups.asp, line 107
-----------------------------
Does anybody know what i have to change in my mysql DB??? |
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 19 September 2002 : 07:18:15
|
Well i'd like to user 3.3 because there are a lot of mods available for this version.
3.4.03 is new and there are not so many mods for the new version. Maybe later  |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 19 September 2002 : 07:21:59
|
| I started the UserGroups mod and then Morpheus took it over. When I was working on it at least, I was writing it for Access. Don't know about mySQL, sorry. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 19 September 2002 : 07:49:47
|
| Hmmm, let's wait for Morpheus (or somebody else ) |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 September 2002 : 14:47:20
|
That doesn't look like a mysql server error. But an error with the ODBC driver. I have seen this error when working with memo/blob fields. They need to be the last fields in the SELECT statements or when inserting into the database.
I am guessing line 107 is an execute statement? Want to show us the SQL query that it is executing? |
Support Snitz Forums
|
Edited by - Davio on 19 September 2002 14:49:37 |
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 19 September 2002 : 18:09:17
|
Ofcourse:
Case "Add", "Modify" '## add or modify group
strAddOrModify = "Add Group"
strConfirm = Request.Form("submit")
If strConfirm = "Add Group" Then
'## check for usergroup name uniqueness
set rsGroup = Server.CreateObject("ADODB.Recordset")
rsGroup.open strMemberTablePrefix & "USERGROUPS", my_Conn, 1, 3, 2
rsGroup.AddNew
rsGroup("USERGROUP_NAME") = Request.Form("GroupName")
rsGroup("USERGROUP_DESC") = Request.Form("GroupDesc")
rsGroup.Update
line 107 ----> GroupID = rsGroup("USERGROUP_ID")
rsGroup.Close
set rstGroup = Nothing
Response.Redirect("admin_usergroups.asp?mode=Modify&ID=" & GroupID)
End If
I hope you can help me out. |
Edited by - Rob.B on 19 September 2002 18:09:59 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 19 September 2002 : 18:20:54
|
It must not like trying to grab the ID of the newly created record. Davio, can mySql handle that?
If it turns out that mySql can't do that then you can try commenting out line 107 and change the Response.Redirect to this:
Response.Redirect("admin_usergroups.asp") |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
Edited by - Nikkol on 19 September 2002 18:23:42 |
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 19 September 2002 : 18:30:02
|
I'm really sorry but i took the wrong file :(
This is the right file:
If strConfirm = "Add Group" Then
'## check for usergroup name uniqueness
set rsGroup = Server.CreateObject("ADODB.Recordset")
rsGroup.open strMemberTablePrefix & "USERGROUPS", my_Conn, 1, 3, 2
rsGroup.AddNew
line 107 ----> rsGroup("USERGROUP_NAME") = Request.Form("GroupName")
rsGroup("USERGROUP_DESC") = Request.Form("GroupDesc")
rsGroup.Update
GroupID = rsGroup("USERGROUP_ID")
rsGroup.Close
set rstGroup = Nothing
Response.Redirect("admin_usergroups.asp?mode=Modify&ID=" & GroupID)
End If
Sorry.
This is the DB setup to create the tables:
Database Setup for Usergroups
[CREATE]
ALLOWED_USERGROUPS
USERGROUP_ID#int##
FORUM_ID#int##
[END]
[CREATE]
USERGROUPS
USERGROUP_ID
USERGROUP_NAME#varchar(100)##
USERGROUP_DESC#memo##
[END]
[CREATE]
USERGROUP_MEMBERS
USERGROUP_ID#int##
MEMBER_ID#int##
MEMBER_TYPE#int##
[END] |
Edited by - Rob.B on 19 September 2002 18:31:13 |
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 20 September 2002 : 06:00:36
|
quote:
Originally posted by Davio
That doesn't look like a mysql server error. But an error with the ODBC driver. I have seen this error when working with memo/blob fields. They need to be the last fields in the SELECT statements or when inserting into the database.
I am guessing line 107 is an execute statement? Want to show us the SQL query that it is executing?
I don't use MEMO or BLOB fields. Only TEXT. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 September 2002 : 06:05:57
|
[CREATE]
USERGROUPS
USERGROUP_ID
USERGROUP_NAME#varchar(100)##
USERGROUP_DESC#memo##
[END] That is a memo field. |
Support Snitz Forums
|
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 20 September 2002 : 08:02:52
|
I changed that but it still doesn't work. I created the tables manualy now. Right from the admin_usergroups_setup.asp
What i actualy want with the Usergroup Mod is written in this topic:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=25117&SearchTerms=usergroup,moderator
(The idea from Nathan.)
Does anybody succeed to make something like that???
I have an example where such system is used.
gathering.tweakers.net
It's a dutch site but check the moderator categories!!
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 20 September 2002 : 08:30:09
|
quote:
I started the UserGroups mod and then Morpheus took it over.
Is someone still working on this? I thought I read a post earlier where he didn't have time to work on it and was requesting that someone else finish it and I believe your name was in that post.
|
|
|
|
Rob.B
New Member
Netherlands
93 Posts |
Posted - 20 September 2002 : 09:33:44
|
Morpheus has stopped with the Usergroup mod. He asked if somebody can take over and finish the mod.
But there where a lot of ideas posted at this forum. That's why i want to know if somebody has taken over the work of Morpheus or somebody who is coding something like it. |
|
|
| |
Topic |
|
Topic Locked
