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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Can anyone tell me whats wrong with this SQL ?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

HellRazor
New Member

59 Posts

Posted - 29 April 2001 :  20:50:13  Show Profile
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  Show Profile  Visit HuwR's Homepage
DO you have the topic sorting MOD installed ? if not then this FORUM_TOPICS.T_ORDER is what is causing your problem

Go to Top of Page

HellRazor
New Member

59 Posts

Posted - 29 April 2001 :  23:21:03  Show Profile
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





Go to Top of Page

HellRazor
New Member

59 Posts

Posted - 29 April 2001 :  23:39:25  Show Profile
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.


Go to Top of Page

HellRazor
New Member

59 Posts

Posted - 29 April 2001 :  23:44:02  Show Profile
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!

Go to Top of Page
  Previous Topic Topic Next Topic  
 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.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07