https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15272 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #100877|0 |1 is obsolete| | --- Comment #11 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 102351 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102351&action=edit Bug 15272: Merge aqbooksellers addressX columns The physical address of a vendor is stored in 4 different DB columns: address1, address2, address3 and address4 The are concatenated and split for storage/display purpose. If you enter an address on more than 4 lines, the other lines are truncated: data loss To avoid such weird behavior, we could simplify the code and get more flexibility (like address as long as you wish) merging those 4 columns into 1, address Test plan: 0. Do not apply the patches 1. Create a vendor and enter more than 4 lines in the physical address, save => Notice that the lines has been stored in the 4 columns, and that you lost the end of the address 2. Apply the patches and execute the updatedatabase script 3. Edit the vendor's address => Notice that the address is displayed correctly 4. Add more lines, save => Notice that the extra lines are kept 5. Generate a ACQCLAIM or ACQORDER notice for this vendor => Confirm that the address is displayed correctly in the generated notice Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> -- You are receiving this mail because: You are watching all bug changes.