| Author |
 Topic  |
|
|
Nightline
Starting Member
USA
5 Posts |
 Posted - 22 January 2004 : 17:10:33
|
I added the calendar mod, and its working great, but I just went to edit a calendar entry, and got the following error.
Microsoft OLE DB Provider for SQL Server error '80040e14'
The column prefix 'M' does not match with a table name or alias name used in the query.
/isi/forums/post.asp, line 350
My Line 350 area looks like this
---------------------------------------
if strRqMethod = "EditTopic" or strRqMethod = "TopicQuote" then
'## Forum_SQL
strSql = "SELECT M.M_NAME, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_ISEVENT, T.T_SIG, T.T_MESSAGE "
set rs = my_Conn.Execute (strSql)
TxtSub = rs("T_SUBJECT")
strAuthor = rs("T_AUTHOR")
if strStickyTopic = "1" then
strTopicSticky = rs("T_STICKY")
end if
if strRqMethod <> "TopicQuote" then IsEvent = rs("T_ISEVENT")
if strRqMethod = "EditTopic" then
TxtMsg = rs("T_MESSAGE")
else
if strRqMethod = "TopicQuote" then
TxtMsg = "quote:
Originally posted by " & chkString(rs("M_NAME"),"display") & "" & vbNewline
TxtMsg = TxtMsg & "
" & rs("T_MESSAGE") & vbNewline
TxtMsg = TxtMsg & "
"
end if
end if
end if
|
Edited by - Nightline on 22 January 2004 17:11:04 |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 23 January 2004 : 00:50:14
|
Which CAL mod are you using? I think I'm using EVENTS CALENDAR MOD FOR SNITZ 3.4.03 by red1 Mod Version: 1.0 ... Mine works, but when I edit an event post it changes the date to today's date and not the date they specified (either originally or in the edited post).
This is frustrating, because people will post an event, go back to edit it, and now it shows up as the wrong date and I have to manually fix it in SQL. It's been happening ever since I installed the plugin over the summer, but I've just been to lazy to fix it. I went over my files tonight and made sure they had all the correct entries. My only guess is that there is this one section of code in my post.asp that is not easily implemented. It's mixed with some code from the POLL mod? =( |
 |
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
Posted - 23 January 2004 : 01:52:23
|
Nightline, add the two red lines in your code in post.asp
strSql = "SELECT M.M_NAME, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_ISEVENT, T.T_SIG, T.T_MESSAGE "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T "
strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR AND T.TOPIC_ID = " & strRqTopicID
set rs = my_Conn.Execute (strSql)
You must have deleted thes lines when installing the MOD, as they are part of original SNitz code.
A SQL statement consist of
SELECT (fields)
FROM (tables)
WHERE (filter)
The code you were left with only contained the SELECT statement, not telling the database what tables to get stuff from and how to filter the records.
The M after the Table name is something called an alias, so you don't have to write the actual table name so many times. |
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
Edited by - NorwegianViking on 23 January 2004 01:52:51 |
|
|
|
Nightline
Starting Member
USA
5 Posts |
Posted - 23 January 2004 : 09:00:15
|
ok, that worked NorwegianViking.
Thanks a bunch!! |
|
|
|
Nightline
Starting Member
USA
5 Posts |
Posted - 23 January 2004 : 09:32:13
|
Just found another error when I click on Active topic at the top.
Microsoft OLE DB Provider for SQL Server error '80040e14'
The column prefix 'F.F_PASSWORD_NEW.T' does not match with a table name or alias name used in the query.
/isi/forums/active.asp, line 308
Any ideas on that one? |
|
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
Posted - 23 January 2004 : 11:58:01
|
hello again
It is the same kind of error.
Probably missing the FROM statements in the SQL code again. 
Seems like you have been a little to hard on the Delete key when Modding.
The error is produced when the statement:
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
is executed. (This is at line 307 in an unmodded active.asp i v3.4.04)
This line sends the SQL code to your database to retreive records.
The variable strSql is suppose to include the SELECT, FROM, WHERE and ORDER statements.
If you look around line 244, you will see that the code starts building the StrSQL variable.
After adding fields to the SELECT staement, it starts on the FROM statement.
I suppose that some lines is missing here.
This is how it look in the unmodded Active.asp
"F.F_PASSWORD_NEW " & _
"FROM " & strMemberTablePrefix & "MEMBERS M, " & _
strTablePrefix & "FORUM F, " & _
strTablePrefix & "TOPICS T, " & _
strTablePrefix & "CATEGORY C, " & _
strMemberTablePrefix & "MEMBERS MEMBERS_1 " & _
I suppose the line marked (by me) in red is the one missing.
|
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
|
|
|
Nightline
Starting Member
USA
5 Posts |
Posted - 23 January 2004 : 12:32:04
|
| I have to admit, I was very anxious when installing the calendar mod, so I probably did hit that DEL key to fast.. I will have to slow down a bit. Thanks for all your help, I will try this. |
|
|
|
Nightline
Starting Member
USA
5 Posts |
Posted - 23 January 2004 : 14:56:50
|
You wont believe it, but I forgot a simple "," (comma)
strTablePrefix & "FORUM F, " & _ |
|
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 17 February 2004 : 16:41:01
|
I still haven't resolved my problem. I have a copy of my post.asp uploaded as a txt file. Please let me know if you can spot the error I suspect it has something to do with the collection and conversion of the dateholder value.
http://www.louipimps.com/forum/post.txt |
|
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 18 February 2004 : 04:26:36
|
| Ahhh please help me guys. I've had this problem for 6 months + |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 February 2004 : 20:48:37
|
| Radianation, try starting a new topic with the problem you are having. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
