Snitz Forums 2000 - UserGroups Problem

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

UserGroups Problem

New Topic

Topic Locked

Printer Friendly

Author

Topic

Maikadal
Starting Member

41 Posts

Posted - 11 March 2004 : 19:46:28

I have installed the UserGroups Beta II mod but when I try to make a new usergroup I get this error

Microsoft JET Database Engine error '80040e14'

Syntax error in ORDER BY clause.

/ds2/forums/admin_usergroups.asp, line 117

Anyone know whats going on? Thanks.

Edited by - ruirib on 11 March 2004 20:33:30

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 11 March 2004 : 20:04:36

Nikkol (the MOD author) has posted a fix in this topic (third post).

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz

Maikadal
Starting Member

41 Posts

Posted - 11 March 2004 : 22:03:52

Yes, I've applied the fix and I still get the error. Line 117 reads:

set rsgroup = my_conn.execute("SELECT USERGROUP_ID FROM forum_usergroups ORDER BY usergroup_id DESC LIMIT 0,1")

miperez
Junior Member

Spain
243 Posts

Posted - 12 March 2004 : 04:57:33

Use this line instead:


set rsGroup = my_conn.execute(TopSQL("SELECT USERGROUP_ID FROM " & strTablePrefix & "USERGROUPS ORDER BY USERGROUP_ID DESC;",1))

Best Regards

Mikel Perez

"Hell is the place where everything test perfectly, and nothing works"

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.35 seconds.