Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unknown column 'defaultshipper' in 'field list'
12-17-2018, 09:00 AM (This post was last modified: 12-17-2018 09:02 AM by rjonesbsink.)
Post: #1
Unknown column 'defaultshipper' in 'field list'
when trying to add a new supplier I get database error 1054 Unknown column 'defaultshipper' in 'field list' and

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 ('3', 'ifixit', '', '', '', '', '', '', '', '', '', '', '1', 'USD', '2018-12-16', '20', '', '0', '', '0', '1', '0', '0', '0', '', '1', '1' )..

this also affects the purchase module when trying to click new purchase order..

Database Error 1054 : The supplier record of the supplier selected: cannot be retrieved because
Unknown column 'suppliers.defaultshipper' in 'field list'


Database SQL Failure : The SQL used to retrieve the supplier details and failed was
SELECT suppliers.suppname, suppliers.currcode, currencies.decimalplaces, suppliers.paymentterms, suppliers.address1, suppliers.address2, suppliers.address3, suppliers.address4, suppliers.address5, suppliers.address6, suppliers.telephone, suppliers.port, suppliers.defaultshipper FROM suppliers INNER JOIN currencies ON suppliers.currcode=currencies.currabrev WHERE supplierid=''


the version of weberp is from GitHub. is this a simple fix
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Unknown column 'defaultshipper' in 'field list' - rjonesbsink - 12-17-2018 09:00 AM

Forum Jump:


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