Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Failed to add supplier
04-14-2019, 07:13 AM
Post: #1
Failed to add supplier
Just installed from Master and I get error when trying to ad a supplier

Quote:Database Error 1054 : The supplier dg could not be added because Unknown column 'defaultshipper' in 'field list'
Quote:Database SQL Failure : The SQL that was used to insert the supplier but failed was
INSERT INTO suppliers (supplierid, suppname, address1, address2, address3, address4, address5, address6, telephone, fax, email, url, supptype, currcode, suppliersince, paymentterms, bankpartics, bankref, bankact, remittance, taxgroupid, factorcompanyid, lat, lng, taxref, defaultshipper, defaultgl) VALUES ('R', 'dg', '', '', '', '', '', '', '', '', '', '', '1', 'RON', '2019-04-14', 'CA', '', '0', '', '0', '1', '0', '0', '0', '', '2', '4100' )

Locking at the database:
Quote: SHOW COLUMNS from suppliers;
+-----------------+--------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+------------+-------+
| supplierid | varchar(10) | NO | PRI | | |
| suppname | varchar(40) | NO | MUL | | |
| address1 | varchar(40) | NO | | | |
| address2 | varchar(40) | NO | | | |
| address3 | varchar(40) | NO | | | |
| address4 | varchar(50) | NO | | | |
| address5 | varchar(20) | NO | | | |
| address6 | varchar(40) | NO | | | |
| supptype | tinyint(4) | NO | | 1 | |
| lat | float(10,6) | NO | | 0.000000 | |
| lng | float(10,6) | NO | | 0.000000 | |
| currcode | char(3) | NO | MUL | | |
| suppliersince | date | NO | | 0000-00-00 | |
| paymentterms | char(2) | NO | MUL | | |
| lastpaid | double | NO | | 0 | |
| lastpaiddate | datetime | YES | | NULL | |
| bankact | varchar(30) | NO | | | |
| bankref | varchar(12) | NO | | | |
| bankpartics | varchar(12) | NO | | | |
| remittance | tinyint(4) | NO | | 1 | |
| taxgroupid | tinyint(4) | NO | MUL | 1 | |
| factorcompanyid | int(11) | NO | | 1 | |
| taxref | varchar(20) | NO | | | |
| phn | varchar(50) | NO | | | |
| port | varchar(200) | NO | | | |
| email | varchar(55) | YES | | NULL | |
| fax | varchar(25) | YES | | NULL | |
| telephone | varchar(25) | YES | | NULL | |
| url | varchar(50) | NO | | | |
+-----------------+--------------+------+-----+------------+-------+

Quote:SELECT confvalue FROM config WHERE confname='VersionNumber';
+-----------+
| confvalue |
+-----------+
| 4.15 |
+-----------+
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Failed to add supplier - Schnaider Hans - 04-14-2019 07:13 AM
RE: Failed to add supplier - falkoner - 04-14-2019, 07:18 AM

Forum Jump:


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