Author |
Topic |
|
HellRazor
New Member
59 Posts |
Posted - 29 April 2001 : 20:50:13
|
Can anyone tell me what is wrong with this SQL statement? My Snitz forum errors out when trying to edit messages, here is the SQL statement and the error I am getting:
SELECT FORUM_TOPICS.CAT_ID, FORUM_TOPICS.FORUM_ID, FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_AUTHOR, FORUM_TOPICS.T_MAIL, FORUM_TOPICS.T_MESSAGE , FORUM_TOPICS.T_ORDER FROM FORUM_TOPICS WHERE FORUM_TOPICS.TOPIC_ID = 4 AND FORUM_TOPICS.T_STATUS = 1 Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters
/forum/post.asp, line 454
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 29 April 2001 : 21:14:28
|
DO you have the topic sorting MOD installed ? if not then this FORUM_TOPICS.T_ORDER is what is causing your problem
|
|
|
HellRazor
New Member
59 Posts |
Posted - 29 April 2001 : 23:21:03
|
Yep, its installed. In fact I'm running the latest HUWR Snitz forum with a few mods added to it (mainly the Avatar mod).
HellRazor
quote:
DO you have the topic sorting MOD installed ? if not then this FORUM_TOPICS.T_ORDER is what is causing your problem
|
|
|
HellRazor
New Member
59 Posts |
Posted - 29 April 2001 : 23:39:25
|
Well, I take that back...does the HUWR forum come with this mod installed?
If not, I think these changes might be part of the Content Management System, which I also added.
|
|
|
HellRazor
New Member
59 Posts |
Posted - 29 April 2001 : 23:44:02
|
In any event, I checked my database and it didn't have that field included...I added it and that seems to have fixed the problem.
Can you point me to where this mod is located? I'm betting that I only have the mod partially installed from when I added the Content Management System.
Thanks for your help!
|
|
|
|
Topic |
|