8000 Setup not working with postgres · Issue #1905 · bolt/core · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
Setup not working with postgres #1905
Closed
@eliysha

Description

@eliysha

From a fresh install, I ran bolt:setup, I'm getting errors

Details

Question Answer
Relevant Bolt Version 4.0
Install type Composer install
BC Break yes/no
PHP version 7.4
Web server Apache
For UX/UI issues Browser name and version

Reproduction

If you're filing a bug, please describe how to reproduce it. Include as much
relevant information as possible, such as:

Bug summary

The app is not working with Postgres

Specifics

Steps to reproduce

From a fresh install using Postgresql. Run bin/console bolt:setup

Expected result

  • Dummy content should be inserted on DB without any error

Actual result



 [OK] Administrator user was successfully created: test (ccc@gmail.com)



 Add fixtures (dummy content) to the Database? (yes/no) [yes]:
 >


   > loading Bolt\DataFixtures\UserFixtures
   > loading Bolt\DataFixtures\TaxonomyFixtures
   > loading Bolt\DataFixtures\ImageFetchFixtures
 20/20 [============================] 100%
   > loading Bolt\DataFixtures\ImagesFixtures
   > loading Bolt\DataFixtures\ContentFixtures

In AbstractPostgreSQLDriver.php line 89:

  An exception occurred while executing 'SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b1_.id AS id_4, b1_.value AS value_5, b1_.locale AS locale_6, b0_.type AS type_
  7, b0_.content_id AS content_id_8, b0_.parent_id AS parent_id_9, b1_.translatable_id AS translatable_id_10 FROM bolt_field b0_ INNER JOIN bolt_field_translation b1_ ON b0_.id = b1_.translatable_id WHERE (b1_.value = ?
   AND b0_.type IN (?)) AND b0_.type IN ('generic', 'templateselect', 'embed', 'email', 'textarea', 'collection', 'text', 'checkbox', 'set', 'markdown', 'block', 'number', 'html', 'select', 'image', 'date', 'data', 'hid
  den', 'filelist', 'file', 'imagelist', 'slug', 'article', 'redactor')' with params ["[\"qui-cumque-consequatur\"]", "slug"]:

  SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: json = unknown
  LINE 1: ... ON b0_.id = b1_.translatable_id WHERE (b1_.value = $1 AND b...
                                                               ^
  HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.


In PDOStatement.php line 131:

  SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: json = unknown
  LINE 1: ... ON b0_.id = b1_.translatable_id WHERE (b1_.value = $1 AND b...
                                                               ^
  HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.


In PDOStatement.php line 129:

  SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: json = unknown
  LINE 1: ... ON b0_.id = b1_.translatable_id WHERE (b1_.value = $1 AND b...
                                                               ^
  HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.


bolt:setup [-nf|--no-fixtures] [-f|--fixtures] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0