Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 UserGroups v1.0 BETA2
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 10

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 29 October 2004 :  23:28:36  Show Profile
Can you post the exact error please

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

tolsky
Starting Member

23 Posts

Posted - 02 November 2004 :  18:02:27  Show Profile
Hi, I just want to make sure that I understand what this mod does. I'm using my forum for doctors and want to set it up so that based on what specialty a doctor is they would see folders for that specialty (a cardiologist would see the cardiologist folder but not the ob/gyn folder). It sounds like this is the kind of thing that this mod allows. I'm also going to have links to pdf files in my forum that will be specific for certain specialties so I would want to apply the same sort of logic. Will this mod allow me to set it up so only people in the cardiologists group, along with the admins, would see the cardiologists pdf links? There would also be some folders and links that I might want multiple groups to have access to, can I do that as well?

Thanks.

Ben
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 02 November 2004 :  18:07:08  Show Profile
Yes, the mod will do this. As long as the pdf are posted within the forums that have their permissions for certain groups, then yes, the pdf restrictions should work too. A forum can have as many groups assigned to it as you like.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

tolsky
Starting Member

23 Posts

Posted - 03 November 2004 :  12:20:18  Show Profile
Alright I just installed it and I'm getting the following error on the User Groups manager page in the Admin section:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_USERGROUPS'. Make sure it exists and that its name is spelled correctly.

/snitz/admin_usergroups.asp, line 520

I ran that code in the Alternate MOD Setup and created a bunch of new tables, except the first one it tried to create it said already existed. Anyways there is no FORUM_USERGROUPS table in by database, there is however a FORUM_USERGROUP_USERS table and a FORUM_ALLOWED_USERGROUPS table.

Ben

quote:
Originally posted by Nikkol

Yes, the mod will do this. As long as the pdf are posted within the forums that have their permissions for certain groups, then yes, the pdf restrictions should work too. A forum can have as many groups assigned to it as you like.

Go to Top of Page

tolsky
Starting Member

23 Posts

Posted - 03 November 2004 :  12:58:31  Show Profile
Nevermind, I was able to fix this myself, I just created the table in Access manually. I guess the SQL code that was being run for that table was actually SQL written for SQL Server, not Microsoft Access.

Ben

quote:
Originally posted by tolsky

Alright I just installed it and I'm getting the following error on the User Groups manager page in the Admin section:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_USERGROUPS'. Make sure it exists and that its name is spelled correctly.

/snitz/admin_usergroups.asp, line 520

I ran that code in the Alternate MOD Setup and created a bunch of new tables, except the first one it tried to create it said already existed. Anyways there is no FORUM_USERGROUPS table in by database, there is however a FORUM_USERGROUP_USERS table and a FORUM_ALLOWED_USERGROUPS table.

Ben

quote:
Originally posted by Nikkol

Yes, the mod will do this. As long as the pdf are posted within the forums that have their permissions for certain groups, then yes, the pdf restrictions should work too. A forum can have as many groups assigned to it as you like.



Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 03 November 2004 :  13:17:54  Show Profile  Visit PeeWee.Inc's Homepage
Remember people, this is still classed as beta

De Priofundus Calmo Ad Te Damine
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 03 November 2004 :  20:10:52  Show Profile
It was written for access, I don't use sql.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 03 November 2004 :  22:00:42  Show Profile  Visit Etymon's Homepage
Hi Nikkol,

In the download, have the forum files been updated for a 3.4.05 Snitz forum?

Thanks,

Etymon
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 04 November 2004 :  11:57:13  Show Profile
they have not been updated for 3.4.05

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

jonspruce
Starting Member

United Kingdom
11 Posts

Posted - 05 November 2004 :  12:10:52  Show Profile
excellent mod nikkol

have installed but have received a few errors (i did notice similar ones here but could not see how to resolve...)

problem one occurs when adding a new UserGroup

when i click submit the page gives me this error

Microsoft JET Database Engine error '80040e14' 

Syntax error in ORDER BY clause. 

