webERP Forum
Failed to add supplier - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: Failed to add supplier (/showthread.php?tid=8334)



Failed to add supplier - Schnaider Hans - 04-14-2019 07:13 AM

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 - falkoner - 04-14-2019 07:18 AM

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