| Author |
 Topic  |
|
n/a
deleted
593 Posts |
 Posted - 28 May 2002 : 06:37:57
|
Edit/Delete function - at least Edit - is recovered by commenting out (' added to the beginning of all DIM declarations ) all DIM statements in LangMODS_events.asp
strLang processing of Japanese for mentioned in the previous topic still remains as the problem. Have no clue. Any suggestions?
--
Encoding problem:
When editing an existing event added in Japanese, Edit window event title in Japanese encoding appear corrupted (Encoding conflict - unicode chars not appearing correctly, which indicates encoding setting is not properly adjusted for UTF-8, which FORUM is set to).
=> This problem was fixed by adding meta statement setting to utf-8 in events.asp. It looks ok now.
---
Event Delete Function:
This is not working. View by Week>(Select a Date)>Event for a Day>Delete, and the following error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/i2asia/forum/events_functions.asp, line 316
line 316 in events_functions.asp is supposedly rs.Open ssql, my_Conn, below:
dim rs
set rs = server.CreateObject("adodb.recordset")
rs.Open ssql, my_Conn
%>
>>Is there some database conflit here? My Forum db is Access2000 on Brinkster, and events.dbs is sitting in /i2Asia/Forum/ directory...
Me no clue here.
--
Additional No Locale Lang statements:
*A message after Edit an Event is done, "Thank you...." also appears in English...
>>>I am not sure but seems like translated langstrings not mapping correctly - some disconnect in programs?
--
Thanks
Taku
Edited by - LeoRat on 28 May 2002 07:14:00< |
 |
|
|
Deleted
deleted
4116 Posts |
Posted - 28 May 2002 : 07:00:21
|
quote:
I belive I know why this is. I see LangMODS_Events.asp is nested in Events.asp with INCLUDE, where Events.asp is linked to a inc_top.asp top menu item... So, I assume that having LangMODS_Events.asp in Config.asp is creating duplication... Maybe this is also because Events Calender was designed as a standalone mod originally as well...???
This is one of the resons I call it "large scale mod" and advice to keep the strings in separate files. If they are stand alone, they will have separate asp pages, so the language file will only be included there. If you show the calendar on default.asp, then also include it there. This way you will prevent execution of hundreds of lines in unrelated pages.
The only problem left here will be a link at the top menu (inc_top.asp), but you can just add them
quote:
(5) Login as Admin, select "events" in Top menu link, and can open EventsCalender Monthly page. Now top left directory shows correctly in Japanese. Some prompts/links in Events Calender are in Japanese, but month/year, etc. are remaining in English.
The date-month related issues can only be solved with vb4b04+...
quote:
[red] Am not yet clear why some of langstrings showing correctly and some are not showing at all...Does this to do with DIM declaration? Or some links among modules not properly set? I haven't try commenting out DIM stuff totally...
Exactly ! See the following code examples:
DIM strTest
sub TestSub
strTest = "TestSub"
end sub
call TestSub()
response.write strTest
Will print "TestSub".
sub TestSub
strTest = "TestSub"
end sub
call TestSub()
response.write strTest
Will print an empty string. This is because strTest will be a local variable. So we need to DIM all global vars that are modified in subs/functions. This is also good for performance.
I didn't test the above code. I may be wrong.
Taku, sorry I dealt with it more than a year ago. I don't want to go into this before v4b04 is stable.
Think Pink
==> Start Internationalization Here< |
|
|
|
n/a
deleted
593 Posts |
Posted - 28 May 2002 : 07:27:36
|
Bozden,
Thanks for your further comment...just posted a revised post above.
I can live with this as is...not a big deal right now, although would like to see all langstrings properly processed to show UI etc all in respective locale lang, my immediate case: JA. I see this MOD really needs some re-design to handle internationalized Snitz enviornment....and this effort of "interim fix" may not be a good idea as V4x itself is going through some basic architectural change... Anyway, it's quite a learning experience...but this is not totally a bad case.
I understand your point well, as I see the whole MOD architecture issue here, and you know my perspective on this issue in general.
Will give some rest to this for now.
Taku
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 28 May 2002 : 07:55:36
|
I plan to use this as a testbed for date-time functions in v4. When this time comes ( ) we will be working together, as Japanese is a very good special case - this if you like to colloborate of course .
As 99% of the strings will be the same as v2sr1, your work you are doing is very useful - although you cannot get Japanese date/time with it unfortunately...
The last error you posted above needs the sql to be examined. Print it with:
response.write sSql
response.end
Put these just before line 316, rerun, and post here.
Think Pink
==> Start Internationalization Here< |
|
|
|
n/a
deleted
593 Posts |
Posted - 28 May 2002 : 08:52:08
|
quote:
The last error you posted above needs the sql to be examined. Print it with:
response.write sSql
response.end
Put these just before line 316, rerun, and post here.
Think Pink
==> Start Internationalization Here
Woops, this is what happened after I added the above 2 lines above line 316 in events_functions.asp and click "Events" in Top right menu link... doesn't even open up a monthly calender,etc. but shows the below in the window.
SELECT event_id, start_date, end_date, event_title, PRIVATE, M_NAME, event_details FROM FORUM_EVENTS Inner JOIN FORUM_Members ON FORUM_EVENTS.added_by = FORUM_Members.Member_ID WHERE (Start_Date >='20020501000000' AND Start_Date <= '20020531000000') OR (End_Date >='20020501000000' AND End_Date <= '20020531000000') OR (Start_Date < '20020501000000' AND End_Date > '20020531000000' )ORDER BY Start_Date
---
EventsCalender uses its own DB, correct? If so, is there a possible DB compatibility issue vs. Forum DB (again, my case it's Brinkster and Access 2000)...
--
Anyway, resetting it back.
Taku
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 28 May 2002 : 09:33:33
|
a couple of lines above that, find the ORDER BY clause, and put a space in front of it. It can be something like this:
ssql = ssql & " ORDER BY " & ...
No, it is not a database or locale issue I think. It keeps & queries the dates in the forums special string format. Problem can arise while coberting these. Try to insert an event, then look into the database to see how it is kept.
Think Pink
==> Start Internationalization Here< |
|
|
|
n/a
deleted
593 Posts |
Posted - 28 May 2002 : 16:12:27
|
quote:
a couple of lines above that, find the ORDER BY clause, and put a space in front of it. It can be something like this:
ssql = ssql & " ORDER BY " & ...
"ORDER BY" is at ln312 in the ssql statement block starting at ln306 shown below. I added a space before "ORDER BY..." statement, if that what you mean.
-----
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE, " & strDBNTSQLName & ", event_details FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strMemberTablePrefix & "Members.Member_ID WHERE " & _
"(Start_Date >='" & dFirstDay & "' AND Start_Date <= '" & dLastDay & "') " & _
"OR " & _
"(End_Date >='" & dFirstDay & "' AND End_Date <= '" & dLastDay & "') " & _
"OR " & _
"(Start_Date < '" & dFirstDay & "' AND End_Date > '" & dLastDay & "' )" & _
"ORDER BY Start_Date"
dim rs
set rs = server.CreateObject("adodb.recordset")
rs.Open ssql, my_Conn
----
RESULTS
Events Calender showed up all right. However, DELETE function is not working (totally null). I went to Event of a Day screen and tried to delete it (click "TRASH" icon) and it flicked and refreshed with the same screen: Nothing happened (at least no ERROR message like before).
EDIT function works fine.
A minor irritating item: It's random but when DELETE, EDIT or browser REFRESH is done, a flicker of Database error message temporarily show up. When go to View by Month main calender (top page), editing or change reflected correctly show up...
You can check it at
http://www26.brinkster.com/i2asia/forum/events.asp?date=5/28/2002 You should be able to get in - Events Calender set for "Moderators and Admin Only" and you are set to "Moderator".
Question: Was re-reading a post on "MonthNames"...naming conventions for intl - intMonthName instead of MonthName (in inc_functions.asp) were discussed...how much of these reflected in Events Calender... I see events_functions.asp contain lots of month/date statements containing intThisDay, intThisMonth type. Are MonthNames compatible with EventsCalender V2rs1 Intl (Alpha)??? If both installed, possible conflicts of some sort?
Taku
Edited by - LeoRat on 28 May 2002 16:21:29
Edited by - LeoRat on 28 May 2002 16:54:31< |
|
|
|
n/a
deleted
593 Posts |
Posted - 31 May 2002 : 05:04:12
|
DIM issue is somehow resolved. I don't know why but I basically divided a line into
DIM strAllForums
and the rest starting with a new DIM for the first line and removed also ' (comment out) from all other DIM declarations.... no more errors... and it's back.
I am looking at events_functions, events_inc, pop_event... and trying to understand why I cannot put "<% =strAddEvent %>" to "Add a New Event", for example... which appear to place a string in a proper place and call for whatever a translated lang string corresponding to it, correct? There are some lang strings in all of these files but majority of them are in events_functions, especially dealing with those not showing up in Japanese.... Am not quite how all these are associated and how they are tied to LangMODS_events.asp and LangMODS_EventsNNNN.asp... Further advise on this? Maybe something basic that I am missing to understand? I am not concerned with date format/expression so much right now....but trying to see how whole EventsCalender UI enviornment can be in JA, for example. Other than that, adding event in Japanese, Chinese, etc. is not a problem per se..
Taku
i2Asia <>||TestingOut Multilingo Snitz||<>< |
|
|
|
Topic |
|
|
|
Forum Locked
