Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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;
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)