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

(Oracle) Creating a new currency type shows a transaction error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.6.0
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      Operating System: RHEL 6.1
      PHP Version: 5.3.3
      Database and version: Oracle 11g
      Browser (and version):

      Description

      Creating a new currency type in webshop shows a database transaction type fatal error:
      In Browser

      Fatal error: A database transaction in eZ Publish failed.
      The current execution was stopped to prevent further problems.
      You should contact the System Administrator of this site with the information on this page.
      The current transaction ID is TRANSID-86ddfb9a917e8fd4ec3150841ced53e0 and has been logged.
      Please include the transaction ID and the current URL when contacting the system administrator.
      

      In Debug

      Error: eZOracleDB::query() 	Feb 08 2012 17:12:39
      
      Error (1722): ORA-01722: ugyldig tall
      Failed query at offset 140:
      INSERT INTO ezcurrencydata (code, symbol, locale, status, auto_rate_value, custom_rate_value, rate_factor) VALUES('NOK', 'Kr', 'eng-GB', 1, '0.0000', '1', '1.0000')
      
      Start of error:
      '0.0000', '1', '1.0000')
      
      Error: eZDBInterface::commit TRANSID-86ddfb9a917e8fd4ec3150841ced53e0 	Feb 08 2012 17:12:39
      
      Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-86ddfb9a917e8fd4ec3150841ced53e0.
      
      Steps to reproduce

      1. Open Webshop tab
      2. Create a new currency type with the following with this data
      Currency code: NOK
      Currency symbol: Kr
      Formatting locale: eng-GB
      Custom rate: 1
      Rate factor: 1
      3. Click Create

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dp@ez.no Damien Pobel (eZ)
              Reporter:
              jpingo João Pingo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: