| Author |
 Topic  |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
 Posted - 21 October 2000 : 09:28:35
|
I am going to work on getting this ready for download late tonight or early tomorrow morning. I just have to clean the code up some and test install it on a couple of different configurations and then I will post it.
M_PMEMAIL, and M_PMRECEIVE are long integer.
Edited by - Richard Kinser on 21 October 2000 09:41:57 |
 |
|
|
magicwolf
Starting Member
11 Posts |
Posted - 21 October 2000 : 22:23:42
|
hello everyone!
i download the snitzforum 2000(works fine!) and slemieux's private.zip,also updated the database,but get the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Divers] syntax error (˛Ů×÷·űlost) at 'count(M_TO) pmcount' .
/muyu/forum/privatemess.asp, line 12
please help me ! tellme how to setup the private mod and online mod,thanks!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
thaksis
Starting Member
29 Posts |
Posted - 22 October 2000 : 12:27:00
|
i get this error yet it still sends the messages.
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'rsName'
/forums/privatesend_info.asp, line 278
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Page:
POST 288 bytes to /forums/privatesend_info.asp
|
|
|
|
magicwolf
Starting Member
11 Posts |
Posted - 23 October 2000 : 14:38:50
|
my forum still have errors!
-----------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error'80040e14'
[Microsoft][ODBC Microsoft Access 97 Drives] syntax error (control symbos lost) at 'count(M_TO) pmcount'
/muyu/forum/privatemess.asp, line 50
line 50: set rsPM = my_Conn.Execute(strSql)
why ? hope you help me !
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 October 2000 : 21:12:33
|
| slemieux, do you have any ideas on this error? |
|
|
|
jwilkens
New Member
65 Posts |
Posted - 23 October 2000 : 21:28:13
|
How about this one during the <i>pmdbsetup.asp</i>:
<pre id=code><font face=courier size=2 id=code>
CREATE TABLE FORUM_PM (M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT nvarchar (50) NULL , M_FROM int NULL , M_TO int NULL , M_SENT nvarchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT nvarchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL nvarchar (50) NULL , M_OUTBOX smallint NULL )
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
/beta/pmdbsetup.asp, line 62
</font id=code></pre id=code>
Oh, and can we try to keep it to 1024x768? :)
Edited by - jwilkens on 23 October 2000 21:30:55 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 October 2000 : 22:13:02
|
| Can you re-download that .zip file. I changed the pmdbsetup.asp file a little bit. If it doesn't work this time, you will probably have to take out the <b>DEFAULT 0</b> from line #57 of <b>pmdbsetup.asp</b>. You would then need to edit the db manually and set the default for that field to <b>0</b>. |
|
|
|
thaksis
Starting Member
29 Posts |
Posted - 24 October 2000 : 08:47:54
|
Oh, the rsName mismatch only seems to happen when you reply to a message.Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'rsName'
/forums/privatesend_info.asp, line 278
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 October 2000 : 09:10:09
|
thaksis,
Try this file:
http://www1.domaindlx.com/dssdbs/files/pmdbfix.zip
This will delete the 2 database fields in the MEMBERS table and then readd them with a default setting for the PM options.
I think that you are getting that error because the user that you are sending the PM to hasn't set their preferences for PM.
Let me know if this fixes it.
I updated the <b>pm_mod.zip</b> above with this change already. It will add the fields with a default value. |
|
|
|
thaksis
Starting Member
29 Posts |
Posted - 24 October 2000 : 12:58:51
|
nope... i even went and tried changing it manually in the actual db.... i'm lost... not surprisingly since i'm not an asp guru.... uhmmm if you want you can e-mail me and i'll send you the db or url or even easier http://foc.tzo.net
|
|
|
|
James
Average Member
USA
539 Posts |
Posted - 26 October 2000 : 21:45:01
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Here, try this, it's a modified privatesend.asp that doesn't require the inc_code.asp or iecode.asp.
http://www1.domaindlx.com/dssdbs/files/privatesend.zip
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Does this one still require <b>netscapebuttons.asp</b>? And is this all that's required on ver 3sr2 (not ver 3.1)?
-
<font color=red>*</font id=red><font color=blue>Interested in <b>Radio Control</b> </font id=blue><font color=red>-</font id=red> http://www.rcwebboard.com/<font color=red>*</font id=red> |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
jwilkens
New Member
65 Posts |
Posted - 27 October 2000 : 13:32:52
|
File/Page not found
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
and this file:
http://www1.domaindlx.com/dssdbs/files/members2.zip
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Topic |
|
Topic Locked
