Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005410 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | critical | always | 2008-10-03 19:51 | 2008-10-09 12:26 | |||
| Reporter | copantl | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | 2.50 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | sun java 6 | |||
| OS Version | debian etch | Database version | 8.3 | Ant version | 1.6.5 | |||
| Product Version | pi | SCM revision | r8013 | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005410: Problem creating External POS | |||||||
| Description | When i tried to create an external POS give me this error: ERROR: invalid input syntax for type numeric : 'D2754490AC584D33B2B0B75F8FFF75D3' | |||||||
| Steps To Reproduce | every time that you tried to create a new external POS with a new instance. | |||||||
| Proposed Solution | maybe the c_externalpos tables are numeric, then i gonna trie to change it to varchar. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  openbravo.log [^] (669 bytes) 2008-10-03 19:51 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0009471) shuehner (administrator) 2008-10-08 21:22 |
An insert into this table triggers the c_externalpos_trg trigger to fire, which then tries to copy the two varchar fields ad_client and ad_org into two other fields ad_client_code and ad_organisation_code. This two fields have been removed in commit 8181. The error message which numeric seems just to be misleading. If the dropped fields are really unused, the trigger should be removed completely. |
|
(0009487) cromero (reporter) 2008-10-09 12:24 |
I have deleted the trigger in commit 8461. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-10-03 19:51 | copantl | New Issue | |
| 2008-10-03 19:51 | copantl | Assigned To | => cromero |
| 2008-10-03 19:51 | copantl | sf_bug_id | 0 => 2144771 |
| 2008-10-03 19:51 | copantl | File Added: openbravo.log | |
| 2008-10-03 19:54 | jpabloae | Issue Monitored: jpabloae | |
| 2008-10-06 09:06 | cromero | Priority | normal => high |
| 2008-10-06 09:06 | cromero | Status | new => scheduled |
| 2008-10-06 09:06 | cromero | Fixed in Version | => 2.50 |
| 2008-10-07 20:02 | pjuvara | Issue Monitored: pjuvara | |
| 2008-10-08 21:22 | shuehner | Note Added: 0009471 | |
| 2008-10-09 12:24 | cromero | Note Added: 0009487 | |
| 2008-10-09 12:26 | cromero | Regression testing | => No |
| 2008-10-09 12:26 | cromero | Relationship added | duplicate of 0005473 |
| 2008-10-09 12:26 | cromero | Status | scheduled => closed |
| 2008-10-09 12:26 | cromero | Duplicate ID | 0 => 5473 |
| 2008-10-09 12:26 | cromero | Resolution | open => duplicate |
| 2008-10-15 11:29 | shuehner | Relationship deleted | 0005473 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |