webERP Forum
Unknown column 'defaultshipper' in 'field list' - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: Unknown column 'defaultshipper' in 'field list' (/showthread.php?tid=8314)



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

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


RE: Unknown column 'defaultshipper' in 'field list' - falkoner - 12-17-2018 07:30 PM

Sorry I should have mentioned if you start from the Github version you need to run the latest sql update script. In this case it is at
sql/mysql/upgrade4.15-4.15.1.sql

Tim


RE: Unknown column 'defaultshipper' in 'field list' - rjonesbsink - 12-18-2018 03:49 AM

Thank you for the info. Would that be the only upgrade I will have to run


RE: Unknown column 'defaultshipper' in 'field list' - falkoner - 12-18-2018 05:20 AM

Yes it will


RE: Unknown column 'defaultshipper' in 'field list' - rjonesbsink - 12-18-2018 06:10 AM

(12-18-2018 05:20 AM)falkoner Wrote:  Yes it will

thanks, i will try this when i get home tonite


RE: Unknown column 'defaultshipper' in 'field list' - rjonesbsink - 12-18-2018 10:10 AM

(12-17-2018 07:30 PM)falkoner Wrote:  Sorry I should have mentioned if you start from the Github version you need to run the latest sql update script. In this case it is at
sql/mysql/upgrade4.15-4.15.1.sql

Tim

I tried to do it throught phpmyadmin and got this error

SQL query:

ALTER TABLE
`suppliers` ADD COLUMN `defaultgl` VARCHAR(20) NOT NULL DEFAULT '1' AFTER `url`

MySQL said:
#1060 - Duplicate column name 'defaultgl'


and it did not complete
(12-18-2018 05:20 AM)falkoner Wrote:  Yes it will

disregard the last message