| Author |
 Topic  |
|
|
vynsane
New Member
73 Posts |
 Posted - 16 October 2005 : 12:41:44
|
hi, i'm trying to implement the UserGroups mod on my unmodified ver.2 forum that i'm testing it out on, and i get the error
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_USERGROUP_USERS'. Make sure it exists and that its name is spelled correctly.
/forumv2/inc_func_common.asp, line 1322
when i look at the database, however, i have a table called FORUM_USERGROUP_USERS in there, so i don't know what's going on... line 1322 of inc_func_common.asp doesn't seem to have anything to do with the table directly, however there's a call to it a few lines above. once again, i'm using the PRE-MODIFIED files here, from the packet...
here's the url to my test forum...
www.vynsane.com/forumv2 |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 16 October 2005 13:22:12 |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 16 October 2005 : 21:52:52
|
A common response so the Moderators can help you better is to post a text file version of this file so we can see line for line of the problem.
Also I find it easier to change the code rather then use the premodified files. Try restoring the old file then use the readme to manually edit the file to see if that helps. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
 |
|
|
vynsane
New Member
73 Posts |
Posted - 17 October 2005 : 07:41:16
|
yeah, i'm going to go the line-by-line route later. right now my active forum is ver. 3.4.01, and my "test" is actually my 3.4.05 version that i want to upgrade to. i've got a couple of mods on my active version, and i need to add those changes to the ver.2 forum in addition to this usergroups mod.
i figured i didn't need to post a txt version of the file, since it's pre-modded, but yeah. i'm just gonna try to find the time to go line-by-line.
EDIT:
i've gone through and done all the changes line-by-line, but now i get an error on admin_usergroups.asp which is a new file, so here's the txt of the page and the error
Microsoft JET Database Engine error '80040e14'
Syntax error in ORDER BY clause.
/forumv2/admin_usergroups.asp, line 117
www.vynsane.com/forumv2/admin_usergroups.txt
EDIT #2
strange thing is, it is allowing me to create the groups, just won't let me view them after being made. if i create a group and hit the submit button, i get this error. but if i then click on the "usergroups" link at the top, it shows up. and i have full funcitonality with the deny/allow/read-only thing going on... |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 17 October 2005 22:09:33 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 October 2005 : 07:19:04
|
Are you using a MySQL database? If not then you need to remove the LIMIT from the query on line 117 and use TOP instead.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
vynsane
New Member
73 Posts |
Posted - 18 October 2005 : 09:07:10
|
| i'm using access, so that's probably it... so i just change the word "LIMIT" to "TOP"? |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 18 October 2005 09:13:33 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 October 2005 : 09:11:53
|
Not quite; where your query currently looks like this:
SELECT FIELDS FROM TABLE WHERE CRITERIA ORDER BY FIELD LIMIT 0,X
You need to change it to:
SELECT TOP X FIELDS FROM TABLE WHERE CRITERIA ORDER BY FIELD
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
vynsane
New Member
73 Posts |
Posted - 18 October 2005 : 09:17:37
|
uh... not too up on the asp lingo, but changing LIMIT to TOP seems to have worked...
right now, the line reads
set rsGroup = my_conn.execute("SELECT USERGROUP_ID FROM " & strTablePrefix & "USERGROUPS ORDER BY USERGROUP_ID DESC TOP 0,1")
so it would be instead
set rsGroup = my_conn.execute("SELECT TOP X USERGROUP_ID FROM " & strTablePrefix & "WHERE USERGROUPS ORDER BY USERGROUP_ID")
is that right? |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 18 October 2005 09:34:52 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 October 2005 : 09:35:30
|
Replace X with however many records you want to retrieve (in this case, 1) and remove the WHERE .
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
vynsane
New Member
73 Posts |
Posted - 18 October 2005 : 09:45:44
|
| thanks, that's working... it was working before, by changing the LIMIT to TOP and that's it, but i'm sure this is leaner code... |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 18 October 2005 09:46:18 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 October 2005 : 09:57:55
|
You're welcome 
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 01 December 2005 : 09:09:58
|
| BTW, Shaggy, I had the same problem except that I'm not using mySQL but SQL server; changing LIMIT to TOP fixed it too |
|
|
| |
Topic |
|
Topic Locked
