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 |
|
|
|