Author |
Topic  |
SuTech
Starting Member
USA
23 Posts |
Posted - 12 January 2001 : 17:16:48
|
Hopper gave the fix on the 2 page of this topic, so I will quote Hopper. I made the change and it now works correctly on my site.
quote:
The problem is simple.
change lines 'if not(memberErased) then Response.Write " - Added by " & authorname 'end if%>
to:
if not(memberErased) then Response.Write " - Added by " & RS("M_Name") else Response.Write " - Added by Deleted User" end if%>
|
 |
|
CrAzY
New Member

USA
50 Posts |
Posted - 12 January 2001 : 19:39:13
|
quote:
Crazy, Do you have any events in the calendar? If not, that's why you're getting the error. Try inserting one manually via the Enterprise Manager. Then you won't get that error. If you cannot, you can do something like this:
if memberid = "" then Response.redirect "register.asp" Response.end end if
The problem I think is that you're not getting the cookie and it's not necessarily the "recordset". It's just grabbing the username and associating it with an "ID". If the user doesn't have cookies on, they can't see it :( Also, if the user isn't registered, they shouldn't be able to see the calendar either.
What version are you using?
Cheers, Tim
http://www.free-guestbook.com
I'm using SR4.
And adding a record into the DB manually didn't do the trick. I'm testing this out under my own login and I can do everything else on the board, I just can't add an event.
I still receive the same error, and I if attempt to redirect to the register page it doesn't even check to see if I'm logged in, it just pitches me there no matter what.
« Nokturnal.Net » Seize The Night
|
 |
|
davea
New Member

61 Posts |
Posted - 12 January 2001 : 21:23:40
|
quote:
quote:
I've figured out the error I was getting:
Replace around line 490 in the events.asp file with the one below:
sSql = "Select Member_ID from Forum_Members where M_Name = '" & Request.Cookies(strCookieURL & "User")("Name") & "'"
Thanks.
Cheers, Tim
http://www.free-guestbook.com
Yeah this was made for snitz3.1 sr 4 so the cookies are handled different. If you use an earlier version. Tim's change above should be the only thing.
im getting this one myself, this change does nothing but stop the page loading at all. i am on 3.1 Service Release 2, any fix or do i need to upgrade, and if i do upgrade from there what will i lose on my forum? :)
|
 |
|
Dynamix
Junior Member
 
Germany
205 Posts |
Posted - 13 January 2001 : 12:44:09
|
Is here anyone, woho has a complete mod of this feature for the 3.1 Final?
|
 |
|
concep86
Junior Member
 
USA
140 Posts |
Posted - 13 January 2001 : 14:19:13
|
I am also getting this error running sr2.
I read the post above and added an event manually into the db... but get the same message editing or adding an event...
I see it maybe cookie related... But I don't know how to fix it...
Any thoughts.
Thanks
_______________________________
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
/snitz/events.asp, line 493
|
 |
|
concep86
Junior Member
 
USA
140 Posts |
Posted - 13 January 2001 : 14:31:18
|
I am implementing snitz on a spanish web site... What do I need to change so that the months read in spanish
January = Enero
etc
|
 |
|
frankie
Junior Member
 
Vatican City
304 Posts |
Posted - 13 January 2001 : 15:49:16
|
Thanks AznKnight,
Take a look at This. 
ô¿~
Edited by - frankie on 21 January 2001 02:33:08 |
 |
|
wedont
Junior Member
 
Canada
344 Posts |
Posted - 13 January 2001 : 15:59:52
|
Very nice Frankie,
That got to be the nicest broken link have seen lately, congratulation, you're the best !!!
Wedont snitz ver3.1 sr2 access 2k. |
 |
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 13 January 2001 : 17:10:30
|
quote:
Is here anyone, woho has a complete mod of this feature for the 3.1 Final?
Sorry Dynamix and Concept but this mod is not backwards compatible. The way cookies are handled has been changed in sr4 differently than how it was in the earlier version. The bof or eof error is probably because the page can't read the user's cookie. |
 |
|
frankie
Junior Member
 
