webERP Forum

Full Version: Failed to add supplier
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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 |
+-----------+
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
Reference URL's