/forum/admin_usergroups.asp, line 117 


although when i get back to the UserGroup manager page, the item has been added and works and will get configured without a hitch!

any ideas?


simply removed the LIMIT 0,1 from the SQL statement in the include and it worked!

i didnt think it was going to be such a quick fix - sorry for that!

the second problem still persists however


second issue as follows:

when i make any changes to the config of a forum, i get the following error:


Type mismatch: 'rsCount' 

/forum/post_info.asp, line 1455 


and the UserGroup permissions area seems a little different to how it should be:




the actual setup for users seems to be fine as i can assign them to the relevant groups (both within their profiles and from within the UserGroup manager) and have tested that the members can/not see the relevant areas - but when it comes to setting up/changing any setting on a forum (i am trying to setup moderators but the problem happens with any change to this area)

this is the final piece in the puzzle so would greatly appreciate any help at all!!

a camel is a horse designed by committee

Edited by - jonspruce on 05 November 2004 12:19:40
Go to Top of Page

jonspruce
Starting Member

United Kingdom
11 Posts

Posted - 05 November 2004 :  12:14:46  Show Profile
just did a few minor tests within the Forum edit page

any changes to the Moderator section gets the error but no changes appear when clicked back and refreshed

any changes to other areas of this page gets the error but changes are made when clicked back and refreshed

this area was fine prior so can only assume its the MOD and my configuration of it!

hope that helps?

a camel is a horse designed by committee

Edited by - jonspruce on 05 November 2004 12:24:45
Go to Top of Page

jonspruce
Starting Member

United Kingdom
11 Posts

Posted - 05 November 2004 :  12:24:29  Show Profile
scrub it all - a little bit more of a delve into the code and i found that the line i had inserted in post_info.asp mustn't have copied correctly from the clipboard!

a quick scoot thorugh the readme again, found the change as it should have been and recopied and pasted back in place, uploaded and voila fixed forum!

i must get more sleep or more caffiene!


the forum edit page still looks a little weird though...

a camel is a horse designed by committee

Edited by - jonspruce on 05 November 2004 12:26:08
Go to Top of Page

jonspruce
Starting Member

United Kingdom
11 Posts

Posted - 06 December 2004 :  06:33:57  Show Profile
hey guys,

have installed and used this mod fine since the above mistakes have been rectified.

could do with a little help in adding the assignment of people to specific usergroups at the point of activation - otherwise we have to activate a users account, jump into the members edit before they log on and assign them to the relevant section!

have created a "general" forum that allows all users to be registered to it upon signup which helps to ensure they don't see the whole restricted forum areas but this is a little clunky.

the ideal situation would be as follows:

1. user registers
2. we choose which usergroup they belong to (popup? dropdown?)
3. we activate account
4. user receives email to say "welcome to the forum....login using..."

at the moment we approve their account, then to assign any usergroup privelidges we have to activate their account (with email validation ON this causes an issue as the email they receive with the activation code link becomes obsolete!)

am a little confused still as to the different status of "approve" and "activate" - we cant seem to simply change/view the details of a member (other than IP address and username) before approving/activating the account....

how can we validate the users details as a valid user of the forum without being able to view this info?

any help would be greatly appreciated!

a camel is a horse designed by committee

Edited by - jonspruce on 06 December 2004 06:35:54
Go to Top of Page

Gandiel
Starting Member

21 Posts

Posted - 07 December 2004 :  12:53:52  Show Profile
Could anyone provide a definition of what each setting does...

I know it may sound self-explanatory... but my admins are getting all confused about Deny and Do Not Set.

Honestly, I get confused about it myself sometimes...



Thanks,
Gandiel

Edited by - Gandiel on 07 December 2004 12:54:11
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 07 December 2004 :  20:30:43  Show Profile
Do Not Set means that it will perform the same way as if you did not have the mod installed. Deny will specifically deny a person or group from a forum (for instance, someone was misbehaving, so you put them on probation for a while).

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page
Page: of 10 Previous Topic Topic Next Topic  
Previous Page
 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.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07