Vatican City
304 Posts |
Posted - 13 January 2001 : 17:18:12
|
quote:
Very nice Frankie,
That got to be the nicest broken link have seen lately, congratulation, you're the best !!!
Wedont snitz ver3.1 sr2 access 2k.
Darn, cfm-resources did it to me again. I swear man, that server doesn't stay up more than an hour aday..gee ! 
ô¿~ |
 |
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 13 January 2001 : 17:42:25
|
quote:
I am implementing snitz on a spanish web site... What do I need to change so that the months read in spanish
January = Enero etc
The month name is displayed from this string varible.
strMonthName = MonthName(intThisMonth)
The Monthname function is builtin vbscript function that returns the name of the month from an integer. 1= january, etc..
I rewrote that function so that it does it literally instead of using builtin monthname which is in english. This will return the name in spanish...others who want it to return it in their language can use this to.
function monthName2(intMonth) if (intMonth = 1) then monthName2 = "Enero" if (intMonth = 2) then monthName2 = "Febrero" if (intMonth = 3) then monthName2 = "Marzo" if (intMonth = 4) then monthName2 = "Abril" if (intMonth = 5) then monthName2 = "Mayo" if (intMonth = 6) then monthName2 = "Junio" if (intMonth = 7) then monthName2 = "Julio" if (intMonth = 8) then monthName2 = "Agosto" if (intMonth = 9) then monthName2 = "Septiembre" if (intMonth = 10) then monthName2 = "Octubre" if (intMonth = 11) then monthName2 = "Noviembre" if (intMonth = 12) then monthName2 = "Diciembre" end function
Add this to the end of the events page and change some of the MonthName(intThisMonth) function calls to MonthName2(intthisMonth).
I did this for ya on updated events.asp page: eventsSpanish.asp
Copy and paste from the file above and rename it to events.asp.
Here's test of it: http://www.calvsa.net/snitz31sr4/events3.asp
This will only display the month in spanish for the full calendar. Might also need to rewrite manual formatdatetime function.
Edited by - aznknight on 13 January 2001 17:50:13 |
 |
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 13 January 2001 : 17:57:17
|
quote:
Thanks AznKnight,
Take a look at This. 
ô¿~
cfm is actually up..you just mispelled the file, mising s in events.asp.
corrected link of your calendar: http://www.cfm-resources.com/f/frankmania/events.asp
Very nice job applying this mod . Glad you were able to easily change it to fit your design colors and all. Didn't know that it'll look so good in dark blue and white =). Maybe that's just one of my fav color combo . I also like your usage of styles sheets.
one thing though, the ie transition filters does make it seem slow. Might want to change the rate that it filter to someone faster.
- Alan alan@calvsa.net www.calvsa.net
Edited by - aznknight on 13 January 2001 18:00:29 |
 |
|
concep86
Junior Member
 
USA
140 Posts |
Posted - 13 January 2001 : 19:37:25
|
Thanks for the spanish months stuff, Aznknight.
I do not know ... at this opoint since I modified all the files in my sr2 build whether I will upgrade to sr4.
that is up in the air.... the translations took quite a bit of time...
Thanks...
|
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 13 January 2001 : 21:35:25
|
frankie,
I like how you did the events.asp colors. I've tried on mine and can't get the colors just right. Could you e-mail me your events.asp file? |
 |
|
KXS
New Member

Canada
66 Posts |
Posted - 14 January 2001 : 07:55:32
|
quote:
Crazy, Do you have any events in the calendar? If not, that's why you're getting the error. Try inserting one manually via the Enterprise Manager. Then you won't get that error. If you cannot, you can do something like this:
if memberid = "" then Response.redirect "register.asp" Response.end end if
The problem I think is that you're not getting the cookie and it's not necessarily the "recordset". It's just grabbing the username and associating it with an "ID". If the user doesn't have cookies on, they can't see it :( Also, if the user isn't registered, they shouldn't be able to see the calendar either.
What version are you using?
Tim,
I have the identical problem that Crazy has, I'm using Snitz Forums 2000 Version 3.1 SR4. I tried to add some events and that didn't resolve the issue. I still have 2 ads in my mssql database, but I can't view them in my calendar view.
By the way, when I created a table by using your eventstablesetup.asp it created my event_details column with a value length as 1. I don't know why that did that, but I changed ...
Any suggestions bro?
------------------ "keeping it real" |
 |
|
Topic  |
|