• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes during the creation of the search observer queue for Oracle 19c:

In essence, the change repairs the following error:

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY SEARCH_OBSERVER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

16/7 PL/SQL: SQL Statement ignored

16/40 PL/SQL: ORA-00933: SQL command not properly ended

    • -4
    • +5
    ./sql/oracle/search-packages-create.sql
Don't trust blindly the mime-type determined by the file extension and try to use the unix command "file" when available

Deprecate template::util::tcl_to_sql_list, completely replaced by ns_dbquotelist, a native NaviServer command

  1. … 17 more files in changeset.
fix release dates in .info files

  1. … 82 more files in changeset.
release work

  1. … 204 more files in changeset.
regenerated documentation

  1. … 467 more files in changeset.
bump version numbers of 5.9|5.10 packages to 5.10.0b1

adjust dependencies

  1. … 87 more files in changeset.
added page contract filter "printable" to avoid potential DB errors on certain binary values

Whitespace changes

  1. … 1 more file in changeset.
replace low-level cr_fs_path by higher level interface content::revision::get_cr_file_path

  1. … 8 more files in changeset.
remove spurious parens

    • -2
    • +2
    ./sql/oracle/search-packages-create.sql
    • -1
    • +1
    ./sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
improve spelling

Handle potential race condition in search observer queue maintenance

In some cases, when e.g. objects are quicky deleted after updates, the

object might be already be deleted when being tried to trigger a

DELETE operation in the search queue. as a consequence, one can sometimes

observer errors like the one below. The new code double-checks now,

if the object for the DELETE operation still exists.

ERROR: insert or update on table "search_observer_queue" violates foreign key constraint "search_observer_queue_object_id_fk"

: DETAIL: Key (object_id)=(497509146) is not present in table "acs_objects".

: CONTEXT: SQL statement "insert into search_observer_queue (

    • -1
    • +16
    ./sql/oracle/search-packages-create.sql
    • -0
    • +50
    ./sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
file upgrade-5.10.0d3-5.10.0d4.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
whitespace changes: break overlong lines

whitespace changes

white space changes: break overlong lines

mark private functions as private

  1. … 9 more files in changeset.
avoid setting of unneeded function, reduce access to nsvs

provide a flushing interface to apm_package_id cache to avoid the need to call the uncached code directly

  1. … 1 more file in changeset.
Reinstate proc as private, remove dependency to such proc in external package

  1. … 1 more file in changeset.
prefer ns_dbquotevalue over db_quote, mark latter as deprecated

  1. … 3 more files in changeset.
Whitespace cleanup

As the doc says, use the uncached version to retrieve the package instance

improve spelling: move closer to the linux documentation recommendations

  1. … 9 more files in changeset.
Use portable sql idioms

Delete NOOP tcl file

Add ad_include_contract

add include contract

Downgrade as a warning the case when pdfs fail to be converted to text because of password protection