| Author |
 Topic  |
|
|
stuF
Average Member
United Kingdom
561 Posts |
 Posted - 24 April 2001 : 15:31:14
|
Snitz Events Calendar v2 sr1:error
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID INT (11) DEFAULT '' NOT NULL auto_increment , DATE_ADDED varchar (20) NOT NULL , START_DATE varchar (20) NOT NULL , END_DATE varchar (20) NOT NULL , EVENT_TITLE varchar (100) NOT NULL , EVENT_DETAILS text NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0,KEY FORUM_EVENTS_EVENT_ID(EVENT_ID))
-2147217900 | Syntax error in CREATE TABLE statement.
i also get a long list of errors when trying to setup te classified ads mod..whats gonig wrong?
thanx, stuart
Edited by - stuF on 24 April 2001 16:59:49 |
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 16:22:22
|
and these when trying the PRV MSG mod..can anybody offer any help?
-------------------------
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID INT (11) DEFAULT '' NOT NULL auto_increment , M_SUBJECT varchar (50) NULL , M_FROM int (11) NULL , M_TO int (11) NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int (11) NULL DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX tinyint NULL DEFAULT 1,KEY FORUM_PM_M_ID(M_ID))
-2147217900 | Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD M_PMEMAIL int (11) NULL DEFAULT 0
-2147217900 | Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD M_PMRECEIVE int (11) NULL DEFAULT 1
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated
|
 |
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 16:44:30
|
anyone?
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 16:53:43
|
im also getting (500)internal server errors when trying to view the files which are part of the mod...
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 17:16:17
|
hmm....bumpety bump...
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 17:26:50
|
In just about all of the MODS, there is a notice that says that it is recommended for you to use the strConnString in config.asp that is labeled as for use with Access 2000, it looks like you are using one that is labeled for use with Access97.
The strConnString that is labeled for use with Access97 uses drivers that don't support having DEFAULT in the SQL code that is used to setup the database, that is why you get errors. |
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 17:31:31
|
cheers...
would you be able to tell me which of the lines i need to uncomment in config.asp to change this, and how much of the database path needs t be insered to do it, cheers...
Edited by - stuF on 24 April 2001 17:36:15 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 17:45:14
|
| just post what you have now and I'll let you know. |
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 17:48:57
|
ive done that part, and the forums working now, then i went back to mod_dbsetup.asp and did the prv msg mod, which created the tables fine, then i went to privatemess.asp and got the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'my_Conn'
/cgi-bin/forum/privatemess.asp, line 50
cheers, stuart
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 18:08:31
|
| privatemess.asp is meant to be an include file, not a standalone file. Try going to pm_view.asp instead. |
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 18:12:37
|
thank oyu soo much for that, its working great...however, in the readme, it said to add somthing like this to default.asp:
<%
else
blnHiddenForums = true
end if ' ChkDisplayForum()
rsForum.MoveNext
loop
end if
rs.MoveNext
loop
end if
%>
<!--#include file="privatemess.asp"-->
<%
if strShowStatistics = "1" then
WriteStatistics
end if %>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%">
<tr>
<td>
<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>">
<img alt="New Posts" src="icon_folder_new.gif" width=8 height=9> Contains new posts since last visit.<br>
<img alt="Old Posts" src="icon_folder.gif" width=8 height=9> No new posts since the last visit.<br>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
but when i add it i get an erro saying that there is a loop with no do
?
sorry to be such a hassle, thanx ofr oyur continued help Stuart
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 18:43:03
|
Just make sure you insert it exactly like it shows and you shouldn't get an error.
here is how mine looks:
<%
else
blnHiddenForums = true
end if ' ChkDisplayForum()
end if ' HideCat
rsForum.MoveNext
loop
end if
rs.MoveNext
loop
end if
%>
<!--#include file="privatemess.asp"-->
<%
if strShowStatistics = "1" then
WriteStatistics
end if
%>
</table>
</td>
</tr>
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 24 April 2001 : 18:50:19
|
<%
else
blnHiddenForums = true
end if ' ChkDisplayForum()
end if ' HideCat
rsForum.MoveNext
loop
end if
rs.MoveNext
loop
end if
%>
<!--#include file="privatemess.asp"-->
<%
if strShowStatistics = "1" then
WriteStatistics
end if
%>
</table>
</td>
</tr>
<%
end if
end sub
%>
that is the end of the default.asp code, this is error im getting:
Microsoft VBScript compilation error '800a03f8'
Expected 'Sub'
/cgi-bin/forum/default.asp, line 618
end if ' HideCat
----^
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 18:59:56
|
you probably don't have the Minimize Category Mod installed so you can just delete the:
end if ' HideCat
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 25 April 2001 : 14:19:32
|
me again...
Snitz Events Calendar v2 sr1
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , DATE_ADDED#varchar (20)## NOT NULL , START_DATE#varchar (20)## NOT NULL , END_DATE#varchar (20)## NOT NULL , EVENT_TITLE#varchar (100)## NOT NULL , EVENT_DETAILS#memo## NOT NULL , ADDED_BY#int## NOT NULL , PRIVATE#int##0 NOT NULL )
-2147217900 | Syntax error in field definition.
thats another error i get when trying to install the calender mod...anyone know what it is?
|
|
|
| |
Topic |
|
Topic Locked
