| Author |
 Topic  |
|
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 09 February 2013 : 11:19:19
|
The hosting company is going to move me to another server so I am trying to set up a temp site for my members. One member was just diagnosed with terminal cancer yesterday and another lost her mother so it's real important that we are able to stay in constant contact to encourage these members and several more as well.
However; I'm getting an error now when trying to set up a forum.
Parent Location: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.1.62-community]Unknown column 'F_PARENT' in 'field list'
/community/post.asp, line 665
Does anyone have time to look at this for me?
Here are lines 651 - 671
end if
if strRqMethod = "Forum" or _
strRqMethod = "URL" or _
strRqMethod = "EditURL" or _
strRqMethod = "EditForum" then
Response.Write "<tr>" & vbNewLine & _
"<td bgColor=""" & strPopupTableColor & """ nowrap valign=""top"" align=""right"">" & _
"<font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & _
"<b>Parent Location:</b></font></td>" & vbNewLine & _
"<td bgColor=""" & strPopupTableColor & """>" & vbNewLine
'Forum Parent!
'Find out if this forum is a sub-forum!
If strRqForumID = "" Then strRqForumID = 0
strSQL = "SELECT F_PARENT FROM FORUM_FORUM WHERE FORUM_ID = " & strRqForumID & " LIMIT 1"
set rsFindSub = my_Conn.Execute(strSQL)
if rsFindSub.eof then
strSubForum = NULL
else
strSubForum = rsFindSub("F_PARENT")
end if
set rsFindSub = Nothing
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 February 2013 : 11:23:08
|
Error means there is no F_PARENT field in the FORUM_FORUM table in your database.
If this is a mod, you need to install the database fields for it. |
Support Snitz Forums
|
 |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 09 February 2013 : 11:41:20
|
Well, I must have omitted one of the database files. I thought my list was accurate. I ran several databases and then moved my files over to that directory. Oh dear! Can't imagine which one I missed!
Thank you!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 09 February 2013 : 19:30:13
|
| F_Parent belongs to the sub-forum mod |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 09 February 2013 : 20:41:54
|
THAT'S the one I missed!
THANK YOU SO MUCH!! 
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
| |
Topic |
|
