| Author |
 Topic  |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
 Posted - 05 December 2000 : 00:57:42
|
Your using ChiliASP right? I'll have to try and see exactly what it doesn't like in the CREATE TABLE statement. It probably doesn't like the DEFAULT statements.
Can you download your database and add stuff to it manually?
If so, I can export the table from one of my databases and you can just import it into yours.
Edited by - Richard Kinser on 05 December 2000 00:58:51 |
 |
|
|
Nam
Starting Member
36 Posts |
Posted - 05 December 2000 : 02:52:57
|
Richard, you're right on that I'm using Chilli ASP but I'm not sure about if I can download file manually. My host created DSN name for me and I linked it in my site as follow:
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE
'#################################################################################
'strDBType = "sqlserver" '## access, sqlserver or mysql
strDBType = "access" '## access, sqlserver or mysql
'strDBType = "mysql" '## access, sqlserver or mysql
' ## Make sure to uncomment one of the strConnString lines !!
strConnString = "DSN=sforum"
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;dsn=sforum;uid=namnet;pwd=*******;database=namnet" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
If I can't add table manually, please tell me the other way and I'll email my host and ask them to change it for me.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 05 December 2000 : 16:44:15
|
I tryed replying to myself and get this error:
Microsoft VBScript runtime errore "800a000d'
Type mismatch: 'rsName'
/audiopro/forum/privatesend_info.asp, riga 278
Don't know if this comes out even trying to reply to someone else PM.. plz lemme know...
I modified the topic.asp so that you can send PM directly when reading posts. It shows the PM icon just right after the e-mail one. It's a bit rough but seems it works LOL!
here it is...
<font color=red><a href="privatesend.asp?method=Topic&mname=<% =rs("M_NAME") %>"><img src="icon_pm.gif" alt="Send private message" border="0" align="absmiddle" hspace="6"></a></font id=red>
<% if strHomepage = "1" then %>
<% if rs("M_Homepage") <> " " then %>
<a href="<% =rs("M_Homepage") %>"><img src="icon_Homepage.gif" height=15 width=15 alt="Visit <% =rs("M_NAME") %>'s Homepage" border="0" align="absmiddle" hspace="6"></a>
<% end if %>
<% end if %>
insert the RED line in TOPIC.ASP (IMPORTANT!!!! You have to insert it in TWO places... there are two almost identical pieces of code in topic.asp. Find them both and insert the line...)
Sorry but I don't have time to get the whole forum code from the start so this is a "survival" mod heheheh try it just one line....
Now I'm modifing the memberlist page too with JS so that you can click on member name and put it directly in SEND TO field.... byez
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it
<font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>
Edited by - Richard Kinser on 24 January 2001 05:00:12 |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 05 December 2000 : 17:15:38
|
I found the problem... the original version doesn't work with NETSCAPE (well with NS my version)... so you have to modify the pm_pop_members.asp this way.. its near the and... you have to add the JS, remove the onclick="...." and add the <a href> tags this way...
<script language="Javascript">
function insertname(nome)
{
opener.document.PostTopic.sendto.value=nome
}
</script>
<td bgcolor="<% =CColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><a href="pop_profile.asp?mode=display&id=<% =rs("MEMBER_ID") %>" target="_new">[b]<% =ChkString(rs("M_NAME"),"display") %></a> <a href="javascript:insertname('<% =ChkString(rs("M_NAME"),"display") %>')"><img src="pm.gif" width="11" height="17" alt="Send Message" border="0" style="cursor:hand"></a></font></td>
About the little topic.asp mod above.. u can use pm_gif instead of icom_pm.gif to be coherent with member list pop up icon option <img src=icon_smile_big.gif border=0 align=middle>...
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it
<font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>
Edited by - Richard Kinser on 24 January 2001 05:00:34 |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 05 December 2000 : 17:34:37
|
Last thing on PM.. hehehe
if the Bbackground color of your PM box Sux (as does mine) and does not let you read well the people on jsut open pm_view.asp and simply REPLACE (even with wordpad) any <font color=red>ccolor</font id=red> with <font color=red>strForumCellColor</font id=red> and you'll be sure to read well.... :)))
Richard I still have (cookies??) problemz with whois showing the right people online... (your mod with shows names directly in the bar).. I wait you www.audiopro.it/forum
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 18:47:26
|
Richard,
I did import the table from :
http://www1.domaindlx.com/dssdbs/files/PM_FORUM.zip
and get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'count(M_TO) pmcount'.
/privatemess.asp, line 50
I have ver.3.1sr2, use access2k db,dns.
Any clue?
Wedont !
Edited by - wedont on 05 December 2000 19:06:16 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 19:22:28
|
I think it needs the following change:
count(M_TO) <font color=red>AS</font id=red> pmcount |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 19:38:38
|
Thanks Richard,
It workED !!! but (eared that before! )
When I send a message I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/privatesend_info.asp, line 79
Hell'p!
Wedont
Edited by - wedont on 05 December 2000 19:53:48 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 19:55:15
|
wedont,
did you run the pmdbsetup.asp file that was included in the .zip file?
Just put it in your <b>/vc_forum</b> directory and run it from the address bar of your browser. This will add 2 data fields to the FORUM_MEMBERS table in your snitz_forums_2000.mdb database. |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 19:57:23
|
Just did, get the following:
ALTER TABLE FORUM_MEMBERS ADD M_PMRECEIVE integer DEFAULT 1 NULL;
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
/pmdbsetup.asp, line 53
Edited by - wedont on 05 December 2000 21:34:17 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 20:20:16
|
You can just add the data fields to your data base manually. Just use the settings in the pmdbsetup.asp as a guide.
I think the problem is the <b>DEFAULT</b> that is in the <b>ALTER TABLE</b> statment. |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 05 December 2000 : 20:30:09
|
I think for access it should be
ALTER TABLE FORUM_MEMBERS ADD <font color=red>COLUMN</font id=red> M_PMRECEIVE integer DEFAULT 1 NULL
<font color=blue>'Resistance is futile'</font id=blue>
You could also try this database_setup.asp
I have been working on it, select the required Mod from the drop down, and hit the button, it should also give you a better error message if something goes wrong.
Edited by - huwr on 05 December 2000 20:33:54 |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 20:38:40
|
Thanks Richard,
So far so good! I really appreciate your help and kindness.
Wedont (richard, in french!)
|
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 20:48:08
|
Thanks HuwR,
Great script, Question: does the
who's on line needs the global.asa and
does it required server variables?
Wedont
|
|
|
|
Topic |
|
Topic Locked
