• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Changeset MAIN:antoniop:20230308163231:11 does not match your current filter (clear filter).

file test.docx was initially added on branch oacs-5-10.

    • -0
    • +0
    ./tcl/test/data/test.docx
file test.html was initially added on branch oacs-5-10.

    • -0
    • +0
    ./tcl/test/data/test.html
file test.txt was initially added on branch oacs-5-10.

    • -0
    • +0
    ./tcl/test/data/test.txt
file test.pptx was initially added on branch oacs-5-10.

    • -0
    • +0
    ./tcl/test/data/test.pptx
Test binary to text conversion of various file types

file search-procs.tcl was initially added on branch oacs-5-10.

    • -0
    • +0
    ./tcl/test/search-procs.tcl
file test.doc was initially added on branch oacs-5-10.

    • binary
    ./tcl/test/data/test.doc
Whitespace cleanup

Make use of new API "ad_mktmpdir" and "ad_opentmpfile" instead of "ad_tmpnam"

Prefer util::which to retrieve the unzip executable

Complain in the logfile whenever the insertion of the null character is attempted in the syndication table

Implement a conversion from MS pptx to plaintext:

first slides are extracted from the presentation, then everything that is not the content of a text tag is removed.

More targeted sanityzing only on the variables that have a chance to contain the null character

Translate potential null characters in the syndication content with the empty string, so that we do not risk to try (and fail) to insert them in the database

Reduce hard errors in the search indexer on invalid file content

This change uses util::file_content_check introduced with acs-tcl

5.10.1d9 to detect error situations before external programs are

called, which can lead to unpredictable error messages.

bumped version to 5.10.1d1

fix issue shown with acunetix testing (without login)

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