[Koha-bugs] [Bug 15272] aqbookseller addresses are combined into "physical address" field
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Mar 17 10:57:55 CET 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15272
--- Comment #6 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 100877
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=100877&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
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list