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

Timeline functionality in oracle not working correctly

    Details

      Description

      Adding articles with different publish dates to an ezflow block are not previewed using the timeline functionality in ezflow

      Steps to reproduce

      Create Content
       
         1. Create "News" folder
         2. Click on the "News" folder
         3. Create 3 Articles
       
          Article 1
          Title: Article 1
          Summary: Summary of Article 1
         
          Article 2
          Title: Article 2
          Summary: Summary of Article 2
         
          Article 3
          Title: Article 3
          Summary: Summary of Article 3
       
      Edit frontpage
       
         1. Create a new 3 items manual block
       
          Name: Block 1
          Add item: Add the 3 created articles
          Press the schedule for Article 1 and choose today
          Press the schedule for Article 2 and choose two days form now
          Press the schedule for Article 3 and choose four days form now
       
         2. Click Send for publish
       
       
      View timeline
       
         1. Login as admin to ezflow forntpage
         2. On the top menu bar click timeline
         3. Using the calander check if the articles are only visible once after the publish date
      
      

        Activity

        Hide
        Pedro Resende added a comment -

        After verifying var/log/error.log I found out the following errors:

        Start of error:
        EZM_BLOCK_TMP_74917582
        [ Apr 20 2012 11:45:25 ] [192.168.2.204] Timing Point: Module start 'ezflow'
        [ Apr 20 2012 11:45:25 ] [192.168.2.204] eZOracleDB::query():
        Error (933): ORA-00933: SQL-kommandoen er ikke avsluttet riktig
        Failed query at offset 98:
        CREATE GLOBAL TEMPORARY TABLE EZM_BLOCK_TMP_81671875 AS SELECT * FROM ezm_block WHERE node_id='2' ON COMMIT PRESERVE ROWS

        Start of error:
        ON COMMIT PRESERVE ROWS
        [ Apr 20 2012 11:45:25 ] [192.168.2.204] eZOracleDB:
        Error (942): ORA-00942: tabellen eller utsnittet finnes ikke
        Failed query at offset 15:
        SELECT id FROM EZM_BLOCK_TMP_81671875

        Start of error:
        EZM_BLOCK_TMP_81671875

        Show
        Pedro Resende added a comment - After verifying var/log/error.log I found out the following errors: Start of error: EZM_BLOCK_TMP_74917582 [ Apr 20 2012 11:45:25 ] [192.168.2.204] Timing Point: Module start 'ezflow' [ Apr 20 2012 11:45:25 ] [192.168.2.204] eZOracleDB::query(): Error (933): ORA-00933: SQL-kommandoen er ikke avsluttet riktig Failed query at offset 98: CREATE GLOBAL TEMPORARY TABLE EZM_BLOCK_TMP_81671875 AS SELECT * FROM ezm_block WHERE node_id='2' ON COMMIT PRESERVE ROWS Start of error: ON COMMIT PRESERVE ROWS [ Apr 20 2012 11:45:25 ] [192.168.2.204] eZOracleDB: Error (942): ORA-00942: tabellen eller utsnittet finnes ikke Failed query at offset 15: SELECT id FROM EZM_BLOCK_TMP_81671875 Start of error: EZM_BLOCK_TMP_81671875

          People

          • Assignee:
            unknown
            Reporter:
            João Pingo
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: