New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PostgreSQL Support #1682

Open

trokohl opened this issue Aug 25, 2020 · 0 comments

trokohl commented Aug 25, 2020 •

edited

Loading

Hi,

vhs uses sql condition which are not compatible with postgreSQL.
The colume name must be quoted (https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS)
to work with postgre and mysql.

(Quick) Fix;
Classes/ViewHelpers/Content/AbstractContentViewHelper line 149 - 154

        if (is_numeric($this->arguments['column'])) {
            $conditions = sprintf('"colPos" = %d', (integer) $this->arguments['column']);
        }
        if (true === (boolean) $this->arguments['sectionIndexOnly']) {
            $conditions .= ' AND "sectionIndex" = 1';
        }

If you use colPos without quotes postgre search the column colpos (in lowercase).

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment