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

pg_exec(): Query failed: syntax error integer: "" in lib/ezdb/classes/ezpostgresqldb.php on line 166 (called from eZURLAlias::fetchBySourceURL())

    XMLWordPrintable

    Details

      Description

      The error is caused by eZURLAlias::fetchBySourceURL() method within eZP which is using the Postgresql db.
      Here example of call stack which demonstrates how it happens:

      /opt/ezpublish/sites/svn.3.8/lib/ezdb/classes/ezpostgresqldb.php:238, ezpostgresqldb::->query('SELECT id, source_url, source_md5, destination_url, is_internal, is_wildcard, forward_to_id FROM ezurlalias WHERE source_url='content/view/full/2' AND is_wildcard='0' AND is_internal='' AND forward_to_id='0'')
      /opt/ezpublish/sites/svn.3.8/kernel/classes/ezpersistentobject.php:782, ezpostgresqldb::->arrayquery('SELECT id, source_url, source_md5, destination_url, is_internal, is_wildcard, forward_to_id FROM ezurlalias WHERE source_url='content/view/full/2' AND is_wildcard='0' AND is_internal='' AND forward_to_id='0'',Array)
      /opt/ezpublish/sites/svn.3.8/kernel/classes/ezpersistentobject.php:163, ezpersistentobject::::fetchobjectlist(Array,,Array,Array,,,,)
      /opt/ezpublish/sites/svn.3.8/kernel/classes/ezurlalias.php:332, ezpersistentobject::::fetchobject(Array,,Array,)
      /opt/ezpublish/sites/svn.3.8/kernel/classes/ezurlalias.php:771, ezurlalias::::fetchbysourceurl('content/view/full/2',,)
      /opt/ezpublish/sites/svn.3.8/index.php:561, ezurlalias::::translate([ezuri])
      

        Attachments

          Activity

            People

            Assignee:
            rl Ruslan Lisnyk
            Reporter:
            rl Ruslan Lisnyk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: