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

fixnoderemoteid script does not work with PostgreSQL

    XMLWordPrintable

Details

    Description

      Enhancement implemented (http://issues.ez.no/IssueView.php?Id=14352) has a flaw with PostgreSQL and probably other databases as well:

      Warning: (PHP: E_WARNING)
      pg_query(): Query failed: ERROR:  zero-length delimited identifier at or near """"
      LINE 1: ...ELECT node_id FROM ezcontentobject_tree WHERE remote_id = ""
                                                                           ^ in lib/ezdb/classes/ezpostgresqldb.php on line 173
      
      Error: (eZPostgreSQLDB)
      Error: error executing query: SELECT node_id FROM ezcontentobject_tree WHERE remote_id = "" ERROR:  zero-length delimited identifier at or near """"
      LINE 1: ...ELECT node_id FROM ezcontentobject_tree WHERE remote_id = ""
      
      

      Patch attached.

      Attachments

        Activity

          People

            andre1 andre1
            cyberwolf cyberwolf
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: