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

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • 4.7.0-dev
    • None
    • 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

        Activity

          People

            unknown unknown
            pcardiga pcardiga
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: