Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: New Events Calendar for 3.4.03 beta
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 32

MichaelA
Junior Member

USA
222 Posts

Posted - 12 December 2002 :  12:32:20  Show Profile  Reply with Quote
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
<
Go to Top of Page

hmmm
Starting Member

35 Posts

Posted - 12 December 2002 :  14:41:04  Show Profile  Reply with Quote
Is there a way to have the events calendar box on the top of the page instead of at the bottom?<
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 12 December 2002 :  15:50:19  Show Profile  Reply with Quote
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.<
Go to Top of Page

vynsane
New Member

73 Posts

Posted - 12 December 2002 :  19:04:30  Show Profile  Visit vynsane's Homepage  Reply with Quote
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
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 12 December 2002 :  19:34:00  Show Profile  Reply with Quote
Just read the first page or the heading then ... should answer your questions and when you find more time you can read more <
Go to Top of Page

red1
Junior Member

355 Posts

Posted - 12 December 2002 :  21:04:30  Show Profile  Reply with Quote
Yeah this topic is too long now...

The next version will be mainly about fixes on mysql issues. Of course you are still free to make suggestions<

My Mods:
New Events Calendar
New Non-database Active Users
Go to Top of Page

vynsane
New Member

73 Posts

Posted - 13 December 2002 :  12:20:31  Show Profile  Visit vynsane's Homepage  Reply with Quote
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
Go to Top of Page

funinbc
Junior Member

245 Posts

Posted - 14 December 2002 :  22:16:58  Show Profile  Reply with Quote
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?

<
Go to Top of Page

funinbc
Junior Member

245 Posts

Posted - 14 December 2002 :  23:30:31  Show Profile  Reply with Quote
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
Go to Top of Page

funinbc
Junior Member

245 Posts

Posted - 15 December 2002 :  00:01:05  Show Profile  Reply with Quote
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<
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 15 December 2002 :  04:08:13  Show Profile  Reply with Quote
Look for just T_ISEVENT and put a comma after it .... should be in the area of lines 300-333<
Go to Top of Page

funinbc
Junior Member

245 Posts

Posted - 15 December 2002 :  14:41:51  Show Profile  Reply with Quote
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
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 15 December 2002 :  15:37:23  Show Profile  Reply with Quote
Seems like you fixed the problem ? It works fine on my end.<
Go to Top of Page

funinbc
Junior Member

245 Posts

Posted - 15 December 2002 :  15:45:29  Show Profile  Reply with Quote
No I get the error when you click on any of the forum topics

sorry I should have been more clear<
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 15 December 2002 :  16:38:01  Show Profile  Reply with Quote
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)<
Go to Top of Page
Page: of 32 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07