| Author |
 Topic  |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
 Posted - 18 December 2000 : 10:32:34
|
The easiest way to fix this is to change the connectstring that you are using in <b>config.asp</b>
If you change from the one that is labeled for use with Access 97 to the one that is labeled for use with Access 2000, it should work. |
 |
|
|
marcozco
Starting Member
16 Posts |
Posted - 18 December 2000 : 12:09:06
|
It seems to work, but I receive again this error:Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_REPLY.R_DATE FORUM_REPLY.R_MSGICON'.
/public/aspforum/topic.asp, line 285
What could it be?
Thanks Marco
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 12:25:29
|
There should be a comma between FORUM_REPLY.R_DATE & FORUM_REPLY.R_MSGICON
Make sure in the SELECT statement that you have a comma after R_DATE
it should look like this:
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = strSql & strTablePrefix & "REPLY.R_DATE, "
strSql = strSql & strTablePrefix & "REPLY.R_MSGICON "</font id=code></pre id=code></font id=size1>
|
|
|
|
marcozco
Starting Member
16 Posts |
Posted - 18 December 2000 : 12:25:53
|
Ok probably the probles is the differente version.
My one is the last non Beta one...
How can i run this code anyway?
Thanks Marco
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 12:28:39
|
The version of the forum is not what's wrong.
Please see the message I wrote above. |
|
|
|
marcozco
Starting Member
16 Posts |
Posted - 18 December 2000 : 12:40:13
|
I checked and in you for comma intend the "," , it was really missing... at the moment my ftp is down so , hope it 'll be enought.
Thanks a lot
I'll write if it is Ok or not
|
|
|
|
marcozco
Starting Member
16 Posts |
Posted - 18 December 2000 : 12:49:10
|
You are fantastic, now the problem is fixec.
BUT , it seems to work , until you try to write a msg, when i receive the error:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/public/aspforum/post_info.asp, line 527
strSql = strSql & ", " & TF & ")
--------------------------------^
You can see the forum at:
www.reptilia.it and enter as ospite nuovo
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 13:20:09
|
There should be a " to the right of that )
it should look like this:
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = strSql & ", " & TF & ")"</font id=code></pre id=code></font id=size1> |
|
|
|
marcozco
Starting Member
16 Posts |
Posted - 18 December 2000 : 13:22:17
|
Now i put back the forum running, so it's unuseful you look at it ,I'll try again when you 'll give me some ideas...
Thank Marco
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 13:48:08
|
Send me your <b>post_info.asp</b> , <b>post.asp</b> , <b>forum.asp</b> and <b>topic.asp</b> and I'll make the changes for you.
Put all 4 files into a .zip file
Send them to:
richard_kinser@yahoo.com |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 18 December 2000 : 23:29:02
|
I cant seem to get this going on sr3. I had no trouble with it on sr1 final.
Keeps sending back a post.asp error when you try to reply or create a new topic.
Microsoft VBScript compilation error '800a0400'
Expected statement
/post.asp, line 681
<%
^
Do I need to change something to make this mod compatible?
http://www.dunzellsden.com/forum/ |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 23:39:59
|
Looks like you have an extra <pre id=code><font face=courier size=2 id=code><%</font id=code></pre id=code> in there somewhere.
There is nothing new with SR3 that would make this mod incompatible. The line #'s are probably different than the one's mentioned in the readme.txt file though. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 December 2000 : 23:46:23
|
I just installed this in SR3 and yes, if you follow the readme.txt file exactly you will end up with an extra <pre id=code><font face=courier size=2 id=code><%</font id=code></pre id=code> at line #681
Deleting that extra <pre id=code><font face=courier size=2 id=code><%</font id=code></pre id=code> should fix that error. |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Topic |
|
Topic Locked
