Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-22783

Database query syntax error on postgres

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 2014.03
    • Database related
    • Windows 7 (developer machine) / PHP 5.3.27 / PostgreSQL 9.3.1

    Description

      After installation (using setup wizard), I tried to access administration panel and got a 503 error.

      Log:

      request.CRITICAL: Uncaught PHP Exception RuntimeException: "Database error" at path\to\ezp\vendor\ezsystems\ezpublish-kernel\eZ\Publish\Core\Persistence\Legacy\Content\Gateway\ExceptionConversion.php line 395 {"exception":"[object] (RuntimeException: Database error at path\to\ezp\\vendor\\ezsystems\\ezpublish-kernel\\eZ\\Publish\\Core\\Persistence\\Legacy\\Content\\Gateway\\ExceptionConversion.php:395, Doctrine\\DBAL\\DBALException: An exception occurred while executing 'SELECT ezcontentobject.*, `ezcontentobject_tree`.`main_node_id` `ezcontentobject_tree_main_node_id` FROM `ezcontentobject` LEFT JOIN `ezcontentobject_tree` ON ( `ezcontentobject_tree`.`contentobject_id` = `ezcontentobject`.`id` AND `ezcontentobject_tree`.`main_node_id` = `ezcontentobject_tree`.`node_id` ) WHERE `ezcontentobject`.`id` = :placeholder1' with params [10]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \".\"\nLINE 1: SELECT ezcontentobject.*, `ezcontentobject_tree`.`main_node_... at path\to\ezp\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\DBALException.php:91, PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \".\"\nLINE 1: SELECT ezcontentobject.*, `ezcontentobject_tree`.`main_node_... at path\to\ezp\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Statement.php:165)"} []
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            metallizer metallizer
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: