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: MOD Implementation
 Query Error		  New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  14:34:27  Show Profile
Below Code is giving me An error in Topic.asp line 56 :

quote:

intAUTopicID = Request.QueryString("TOPIC_ID")
If intAUTopicID <> "" Then
strSQL2 = "SELECT FORUM_ID FROM " & strTablePrefix & "FORUM WHERE TOPIC_ID = " & CInt(intAUTopicID) & ";"
Response.write strSQL2
Set rs1 = my_conn.execute (strSQL2)


quote:
Response.write strSQL2
Returns me

SELECT FORUM_ID FROM FORUM_FORUM WHERE TOPIC_ID = 560;

I believe there is No FORUM_FORUM table and thats why this is the Error ?

modifichicci
Average Member

Italy
787 Posts
Posted - 18 March 2008 :  14:36:36  Show Profile  Visit modifichicci's Homepage
strTablePrefix & "FORUM = FORUM_FORUM

what error do you get?
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 18 March 2008 :  14:49:36  Show Profile  Visit HuwR's Homepage
what is the error? that generaly helps
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  15:03:10  Show Profile

http://www.ulcindia.com/forum/topic.asp?TOPIC_ID=391

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/inc_func_common.asp, line 56
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 18 March 2008 :  15:15:14  Show Profile  Visit modifichicci's Homepage
what have you in inc func common in lines around 56?
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  15:22:26  Show Profile
quote:

strSQL2 = "SELECT FORUM_ID FROM " & strTablePrefix & "FORUM WHERE TOPIC_ID = " & CInt(intAUTopicID) & ";"
Response.write strSQL2
Set rs1 = my_conn.execute (strSQL2)
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 18 March 2008 :  15:34:57  Show Profile  Visit HuwR's Homepage
this does not make any sense
SELECT FORUM_ID FROM FORUM_FORUM WHERE TOPIC_ID = 560;

how do you expect to find a TOPIC_ID in the forum table ??
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  15:38:13  Show Profile
:-(

Then ?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 18 March 2008 :  15:41:45  Show Profile  Visit HuwR's Homepage
then what? I have no idea what it is supposed to be doing so can't tell you how to fix it, is it supposed to finding a topic or a forum ?
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  15:48:18  Show Profile
I guess Forum..

Let me Reproduce what i did :

www.ulcindia.com/forum

I clicked On Active Poll.
Then selected a particular poll.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 18 March 2008 :  16:04:53  Show Profile  Visit HuwR's Homepage
like I keep telling you, YOU DO NOT HAVE THE ACTIVE USERS MOD INSTALLED CORRECTLY so either remove it and replace your code with standard snitz code or re-install the active users mod correctly
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 18 March 2008 :  22:42:59  Show Profile

Installed Active User MOD again, But still..

If I try to Open any TOPIC I get an Error :

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/inc_func_common.asp, line 56


This query give an error :

SELECT FORUM_ID FROM FORUM_FORUM WHERE TOPIC_ID = 562;
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 19 March 2008 :  02:06:04  Show Profile  Visit HuwR's Homepage
you should recheck, since there is no topic_id in the forum table so something is obviously wrong with the code
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 19 March 2008 :  09:22:49  Show Profile

:-(
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 19 March 2008 :  09:25:01  Show Profile

Should I try to post TEXT format for inc_func_common.asp , so that you can review it ?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 19 March 2008 :  11:31:40  Show Profile  Visit HuwR's Homepage
try uploading an unmodified inc_func_common, MODS should really not be making changes to that file anyway.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next 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.39 seconds. Powered By: Snitz Forums 2000 Version 3.4.07