| Author |
 Topic  |
|
|
dribbles
Starting Member
16 Posts |
 Posted - 23 April 2002 : 11:33:47
|
I have the scrolling version, but for some reason, I keep getting a
quote:
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ANNOUNCE'. Make sure it exists and that its name is spelled correctly.
/snitz/inc_announce.asp, line 54
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0; T312461)
Page:
GET /snitz/default.asp
error message. Is this because I need Richard's Forum annoncement MOD? If so, where can I get the original. I tried the Exchange, but couldn't find it. Much thanks!
|
|
|
Ripp
Starting Member
10 Posts |
Posted - 24 April 2002 : 14:59:31
|
After editing the inc_top and admin_add_announce files, and uploading the needed files, I run the Forum Announcements setup and receive the following message:
Creating table(s)...
CREATE TABLE FORUM_ANNOUNCE( A_ID int IDENTITY (1, 1) NOT NULL , A_AUTHOR;varchar (50);NULL; NOT NULL , A_SUBJECT;varchar (50);NULL; NOT NULL , A_MESSAGE;text;NULL; NOT NULL , A_START_DATE;varchar (50);NULL; NOT NULL , A_END_DATE;varchar (50);NULL; NOT NULL )
-2147217900 | Syntax error in field definition.
When I go back to my forum, I get a "Page cannot be displayed" and the following error with inc_top:
Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ANNOUNCE'. Make sure it exists and that its name is spelled correctly.
/goup/forum/inc_top.asp, line 313
This is the code from the readme and is what I added:
</table>
</td>
<%
if InstrRev(Request.ServerVariables("Path_Info"), "view_announcements.asp") = 0 then
if InstrRev(Request.ServerVariables("Path_Info"), "admin_") = 0 then
'## Forum_SQL - Build SQL to get forums via category
strSql = "SELECT " & strTablePrefix & "ANNOUNCE.A_ID "
strSql = strSql & "FROM " & strTablePrefix & "ANNOUNCE "
set rschkAnnounce = my_Conn.Execute (strSql)
if rschkAnnounce.eof or rschkAnnounce.bof then '## No Announcements found in DB
Response.Write ""
Else
%>
<tr>
<td>
<!--#INCLUDE FILE="inc_announce.asp" -->
</td>
</tr>
<% End If
set rschkAnnounce = nothing
end if
end if
%>
</tr>
</table>
What do I need to do to make this work? Also, I'm running 3.1 SR4. (haven't upgraded yet)
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2002 : 15:43:47
|
try opening the forum_announcements.dbs file and change all of the semicolons (;) to hash marks (#)
Then run the database setup again. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2002 : 15:45:28
|
quote:
error message. Is this because I need Richard's Forum annoncement MOD? If so, where can I get the original. I tried the Exchange, but couldn't find it. Much thanks!
I will have a v3.3.03 compatible version out soon. |
|
|
| |
Topic |
|
|
|
Topic Locked
