Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data too long for column 'salesperson' when processing a Sales Order
10-04-2016, 06:59 PM, (This post was last modified: 10-04-2016, 07:00 PM by eatongerp.)
#1
Data too long for column 'salesperson' when processing a Sales Order
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;

Reply


Messages In This Thread
Data too long for column 'salesperson' when processing a Sales Order - by eatongerp - 10-04-2016, 06:59 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)