Data too long for column 'salesperson' when processing a Sales Order

Data too long for column 'salesperson' when processing a Sales Order - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+---- Forum: RESOLVED - Bugs/Problems (http://www.weberp.org/forum/forumdisplay.php?fid=15)
+---- Thread: Data too long for column 'salesperson' when processing a Sales Order (/showthread.php?tid=2904)

Data too long for column 'salesperson' when processing a Sales Order - eatongerp - 10-04-2016

This error appears on ConfirmDispatch_Invoice.php when processing invoice:

Code:
Database Error 1406 : Sales analysis record could not be added or updated because

Data too long for column 'salesperson' at row 1

Problem = database schema:
The field salesmancode on salesman table has a type varchar(4) while on salesanalysis table, it is char(3).

Solution: fix salesanalysis table

Code:
ALTER TABLE `salesanalysis`     CHANGE `salesperson` `salesperson` VARCHAR(4) DEFAULT '' NOT NULL;