Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012967 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | major | always | 2010-04-14 10:29 | 2010-06-15 14:03 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 4b2693653080 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP17 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP14 | SCM revision | ||||||
| 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 | 0012967: The hour in a column defined as datetime is not saved properly | |||||||
| Description | The hour in a column defined as datetime is not saved properly | |||||||
| Steps To Reproduce | -Create new module, check it as indevelopment and add a prefix -Add a new column in the c_bpartner table to save a datetime value ALTER TABLE c_bpartner ADD COLUMN em_prefix_fechacaducidad timestamp without time zone; -Add this new column in the application dictionary in the c_bpartner table check datetime value as reference -Add this new column as a new field in the header of the partner window. -Create a template an set is as indevelopment -Change the definition of the c_bpartner table unchecking the highvolen checkbox. -Compile the windows and restart tomcat -Go the the window an fill the new field with a date with tame -Save it: see that the time is saved with 00:00:00 instead of the time selected | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0026582) alostale (manager) 2010-04-22 16:50 |
This issue affects to PostgreSQL but to to Oracle. The problem is that for inserting/updating date time references, to_date(date, format) function is used. It is correct in Oracle, but in PostgreSQL it returns a date without time. Proposed solution: use to_timestamp which should work in both databases. |
|
(0026585) hgbot (developer) 2010-04-22 17:47 |
Repository: erp/devel/pi Changeset: 6b7c616d7412d814444ac6929221d6ff31a4cf3b Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Apr 22 17:04:38 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^] fixed bug 12967: The hour in a column defined as datetime is not saved properly --- M src-wad/src/org/openbravo/wad/Wad.java --- |
|
(0026877) sureshbabu (reporter) 2010-05-03 16:59 |
Tested now its working fine |
|
(0027273) hudsonbot (developer) 2010-05-14 15:27 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/6b7c616d7412 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/36f76c8d7193 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17198.obx [^] |
|
(0027966) hgbot (developer) 2010-06-04 14:44 |
Repository: erp/devel/pi Changeset: 4b269365308019b88e8133e8cf3d1268fc877676 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Apr 22 17:04:38 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/4b269365308019b88e8133e8cf3d1268fc877676 [^] fixed bug 12967: The hour in a column defined as datetime is not saved properly --- M src-wad/src/org/openbravo/wad/Wad.java --- |
|
(0028088) hudsonbot (developer) 2010-06-07 21:20 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/4b2693653080 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^] |
|
(0028130) hudsonbot (developer) 2010-06-07 23:43 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/4b2693653080 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-04-14 10:29 | networkb | New Issue | |
| 2010-04-14 10:29 | networkb | Assigned To | => alostale |
| 2010-04-14 10:43 | networkb | Relationship added | related to 0010264 |
| 2010-04-14 10:43 | networkb | Target Version | 2.50MP15 => 2.50MP16 |
| 2010-04-19 08:30 | alostale | Status | new => scheduled |
| 2010-04-19 08:30 | alostale | fix_in_branch | => pi |
| 2010-04-22 16:48 | alostale | fix_in_branch | pi => |
| 2010-04-22 16:50 | alostale | Note Added: 0026582 | |
| 2010-04-22 17:47 | hgbot | Checkin | |
| 2010-04-22 17:47 | hgbot | Note Added: 0026585 | |
| 2010-04-22 17:47 | hgbot | Status | scheduled => resolved |
| 2010-04-22 17:47 | hgbot | Resolution | open => fixed |
| 2010-04-22 17:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^] |
| 2010-05-03 16:59 | sureshbabu | Note Added: 0026877 | |
| 2010-05-03 16:59 | sureshbabu | Status | resolved => closed |
| 2010-05-04 00:00 | anonymous | sf_bug_id | 0 => 2996191 |
| 2010-05-11 18:19 | jpabloae | Target Version | 2.50MP16 => 2.50MP17 |
| 2010-05-14 15:27 | hudsonbot | Checkin | |
| 2010-05-14 15:27 | hudsonbot | Note Added: 0027273 | |
| 2010-06-04 14:44 | hgbot | Checkin | |
| 2010-06-04 14:44 | hgbot | Note Added: 0027966 | |
| 2010-06-04 14:44 | hgbot | Status | closed => resolved |
| 2010-06-04 14:44 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^] => http://code.openbravo.com/erp/devel/pi/rev/4b269365308019b88e8133e8cf3d1268fc877676 [^] |
| 2010-06-07 21:20 | hudsonbot | Checkin | |
| 2010-06-07 21:20 | hudsonbot | Note Added: 0028088 | |
| 2010-06-07 23:43 | hudsonbot | Checkin | |
| 2010-06-07 23:43 | hudsonbot | Note Added: 0028130 | |
| 2010-06-15 14:03 | jpabloae | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |