Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.136.2.30 -r1.136.2.31 --- openacs-4/packages/acs-kernel/acs-kernel.info 24 Mar 2017 14:14:36 -0000 1.136.2.30 +++ openacs-4/packages/acs-kernel/acs-kernel.info 21 Apr 2017 15:59:20 -0000 1.136.2.31 @@ -48,7 +48,7 @@ - + Index: openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql,v diff -u -r1.12 -r1.12.6.1 --- openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql 7 Mar 2011 02:34:51 -0000 1.12 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql 21 Apr 2017 15:59:20 -0000 1.12.6.1 @@ -1,7 +1,7 @@ -- -- acs-kernel/sql/acs-metadata-create.sql -- --- A generic metadata system that allows table inheritence. This is +-- A generic metadata system that allows table inheritance. This is -- based in many ways on Problem Set 4 by Philip Greenspun -- (philg@mit.edu), and the user-groups data model by Tracy Adams -- (teadams@mit.edu). @@ -867,7 +867,7 @@ -- Add the appropriate column to the table -- We can only create the table column if - -- 1. the attribute is declared type_specific (generic storage uses an auxillary table) + -- 1. the attribute is declared type_specific (generic storage uses an auxiliary table) -- 2. the attribute is not declared static -- 3. it does not already exist in the table Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v diff -u -r1.25 -r1.25.6.1 --- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 17 Oct 2010 21:06:08 -0000 1.25 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 21 Apr 2017 15:59:20 -0000 1.25.6.1 @@ -461,7 +461,7 @@ ) return acs_objects.package_id%TYPE; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -521,7 +521,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -804,7 +804,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -971,7 +971,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -1021,7 +1021,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -1086,7 +1086,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v diff -u -r1.54 -r1.54.6.1 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 17 Oct 2010 21:06:08 -0000 1.54 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 21 Apr 2017 15:59:20 -0000 1.54.6.1 @@ -143,11 +143,11 @@ -- create bitmap index apm_packages_package_key_idx on apm_packages (package_key); create index apm_packages_package_key_idx on apm_packages (package_key); --- This cant be added at table create time since acs_objects is created before apm_packages; +-- This can't be added at table create time since acs_objects is created before apm_packages; alter table acs_objects add constraint acs_objects_package_id_fk foreign key (package_id) references apm_packages(package_id) on delete set null; comment on table apm_packages is ' - This table maintains the list of all package instances in the sytem. + This table maintains the list of all package instances in the system. '; comment on column apm_packages.instance_name is ' @@ -515,7 +515,7 @@ values are given by the Tcl proc apm_supported_callback_types. '; --- Ths view faciliates accessing information about package versions by joining +-- Ths view facilitates accessing information about package versions by joining -- the apm_package_types information and acs_object_types information (which is -- invariant across versions) with the specific version information. Index: openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql,v diff -u -r1.12.10.1 -r1.12.10.2 --- openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql 31 Aug 2016 18:57:41 -0000 1.12.10.1 +++ openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql 21 Apr 2017 15:59:20 -0000 1.12.10.2 @@ -314,7 +314,7 @@ as select distinct group_id, member_id from group_approved_member_map; --- some more views, like party_memeber_map and party_approved_member_map, +-- some more views, like party_member_map and party_approved_member_map, -- are created in rel-segments-create.sql -- Just in case someone is still querying the group_component_index and @@ -391,7 +391,7 @@ --------------------------------------------- --- POPULATE DATA FOR PERMISSABLE REL TYPES -- +-- POPULATE DATA FOR PERMISSIBLE REL TYPES -- --------------------------------------------- -- define standard types for groups of type 'group' Index: openacs-4/packages/acs-kernel/sql/oracle/test/rel-constraints-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/test/rel-constraints-test.sql,v diff -u -r1.2 -r1.2.24.1 --- openacs-4/packages/acs-kernel/sql/oracle/test/rel-constraints-test.sql 30 Sep 2003 12:10:02 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/test/rel-constraints-test.sql 21 Apr 2017 15:59:20 -0000 1.2.24.1 @@ -272,7 +272,7 @@ rel_constraint.del(side_one_constraint); rel_constraint.del(side_two_constraint); - -- Remove the test memebership relations + -- Remove the test membership relations for r in (select * from blah_member_rels) loop blah_member_rel.del(r.rel_id); end loop; Index: openacs-4/packages/acs-kernel/sql/oracle/test/rel-segments-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/test/rel-segments-test.sql,v diff -u -r1.2 -r1.2.24.1 --- openacs-4/packages/acs-kernel/sql/oracle/test/rel-segments-test.sql 30 Sep 2003 12:10:02 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/test/rel-segments-test.sql 21 Apr 2017 15:59:20 -0000 1.2.24.1 @@ -222,7 +222,7 @@ acs_rel_segment.del(seg_E_yippes); acs_rel_segment.del(acs_rel_segment.get(F,'membership_rel')); - -- Remove the test memebership relations + -- Remove the test membership relations for r in (select * from blah_member_rels) loop blah_member_rel.del(r.rel_id); end loop; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0.1-4.1b.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0.1-4.1b.sql,v diff -u -r1.2 -r1.2.30.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0.1-4.1b.sql 11 Aug 2001 21:31:03 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0.1-4.1b.sql 21 Apr 2017 15:59:20 -0000 1.2.30.1 @@ -1162,7 +1162,7 @@ -- Question: Given relation :rel_id -- -- If we were to remove the relation specified by rel_id, --- what constraints would be violated and by waht parties? +-- what constraints would be violated and by what parties? -- -- Answer: select r.rel_id, r.constraint_id, r.constraint_name -- acs_object_type.pretty_name(r.rel_type) as rel_type_pretty_name, Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql,v diff -u -r1.2 -r1.2.24.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 30 Nov 2002 17:19:07 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql 21 Apr 2017 15:59:20 -0000 1.2.24.1 @@ -59,7 +59,7 @@ ) return varchar2; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -117,7 +117,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -339,7 +339,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -506,7 +506,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -556,7 +556,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -621,7 +621,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1d1.sql,v diff -u -r1.1 -r1.1.18.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1d1.sql 26 Feb 2005 19:48:54 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1d1.sql 21 Apr 2017 15:59:20 -0000 1.1.18.1 @@ -37,7 +37,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -269,7 +269,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -436,7 +436,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -486,7 +486,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -551,7 +551,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql,v diff -u -r1.2 -r1.2.24.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql 28 Aug 2003 09:41:38 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql 21 Apr 2017 15:59:20 -0000 1.2.24.1 @@ -32,7 +32,7 @@ ) return varchar2; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -92,7 +92,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -324,7 +324,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -491,7 +491,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -541,7 +541,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -606,7 +606,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql,v diff -u -r1.2 -r1.2.18.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql 15 Jun 2004 16:25:48 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql 21 Apr 2017 15:59:20 -0000 1.2.18.1 @@ -22,7 +22,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -257,7 +257,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -424,7 +424,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -474,7 +474,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -539,7 +539,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql,v diff -u -r1.10 -r1.10.22.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql 26 Jan 2004 15:39:45 -0000 1.10 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql 21 Apr 2017 15:59:20 -0000 1.10.22.1 @@ -39,7 +39,7 @@ ) return varchar2; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -100,7 +100,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -332,7 +332,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -499,7 +499,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -549,7 +549,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -614,7 +614,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql,v diff -u -r1.3 -r1.3.22.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql 26 Jan 2004 15:39:45 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql 21 Apr 2017 15:59:20 -0000 1.3.22.1 @@ -52,7 +52,7 @@ ) return varchar2; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -112,7 +112,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -344,7 +344,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -511,7 +511,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -561,7 +561,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -626,7 +626,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql,v diff -u -r1.2 -r1.2.18.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql 24 Feb 2005 13:33:01 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql 21 Apr 2017 15:59:20 -0000 1.2.18.1 @@ -33,7 +33,7 @@ ) return varchar2; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -93,7 +93,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -336,7 +336,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -503,7 +503,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -553,7 +553,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -618,7 +618,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql,v diff -u -r1.3 -r1.3.14.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql 4 Jun 2006 00:45:38 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql 21 Apr 2017 15:59:20 -0000 1.3.14.1 @@ -181,7 +181,7 @@ ) return acs_objects.package_id%TYPE; -- Determine where the attribute is stored and what sql needs to be - -- in the where clause to retreive it + -- in the where clause to retrieve it -- Used in get_attribute and set_attribute procedure get_attribute_storage ( object_id_in in acs_objects.object_id%TYPE, @@ -241,7 +241,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -524,7 +524,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -691,7 +691,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -741,7 +741,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -806,7 +806,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql,v diff -u -r1.2 -r1.2.14.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql 4 Jun 2006 00:45:38 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.1d1-5.2.1d2.sql 21 Apr 2017 15:59:20 -0000 1.2.14.1 @@ -320,7 +320,7 @@ and a.storage = 'generic' and a.static_p = 'f'; - -- Retreive type for static attributes + -- Retrieve type for static attributes select object_type into v_object_type from acs_objects where object_id = initialize_attributes.object_id; @@ -603,7 +603,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -770,7 +770,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn''t -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID''s children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -820,7 +820,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. @@ -885,7 +885,7 @@ object_id || '.'); -- If this fails then there isn''t even an object associated with - -- this id. I'm going to let that error propogate as an exception. + -- this id. I'm going to let that error propagate as an exception. select object_type into object_type from acs_objects where object_id = check_representation.object_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d6-5.7.0d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d6-5.7.0d7.sql,v diff -u -r1.3 -r1.3.6.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d6-5.7.0d7.sql 7 Mar 2011 02:34:51 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d6-5.7.0d7.sql 21 Apr 2017 15:59:20 -0000 1.3.6.1 @@ -547,7 +547,7 @@ -- Add the appropriate column to the table -- We can only create the table column if - -- 1. the attribute is declared type_specific (generic storage uses an auxillary table) + -- 1. the attribute is declared type_specific (generic storage uses an auxiliary table) -- 2. the attribute is not declared static -- 3. it does not already exist in the table Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v diff -u -r1.43.2.1 -r1.43.2.2 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 1 Jul 2016 08:57:55 -0000 1.43.2.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 21 Apr 2017 15:59:20 -0000 1.43.2.2 @@ -1,7 +1,7 @@ -- -- acs-kernel/sql/acs-metadata-create.sql -- --- A generic metadata system that allows table inheritence. This is +-- A generic metadata system that allows table inheritance. This is -- based in many ways on Problem Set 4 by Philip Greenspun -- (philg@mit.edu), and the user-groups data model by Tracy Adams -- (teadams@mit.edu). @@ -960,7 +960,7 @@ -- Add the appropriate column to the table -- We can only create the table column if - -- 1. the attribute is declared type_specific (generic storage uses an auxillary table) + -- 1. the attribute is declared type_specific (generic storage uses an auxiliary table) -- 2. the attribute is not declared static -- 3. it does not already exist in the table Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v diff -u -r1.67.2.3 -r1.67.2.4 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 31 Aug 2016 18:19:22 -0000 1.67.2.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 21 Apr 2017 15:59:20 -0000 1.67.2.4 @@ -291,7 +291,7 @@ -- show errors comment on table acs_objects is ' -The root table for the acs object heirarchy. It all starts here folks. +The root table for the acs object hierarchy. It all starts here folks. '; comment on column acs_objects.context_id is $$ @@ -1070,7 +1070,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = 'f' then select @@ -1381,7 +1381,7 @@ -- index contains each ancestor for OBJECT_ID. It doesn't -- guarantee that there aren''t extraneous rows or that -- OBJECT_ID's children are contained in the index. That is - -- verified by seperate functions. + -- verified by separate functions. result := 't'; @@ -1451,7 +1451,7 @@ -- N_GENERATIONS is how far the current DESCENDANT_ID is from -- OBJECT_ID. - -- This function will verfy that each actualy descendant of + -- This function will verfy that each actually descendant of -- OBJECT_ID has a row in the index table. It does not check that -- there aren't extraneous rows or that the ancestors of OBJECT_ID -- are maintained correctly. Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v diff -u -r1.39.2.7 -r1.39.2.8 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 9 Sep 2016 07:56:45 -0000 1.39.2.7 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 21 Apr 2017 15:59:20 -0000 1.39.2.8 @@ -464,7 +464,7 @@ -- This table acts as a mutex for inserts/deletes from acs_permissions. -- This is used since postgresql's exception handing mechanism is non- --- existant. A dup insert on acs_permissions will roll-back the +-- existent. A dup insert on acs_permissions will roll-back the -- transaction and give an error, which is not what we want. Using a -- separate table for locking allows us exclusive access for -- inserts/deletes, but does not block readers. That way we don't Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -r1.75.4.1 -r1.75.4.2 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 31 Aug 2016 18:19:22 -0000 1.75.4.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 21 Apr 2017 15:59:20 -0000 1.75.4.2 @@ -175,11 +175,11 @@ create index apm_packages_package_key_idx on apm_packages (package_key); --- This cant be added at table create time since acs_objects is created before apm_packages; +-- This can't be added at table create time since acs_objects is created before apm_packages; alter table acs_objects add constraint acs_objects_package_id_fk foreign key (package_id) references apm_packages(package_id) on delete set null; comment on table apm_packages is ' - This table maintains the list of all package instances in the sytem. + This table maintains the list of all package instances in the system. '; comment on column apm_packages.instance_name is ' @@ -669,7 +669,7 @@ values are given by the Tcl proc apm_supported_callback_types. '; --- Ths view faciliates accessing information about package versions by joining +-- Ths view facilitates accessing information about package versions by joining -- the apm_package_types information and acs_object_types information (which is -- invariant across versions) with the specific version information. Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql,v diff -u -r1.28.4.2 -r1.28.4.3 --- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql 31 Aug 2016 18:57:41 -0000 1.28.4.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql 21 Apr 2017 15:59:20 -0000 1.28.4.3 @@ -358,7 +358,7 @@ as select distinct group_id, member_id from group_approved_member_map; --- some more views, like party_memeber_map and party_approved_member_map, +-- some more views, like party_member_map and party_approved_member_map, -- are created in rel-segments-create.sql -- Just in case someone is still querying the group_component_index and @@ -478,7 +478,7 @@ --------------------------------------------- --- POPULATE DATA FOR PERMISSABLE REL TYPES -- +-- POPULATE DATA FOR PERMISSIBLE REL TYPES -- --------------------------------------------- -- define standard types for groups of type 'group' Index: openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql,v diff -u -r1.48.2.5 -r1.48.2.6 --- openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql 31 Aug 2016 18:57:41 -0000 1.48.2.5 +++ openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql 21 Apr 2017 15:59:20 -0000 1.48.2.6 @@ -947,7 +947,7 @@ -- PG version checking helper -- vguerra@wu.ac.at --- This helper function indicates wether the current version of PG +-- This helper function indicates whether the current version of PG -- one runs on is greater than, less than or equal to a given version, -- returning 1 , -1 or 0 correspondingly. Index: openacs-4/packages/acs-kernel/sql/postgresql/test/rel-constraints-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/test/rel-constraints-test.sql,v diff -u -r1.5 -r1.5.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/test/rel-constraints-test.sql 7 Jul 2011 10:46:02 -0000 1.5 +++ openacs-4/packages/acs-kernel/sql/postgresql/test/rel-constraints-test.sql 21 Apr 2017 15:59:20 -0000 1.5.4.1 @@ -511,7 +511,7 @@ PERFORM rel_constraint__delete(side_one_constraint); PERFORM rel_constraint__delete(side_two_constraint); - -- Remove the test memebership relations + -- Remove the test membership relations for r in select * from blah_member_rels LOOP PERFORM blah_member_rel__delete(r.rel_id); end loop; Index: openacs-4/packages/acs-kernel/sql/postgresql/test/rel-segments-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/test/rel-segments-test.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/test/rel-segments-test.sql 7 Jul 2011 10:46:02 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/test/rel-segments-test.sql 21 Apr 2017 15:59:20 -0000 1.4.4.1 @@ -365,7 +365,7 @@ PERFORM rel_segment__delete(seg_E_yippies); PERFORM rel_segment__delete(rel_segment__get(F,'membership_rel')); - -- Remove the test memebership relations + -- Remove the test membership relations for r in select * from blah_member_rels LOOP PERFORM blah_member_rel__delete(r.rel_id); end loop; Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql,v diff -u -r1.6 -r1.6.10.1 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql 11 May 2008 10:07:10 -0000 1.6 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql 21 Apr 2017 15:59:20 -0000 1.6.10.1 @@ -373,7 +373,7 @@ end if; else - -- Specific attribute: table name/column need to be retreived + -- Specific attribute: table name/column need to be retrieved if v_static = ''f'' then select Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d10-5.7.0d11.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d10-5.7.0d11.sql,v diff -u -r1.1 -r1.1.6.1 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d10-5.7.0d11.sql 26 May 2011 04:07:37 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d10-5.7.0d11.sql 21 Apr 2017 15:59:20 -0000 1.1.6.1 @@ -77,7 +77,7 @@ -- Add the appropriate column to the table -- We can only create the table column if - -- 1. the attribute is declared type_specific (generic storage uses an auxillary table) + -- 1. the attribute is declared type_specific (generic storage uses an auxiliary table) -- 2. the attribute is not declared static -- 3. it does not already exist in the table Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql 27 Oct 2014 16:39:36 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql 21 Apr 2017 15:59:20 -0000 1.4.2.1 @@ -387,7 +387,7 @@ -- Add the appropriate column to the table -- We can only create the table column if - -- 1. the attribute is declared type_specific (generic storage uses an auxillary table) + -- 1. the attribute is declared type_specific (generic storage uses an auxiliary table) -- 2. the attribute is not declared static -- 3. it does not already exist in the table Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.9.0d4-5.9.0d5.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.9.0d4-5.9.0d5.sql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.9.0d4-5.9.0d5.sql 29 Jul 2015 02:08:43 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.9.0d4-5.9.0d5.sql 21 Apr 2017 15:59:20 -0000 1.3.2.1 @@ -125,7 +125,7 @@ -- (sometimes implicitely, e.g. via acs_objects.*) the -- tree_sortkey. We perform this operation here (since the views were -- dropped by this upgrade script) but as well in update scripts for --- the relevant packages refering explicitly to the tree_sortkey +-- the relevant packages referring explicitly to the tree_sortkey -- fields. -- Index: openacs-4/packages/acs-kernel/sql/test/rel-constraints-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/test/rel-constraints-test.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/acs-kernel/sql/test/rel-constraints-test.sql 30 Mar 2013 19:32:40 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/test/rel-constraints-test.sql 21 Apr 2017 15:59:20 -0000 1.4.4.1 @@ -328,7 +328,7 @@ PERFORM rel_constraint__delete(side_one_constraint); PERFORM rel_constraint__delete(side_two_constraint); - -- Remove the test memebership relations + -- Remove the test membership relations for r in select * from blah_member_rels LOOP PERFORM blah_member_rel__delete(r.rel_id); end loop; Index: openacs-4/packages/acs-kernel/sql/test/rel-segments-test.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/test/rel-segments-test.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/acs-kernel/sql/test/rel-segments-test.sql 30 Mar 2013 19:32:40 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/test/rel-segments-test.sql 21 Apr 2017 15:59:20 -0000 1.4.4.1 @@ -355,7 +355,7 @@ PERFORM rel_segment__delete(seg_E_yippes); PERFORM rel_segment__delete(rel_segment__get(F,'membership_rel')); - -- Remove the test memebership relations + -- Remove the test membership relations for r in select * from blah_member_rels LOOP PERFORM blah_member_rel__delete(r.rel_id); end loop; Index: openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql,v diff -u -r1.37 -r1.37.6.1 --- openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql 17 Oct 2010 21:06:08 -0000 1.37 +++ openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql 21 Apr 2017 16:06:05 -0000 1.37.6.1 @@ -385,7 +385,7 @@ insert into ad_locales (locale, label, language, country, nls_language, nls_territory, nls_charset, mime_charset, default_p, enabled_p) - values ('uk_UA', 'Ukranian (UA)', 'uk', 'UA', 'Ukranian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); + values ('uk_UA', 'Ukrainian (UA)', 'uk', 'UA', 'Ukrainian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); insert into ad_locales (locale, label, language, country, nls_language, nls_territory, Index: openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql,v diff -u -r1.14 -r1.14.14.1 --- openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 26 Sep 2006 14:58:56 -0000 1.14 +++ openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 21 Apr 2017 16:06:05 -0000 1.14.14.1 @@ -116,7 +116,7 @@ create table lang_translate_columns ( column_id integer constraint ltc_column_id_pk primary key, - -- cant do references on user_tables cause oracle sucks + -- can't do references on user_tables cause oracle sucks on_which_table varchar2(50), on_what_column varchar2(50), -- Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql,v diff -u -r1.1 -r1.1.14.1 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql 24 Jun 2006 07:04:20 -0000 1.1 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.3.0d1-5.3.0d2.sql 21 Apr 2017 16:06:05 -0000 1.1.14.1 @@ -88,7 +88,7 @@ insert into ad_locales (locale, label, language, country, nls_language, nls_territory, nls_charset, mime_charset, default_p, enabled_p) - values ('uk_UA', 'Ukranian (UA)', 'uk', 'UA', 'Ukranian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); + values ('uk_UA', 'Ukrainian (UA)', 'uk', 'UA', 'Ukrainian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); insert into ad_locales (locale, label, language, country, nls_language, nls_territory, Index: openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql,v diff -u -r1.33.6.2 -r1.33.6.3 --- openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql 26 Nov 2016 07:42:03 -0000 1.33.6.2 +++ openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql 21 Apr 2017 16:06:05 -0000 1.33.6.3 @@ -393,7 +393,7 @@ insert into ad_locales (locale, label, language, country, nls_language, nls_territory, nls_charset, mime_charset, default_p, enabled_p) - values ('uk_UA', 'Ukranian (UA)', 'uk', 'UA', 'Ukranian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); + values ('uk_UA', 'Ukrainian (UA)', 'uk', 'UA', 'Ukrainian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); insert into ad_locales (locale, label, language, country, nls_language, nls_territory, Index: openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql,v diff -u -r1.17 -r1.17.14.1 --- openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 25 Sep 2006 20:41:12 -0000 1.17 +++ openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 21 Apr 2017 16:06:05 -0000 1.17.14.1 @@ -114,7 +114,7 @@ column_id integer constraint ltc_column_id_pk primary key, - -- cant do references on user_tables cause oracle sucks + -- can't do references on user_tables cause oracle sucks on_which_table varchar(50), on_what_column varchar(50), -- Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql,v diff -u -r1.1 -r1.1.14.1 --- openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql 24 Jun 2006 07:04:20 -0000 1.1 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.3.0d1-5.3.0d2.sql 21 Apr 2017 16:06:05 -0000 1.1.14.1 @@ -88,7 +88,7 @@ insert into ad_locales (locale, label, language, country, nls_language, nls_territory, nls_charset, mime_charset, default_p, enabled_p) - values ('uk_UA', 'Ukranian (UA)', 'uk', 'UA', 'Ukranian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); + values ('uk_UA', 'Ukrainian (UA)', 'uk', 'UA', 'Ukrainian', 'Ukraine', 'UTF8', 'UTF-8', 'f', 'f'); insert into ad_locales (locale, label, language, country, nls_language, nls_territory, Index: openacs-4/packages/acs-lang/tcl/lang-message-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/lang-message-procs.tcl,v diff -u -r1.54.2.5 -r1.54.2.6 --- openacs-4/packages/acs-lang/tcl/lang-message-procs.tcl 23 Feb 2017 10:37:14 -0000 1.54.2.5 +++ openacs-4/packages/acs-lang/tcl/lang-message-procs.tcl 21 Apr 2017 16:06:05 -0000 1.54.2.6 @@ -945,7 +945,7 @@ Inserts the message into the table lang_messages if it does not exist and updates if it does. - For backward compability - it assumes that the key + For backward compatibility - it assumes that the key is the concatenation of message and package key like this: Index: openacs-4/packages/acs-lang/tcl/localization-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/localization-procs.tcl,v diff -u -r1.24.2.5 -r1.24.2.6 --- openacs-4/packages/acs-lang/tcl/localization-procs.tcl 13 Feb 2017 14:12:00 -0000 1.24.2.5 +++ openacs-4/packages/acs-lang/tcl/localization-procs.tcl 21 Apr 2017 16:06:05 -0000 1.24.2.6 @@ -21,7 +21,7 @@ } { Converts a number to its canonical representation by stripping everything but the - decimal seperator and triming left 0's so it + decimal separator and triming left 0's so it won't be octal. It can process the following types of numbers:
  • Just digits (allows leading zeros). @@ -114,7 +114,7 @@ Called by lc_numeric and lc_monetary.

    Takes a grouping specifier and - inserts the given seperator into the string. + inserts the given separator into the string. Given a separator of : and a number of 123456789 it returns: 

    @@ -132,7 +132,7 @@
     @param num_re     Regular expression for valid numbers
     @return           Number formatted with thousand separator
 } {
-    # with empty seperator or grouping string we behave 
+    # with empty separator or grouping string we behave 
     # posixly
     if {$grouping eq "" || $sep eq "" } { 
         return $num
@@ -291,7 +291,7 @@
    See also 
    man strftime
    on a UNIX shell prompt for more of these abbreviations. @param locale Locale identifier must be in the locale database - @error Fails if given a non-existant locale or a malformed datetime + @error Fails if given a non-existent locale or a malformed datetime Doesn't check for impossible dates. Ask it for 29 Feb 1999 and it will tell you it was a Monday (1st March was a Monday, it wasn't a leap year). Also it only works with the Gregorian calendar - but that's reasonable, but could be a problem if you are running a seriously historical site Index: openacs-4/packages/acs-lang/tcl/test/acs-lang-test-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/test/acs-lang-test-procs.tcl,v diff -u -r1.18.2.5 -r1.18.2.6 --- openacs-4/packages/acs-lang/tcl/test/acs-lang-test-procs.tcl 27 Mar 2017 10:51:27 -0000 1.18.2.5 +++ openacs-4/packages/acs-lang/tcl/test/acs-lang-test-procs.tcl 21 Apr 2017 16:06:05 -0000 1.18.2.6 @@ -995,7 +995,7 @@ # Create the test package in the file system lang::test::setup_test_package - # Can't run this test case with the usual rollback switch since if everthing + # Can't run this test case with the usual rollback switch since if everything # is wrapped in one transaction then the creation_date of the messages will be the # same and the query in lang::catalog::last_sync_messages will return duplicates. aa_run_with_teardown \ Index: openacs-4/packages/acs-lang/www/admin/test/catalog-test.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/test/Attic/catalog-test.adp,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/acs-lang/www/admin/test/catalog-test.adp 22 Jun 2016 07:45:44 -0000 1.2.2.1 +++ openacs-4/packages/acs-lang/www/admin/test/catalog-test.adp 21 Apr 2017 16:06:05 -0000 1.2.2.2 @@ -17,7 +17,7 @@ Test 1

    Verify that the message catalog loader ran -successfully at server startup. +successfuly at server startup.

    Index: openacs-4/packages/acs-lang/www/admin/test/catalog-test.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/test/Attic/catalog-test.tcl,v diff -u -r1.2.18.1 -r1.2.18.2 --- openacs-4/packages/acs-lang/www/admin/test/catalog-test.tcl 10 Sep 2015 08:21:30 -0000 1.2.18.1 +++ openacs-4/packages/acs-lang/www/admin/test/catalog-test.tcl 21 Apr 2017 16:06:05 -0000 1.2.18.2 @@ -13,7 +13,7 @@ set context_bar [ad_context_bar "Message Catalog Test"] set footer [ad_footer] -# Test 1 verifies that the message catalog has loaded successfully +# Test 1 verifies that the message catalog has loaded successfuly set english [_ en test.English] set french [_ fr test.French] set spanish [_ es test.Spanish] Index: openacs-4/packages/acs-lang/www/admin/test/test.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/test/Attic/test.adp,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/acs-lang/www/admin/test/test.adp 22 Jun 2016 07:45:44 -0000 1.2.2.1 +++ openacs-4/packages/acs-lang/www/admin/test/test.adp 21 Apr 2017 16:06:05 -0000 1.2.2.2 @@ -9,7 +9,7 @@ Test 1

    Verify that the message catalog loader ran -successfully at server startup. +successfuly at server startup.

    Word to lookupLanguageResults of catalog lookup
    Index: openacs-4/packages/acs-lang/www/admin/test/test.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/test/Attic/test.tcl,v diff -u -r1.3.12.1 -r1.3.12.2 --- openacs-4/packages/acs-lang/www/admin/test/test.tcl 10 Sep 2015 08:21:30 -0000 1.3.12.1 +++ openacs-4/packages/acs-lang/www/admin/test/test.tcl 21 Apr 2017 16:06:05 -0000 1.3.12.2 @@ -13,7 +13,7 @@ # set navbar [ad_context_bar "Test"] set footer [ad_footer] -# Test 1 verifies that the message catalog has loaded successfully +# Test 1 verifies that the message catalog has loaded successfuly set english [_ en test.English] set french [_ fr test.French] set spanish [_ es test.Spanish] Index: openacs-4/packages/acs-lang/www/doc/i18n-design.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/doc/i18n-design.adp,v diff -u -r1.1.2.5 -r1.1.2.6 --- openacs-4/packages/acs-lang/www/doc/i18n-design.adp 5 Jul 2016 12:16:50 -0000 1.1.2.5 +++ openacs-4/packages/acs-lang/www/doc/i18n-design.adp 21 Apr 2017 16:06:05 -0000 1.1.2.6 @@ -498,7 +498,7 @@ it is omitted this procedure returns simply the text enclosed by the tags.
  • lang specifies the language of the text string -enclosed within the flags. If it is ommitted value defaults to +enclosed within the flags. If it is omitted value defaults to English.
  • type specifies the context in which the translation is made. If omitted, type is user which means that the Index: openacs-4/packages/acs-lang/www/doc/i18n-design.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/doc/i18n-design.html,v diff -u -r1.3.2.2 -r1.3.2.3 --- openacs-4/packages/acs-lang/www/doc/i18n-design.html 5 Aug 2016 13:37:28 -0000 1.3.2.2 +++ openacs-4/packages/acs-lang/www/doc/i18n-design.html 21 Apr 2017 16:06:05 -0000 1.3.2.3 @@ -645,7 +645,7 @@
  • key specifies the key in the message catalog. If it is omitted this procedure returns simply the text enclosed by the tags.
  • lang specifies the language of the text string enclosed within the - flags. If it is ommitted value defaults to English. + flags. If it is omitted value defaults to English.
  • type specifies the context in which the translation is made. If omitted, type is user which means that the translation is provided in the user's preferred language.
  • static specifies that this tag should be translated once at templat compile time, rather than dynamically every time the page is run. This will be unneccessaru and will be deprecated once we Index: openacs-4/packages/acs-lang/www/doc/i18n-requirements.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/doc/i18n-requirements.adp,v diff -u -r1.1.2.15 -r1.1.2.16 --- openacs-4/packages/acs-lang/www/doc/i18n-requirements.adp 5 Jul 2016 12:16:50 -0000 1.1.2.15 +++ openacs-4/packages/acs-lang/www/doc/i18n-requirements.adp 21 Apr 2017 16:06:05 -0000 1.1.2.16 @@ -386,7 +386,7 @@

    100.10 Since UTF8 strings can use up to three (UCS2) or six (UCS4) bytes per character, make sure that column -size declarations in the schema are large enough to accomodate +size declarations in the schema are large enough to accommodate required data (such as email addresses in Japanese).

    VI.I Email and Messaging

    Index: openacs-4/packages/acs-lang/www/doc/i18n-requirements.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/doc/i18n-requirements.html,v diff -u -r1.2.24.1 -r1.2.24.2 --- openacs-4/packages/acs-lang/www/doc/i18n-requirements.html 22 Jun 2016 07:45:44 -0000 1.2.24.1 +++ openacs-4/packages/acs-lang/www/doc/i18n-requirements.html 21 Apr 2017 16:06:05 -0000 1.2.24.2 @@ -410,7 +410,7 @@

    100.10 Since UTF8 strings can use up to three (UCS2) or six (UCS4) bytes per character, make sure that column size -declarations in the schema are large enough to accomodate required +declarations in the schema are large enough to accommodate required data (such as email addresses in Japanese).

    VI.I Email and Messaging

    • Word to lookupLanguageResults of catalog lookup