Author |
Topic |
MichaelA
Junior Member
USA
222 Posts |
Posted - 12 December 2002 : 12:32:20
|
Does anyone have any idea what is up in the next release and if the author is open for suggestions (a wish list)? I could not find where he mentions a next release in this message thread. Is he already working on it or is this a way out future release.
Thanks.
Mike < |
|
|
hmmm
Starting Member
35 Posts |
Posted - 12 December 2002 : 14:41:04
|
Is there a way to have the events calendar box on the top of the page instead of at the bottom?< |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 December 2002 : 15:50:19
|
hmmm, this was covered the other day in another topic about the Events MOD, do a search, I know I entered something about the include statement.< |
|
|
vynsane
New Member
73 Posts |
Posted - 12 December 2002 : 19:04:30
|
just curious and don't have the time to read through 11 pages... will this work with 3.4.01? i have a few mods with that version, don't want to upgrade just yet, and would really like to use this mod... any suggestions?< |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 December 2002 : 19:34:00
|
Just read the first page or the heading then ... should answer your questions and when you find more time you can read more < |
|
|
red1
Junior Member
355 Posts |
|
vynsane
New Member
73 Posts |
Posted - 13 December 2002 : 12:20:31
|
quote: Originally posted by laser
Just read the first page or the heading then ... should answer your questions and when you find more time you can read more
well, i did have enough time to read the first couple of pages and i "Ctrl-F"ed for "3.4.01" on every page, and didn't find anything except my post... i realize the topic says "for 3.4.03" - BUT that doesn't necessarily mean it ONLY works with .03, nor does it mean it WILL work with .01, so...
can it work with .01? are the changes to existing files compatible, or are the existing files too different from version .01 to .03? i might just try to wing it... i've got aranae, so i can find stuff that needs changing easily enough... i guess we shall have to wait and see...< |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
|
|
funinbc
Junior Member
245 Posts |
Posted - 14 December 2002 : 22:16:58
|
There I was all proud of myself after testing the new Event mod and everything was working fine........ that was until I tried to read the post. This is the error msg I get
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'T.T_ISEVENT T.T_LAST_POST_REPLY_ID'.
/funforum/forum.asp, line 333
Do you have any ideas what I am doing wrong?
< |
|
|
funinbc
Junior Member
245 Posts |
Posted - 14 December 2002 : 23:30:31
|
On line 333 of forum.asp (in red)
set rs = Server.CreateObject("ADODB.Recordset") rs.cachesize = strPageSize rs.open strSql & strSql2 & strSql3 & strSql4,
my_Conn, adOpenStatic if not rs.EOF then< |
Edited by - funinbc on 14 December 2002 23:32:13 |
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 00:01:05
|
The funny thing is I looked for the error
'T.T_ISEVENT T.T_LAST_POST_REPLY_ID'
in all the changed files but it was not there< |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 04:08:13
|
Look for just T_ISEVENT and put a comma after it .... should be in the area of lines 300-333< |
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 14:41:51
|
Thanks but that did'nt help. I think the problem has somthing to do with Fourm.asp I must have gone over this ten times. this is what I found out
in the readme it says:
* On line 238 find this: strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, "
* Create a blank line below it and insert this: strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME,T.T_ISEVENT "
now the un-moded forum.asp it reads
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "
I am confused Red1's changed file that he includes if needed it reads:
T.T_LAST_POST, T.T_LAST_POST_AUTHOR, " strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME " strSql = strSql & ", T.T_ISEVENT "
this is different then the readme.
This is the changed file in MY forum.asp
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME " strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, T.T_ISEVENT "
I am still getting the error:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/funforum/forum.asp, line 333
If this helps my website is :
http://www.funinbc.com/funforum/default.asp
and the forum.asp is at :
http://www.funinbc.com/temp/forum.txt
< |
Edited by - funinbc on 15 December 2002 15:43:02 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 15:37:23
|
Seems like you fixed the problem ? It works fine on my end.< |
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 15:45:29
|
No I get the error when you click on any of the forum topics
sorry I should have been more clear< |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 16:38:01
|
Oops, sorry about that
OK, try this .... (it's debugging, no fix yet)
Just before line 333 insert these and paste the output here :
Response.Write("strSql: " & strSql) Response.Write("strSql2: " & strSql2) Response.Write("strSql3: " & strSql3) Response.Write("strSql4: " & strSql4)< |
|
|
Topic |
|