Openbravo Issue Tracking System - Retail Modules
View Issue Details
0042656Retail ModulesGift cards and gift voucherspublic2019-12-27 13:262019-12-27 13:32
santi_lozano 
Retail 
normalminoralways
newopen 
5
 
 
No
0042656: Two Gift Card New Entities columns being lost after upgrade
Upgrading from 17q1 to 19q3.2 with content on table gcnv_giftcard_inst makes you lose data of that table columns em_obgcne_gcowner and em_obgcne_expirationdate. Module New Entities For Gift Cards has been merged into Gift Cards and Vouchers module and this makes a change of names in those columns which could have not been considered (obgcne_gcowner and obgcne_expirationdate) on the upgrading process. For client the problem has been solved as he has copied the data from a backup, but it could happen to other clients without noticing that situation
* have an instance 17q1 with module New Entities For Gift Cards (1.1.100) and Gift Cards and Vouchers (1.2.600)
* with content on table gcnv_giftcard_inst
* update from Module Management window to 19q3.2 (Gift Cards and Vouchers module is updated to 1.3.1100)
* data on table gcnv_giftcard_inst and columns em_obgcne_gcowner and em_obgcne_expirationdate has been lost
No tags attached.
png 13636 - lost columns.png (115,510) 2019-12-27 13:32
https://issues.openbravo.com/file_download.php?file_id=13739&type=bug
png
Issue History
2019-12-27 13:26santi_lozanoNew Issue
2019-12-27 13:26santi_lozanoAssigned To => Retail
2019-12-27 13:26santi_lozanoTriggers an Emergency Pack => No
2019-12-27 13:27santi_lozanoDescription Updatedbug_revision_view_page.php?rev_id=19979#r19979
2019-12-27 13:31santi_lozanoNote Added: 0116559
2019-12-27 13:32santi_lozanoFile Added: 13636 - lost columns.png

Notes
(0116559)
santi_lozano   
2019-12-27 13:31   
I have not been able to reproduce it as I have been having problems with 17q1 instances locally, but I report it because I understand that to fix this issue one should only update the references to that columns as done with other modules that have merged into others, as the naming is following now other prefix rules (without em_)
http://wiki.openbravo.com/wiki/How_to_add_Columns_to_a_Table [^]