Details
-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
4.6.0
-
None
-
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
- is duplicated by
-
EZP-19264 (TC-794) - On Webshop, creating a currency on Oracle raises a fatal error
- Closed