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

(TC-794) - On Webshop, creating a currency on Oracle raises a fatal error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: 4.7.0-dev
    • Labels:
      None
    • Environment:

      Operating System: RHEL 6.1
      PHP Version: (please be specific, like '4.4.3' or '5.1.5') : 5.3.3
      Database and version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
      Browser (and version): Firefox 10.0.2

      Description

      Hi,

      On Webshop, creating a currency on Oracle raises a fatal error

      Error: eZOracleDB::query() 	Mar 21 2012 13:13:30
      
      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', 'kt', 'eng-GB', 1, '0.0000', '0.0000', '1.0000')
      
      Start of error:
      '0.0000', '0.0000', '1.0000')
      
      Error: eZDBInterface::commit TRANSID-8fb78225a414994077403d71b27bed9b 	Mar 21 2012 13:13:30
      
      Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-8fb78225a414994077403d71b27bed9b.
      

      Follow the steps described below.

      Steps to reproduce
       1.Login to the admin interface as admin
       2. Click the "Webshop" tab in the top tab menu
       3. Click the "Currencies" link on the left
       4. Click the "New currency" button
       5. Fill in the following data:
      
         Currency code: NOK
         Currency symbol: kr
      
      6. Click the "Create" button
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              unknown unknown
              Reporter:
              pcardiga Paulo Cardiga
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: