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
04-14-2019, 07:18 AM (This post was last modified: 04-14-2019 08:55 AM by falkoner.)
Post: #2
RE: Failed to add supplier
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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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