| Author |
 Topic  |
|
|
JoSmiley
Starting Member
7 Posts |
 Posted - 15 December 2002 : 22:42:17
|
We are trying to add a new moderator in our forum. When we try to change his status from normal member to moderator, we get this error message:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/pop_profile.asp, line 1625
Line 1625 of the pop_profile.asp reads:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
What are we doing wrong? |
Edited by - ruirib on 17 December 2002 12:58:44 |
|
|
Rasco
Advanced Member
Germany
3192 Posts |
Posted - 16 December 2002 : 04:16:34
|
| Have you added any Mods or changed some other code? |
German Snitz Forum
|
 |
|
|
JoSmiley
Starting Member
7 Posts |
Posted - 16 December 2002 : 05:45:42
|
I'm not sure... I don't think so, but I'll check into it.
Would that cause it? Would we need to remove the mods then
to make it work? I'll find out... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 December 2002 : 05:49:02
|
| You'd need to check the changes you made and compare them with the instructions in the mod's readme file, to make sure you didn't miss anything. Surely you changed something incorrectly or missed some change. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
JoSmiley
Starting Member
7 Posts |
Posted - 16 December 2002 : 05:53:55
|
Okay, I'll send an email to my partner in this mess and have her check into it. She's the one who does all the mod installation and she'll know what's going on with if we've changed anything.
Thank you! :) |
|
|
|
JoSmiley
Starting Member
7 Posts |
Posted - 17 December 2002 : 06:54:15
|
I haven't yet heard back from her, so I'm trying to look into this myself. (she's in california & I'm in wisconsin - we're kinda scattered...) However, it won't let me in the MOD Setup area. It tells me "Only the Forum Admin can access this area."
Well, both her and I are administrators for the site/forums and we're supposed to have equal access to things - so I'll need to check with her on that. I can get into everything but that area....so, is there someplace else I can go to check on this problem of the member status until I hear from her or am I stuck waiting?
Thank you! :) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 December 2002 : 07:10:11
|
You cannot go into the mod setup area because only the super admin can do that. You can change the super admin (and a forum as a single super admin) by changing this line (around line# 80) in config.asp:
Const intAdminMemberID = 1
Just replace that 1 by your member id and you'll become the superadmin. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
David K
Junior Member
494 Posts |
Posted - 17 December 2002 : 11:31:16
|
the MOD installation part is not the problem, when adding a MOD you need to preform changes to other files. apperantly she hasn't preformed the changes properly, and that's the problem.
P.S. rurib, you seem to be very active today |
|
|
|
CosmicFawn
Starting Member
USA
29 Posts |
Posted - 17 December 2002 : 12:31:07
|
Hi, I'm the partner JoSmiley was talking about. Our fourms are actually the full site code version that Serverhacker placed up here. We've asked for help on his forums as well but aren't really getting any answer to the problem. It is not only trying to change a member's status bbut also trying to change any information at all, even opening that page and then just pressing submit will give that same error message.
These are the MODs that are installed:
Inactive Users v1.10 for snitz 3.4.x
Poll Mod
Top Posters Mod
Site/Visitor Counter (for sitenews)
Newsletter Mod
File Lister Mod (for users)
File Library (for admin only)
Guestbook Mod
Updated Photo Albums Mod
Alternative Member-In-Spotlight Mod
Updated File-Upload Mod
Avatar addon mod
Chat Mod
Mod Stars Setup
IPGate for v3.4
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
