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

Database transaction failed in cronjob notification.php (wrong query)

    XMLWordPrintable

    Details

      Description

      When launching frequent cronjob part, I've got :

      Running cronjob part 'frequent'
      Running cronjobs/notification.php
      Starting notification event processing
      Fatal error: A database transaction in eZ Publish failed.
      
      The current execution was stopped to prevent further problems.
      You should contact the System Administrator (dpobel@free.fr) of this site.
      The current transaction ID is TRANSID-86dc94e5af5b2a31e6c5a6e54e774c43 and has been logged.
      Please include the transaction ID and the name of the current script when contacting the system administrator.

      Looking at mysql query log, I can see the following SQL query :

      SELECT DISTINCT user_node.node_id,
                                      user_node.path_string,
                                      user_tree.contentobject_id
                      FROM ezcontentobject_tree user_node,
                           ezcontentobject_tree user_tree
                      WHERE user_node.node_id IN (  ) AND
                            user_node.path_string like  concat( user_tree.path_string,'%'  )
      
      Steps to reproduce

      1. Edit a node
      2. Run "frequent" cronjob part

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nfrp Nicolas Pastorino
              Reporter:
              dpobel Damien Pobel
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: