Failed to add supplier - Schnaider Hans - 04-14-2019
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 |
+-----------+
RE: Failed to add supplier - TimSchofield - 04-14-2019
You need to run the latest sql update file. Am only using my phone so can't give you the exact path but look under the sql directory.
Tim
Looking at it now on my laptop the file you need is sql/mysql/upgrade4.15-4.15.1.sql
|