Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007680 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | major | always | 2009-02-19 13:18 | 2009-03-18 11:03 | |||
| Reporter | roklenardic | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_10 | |||
| OS Version | Ubuntu 8.10 | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | 13140 | |||||
| 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 | 0007680: New Columns cannot be added with EM_XXX prefix | |||||||
| Description | Imagine you add a new column to the M_ProductPrice database table following the guidelines on http://wiki.openbravo.com/wiki/Projects/Modularity/Developers_Guide#Table_and_column [^] ALTER TABLE m_productprice ADD COLUMN em_howto_calculate_average_price CHARACTER(1) NOT NULL DEFAULT ''; Our custom module is a template in development with the DB Prefix defined as HOWTO. When trying to enter this new column into the Table and Column for the M_ProductPrice table, I cannot add it with DB COlumn Name = 'EM_HOWTO_Calculate_Average_Price' since I get a red alert 'ERROR: Names must start with its module's DB prefix'. I thought about saving it as a 'HOWTO_Calculate_Average_Price' hoping that the application will figure the EM_ part out considering this particular new field is part of a custom template. I am able to save then but the compilation fails saying: ... [java] 1007 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Product/Accounting_data.xsql processed [java] 1097 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Product/Price_data.xsql processed [java] org.postgresql.util.PSQLException: ERROR: column m_productprice.howto_calculate_average_price does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) ... obviously not finding the specified column since it starts with EM_ as specified in the guidelines. | |||||||
| Proposed Solution | Is the error in the guidelines or the application? | |||||||
| Tags | Modularity | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-19 13:18 | roklenardic | New Issue | |
| 2009-02-19 13:18 | roklenardic | Assigned To | => rafaroda |
| 2009-02-19 13:18 | roklenardic | Regression testing | => No |
| 2009-02-24 11:53 | rafaroda | Tag Attached: Modularity | |
| 2009-02-24 11:53 | rafaroda | Assigned To | rafaroda => alostale |
| 2009-02-24 11:53 | rafaroda | Priority | normal => high |
| 2009-02-24 11:53 | rafaroda | Status | new => scheduled |
| 2009-02-24 12:00 | alostale | Relationship added | duplicate of 0007623 |
| 2009-02-24 12:00 | alostale | Status | scheduled => closed |
| 2009-02-24 12:00 | alostale | Duplicate ID | 0 => 7623 |
| 2009-02-24 12:00 | alostale | Resolution | open => duplicate |
| 2009-03-18 11:03 | anonymous | sf_bug_id | 0 => 2691410 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |