Menu
▾
▴
Re: [WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.
|
From: gilberto d. s. a. <gs...@gm...> - 2014-12-04 20:53:18
|
hi. following is weberp 4.11.3 version table for compare. see that columns also do not exist on 4.11.3. -- Estrutura da tabela `custbranch` -- -- weberp-4-11-3 -- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de Dados: `weberp_4_11_3` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `custbranch` -- CREATE TABLE IF NOT EXISTS `custbranch` ( `branchcode` varchar(10) NOT NULL DEFAULT '', `debtorno` varchar(10) NOT NULL DEFAULT '', `brname` varchar(40) NOT NULL DEFAULT '', `braddress1` varchar(40) NOT NULL DEFAULT '', `braddress2` varchar(40) NOT NULL DEFAULT '', `braddress3` varchar(40) NOT NULL DEFAULT '', `braddress4` varchar(50) NOT NULL DEFAULT '', `braddress5` varchar(20) NOT NULL DEFAULT '', `braddress6` varchar(40) NOT NULL DEFAULT '', `lat` float(10,6) NOT NULL DEFAULT '0.000000', `lng` float(10,6) NOT NULL DEFAULT '0.000000', `estdeliverydays` smallint(6) NOT NULL DEFAULT '1', `area` char(3) NOT NULL, `salesman` varchar(4) NOT NULL DEFAULT '', `fwddate` smallint(6) NOT NULL DEFAULT '0', `phoneno` varchar(20) NOT NULL DEFAULT '', `faxno` varchar(20) NOT NULL DEFAULT '', `contactname` varchar(30) NOT NULL DEFAULT '', `email` varchar(55) NOT NULL DEFAULT '', `defaultlocation` varchar(5) NOT NULL DEFAULT '', `taxgroupid` tinyint(4) NOT NULL DEFAULT '1', `defaultshipvia` int(11) NOT NULL DEFAULT '1', `deliverblind` tinyint(1) DEFAULT '1', `disabletrans` tinyint(4) NOT NULL DEFAULT '0', `brpostaddr1` varchar(40) NOT NULL DEFAULT '', `brpostaddr2` varchar(40) NOT NULL DEFAULT '', `brpostaddr3` varchar(40) NOT NULL DEFAULT '', `brpostaddr4` varchar(50) NOT NULL DEFAULT '', `brpostaddr5` varchar(20) NOT NULL DEFAULT '', `brpostaddr6` varchar(40) NOT NULL DEFAULT '', `specialinstructions` text NOT NULL, `custbranchcode` varchar(30) NOT NULL DEFAULT '', PRIMARY KEY (`branchcode`,`debtorno`), KEY `BrName` (`brname`), KEY `DebtorNo` (`debtorno`), KEY `Salesman` (`salesman`), KEY `Area` (`area`), KEY `DefaultLocation` (`defaultlocation`), KEY `DefaultShipVia` (`defaultshipvia`), KEY `taxgroupid` (`taxgroupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Constraints for dumped tables -- -- -- Limitadores para a tabela `custbranch` -- ALTER TABLE `custbranch` ADD CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES `debtorsmaster` (`debtorno`), ADD CONSTRAINT `custbranch_ibfk_2` FOREIGN KEY (`area`) REFERENCES `areas` (`areacode`), ADD CONSTRAINT `custbranch_ibfk_3` FOREIGN KEY (`salesman`) REFERENCES `salesman` (`salesmancode`), ADD CONSTRAINT `custbranch_ibfk_4` FOREIGN KEY (`defaultlocation`) REFERENCES `locations` (`loccode`), ADD CONSTRAINT `custbranch_ibfk_6` FOREIGN KEY (`defaultshipvia`) REFERENCES `shippers` (`shipper_id`), ADD CONSTRAINT `custbranch_ibfk_7` FOREIGN KEY (`taxgroupid`) REFERENCES `taxgroups` (`taxgroupid`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 2014-12-04 16:13 GMT-02:00 wertthey <jp...@nu...>: > After I upgraded from 4.11.0 to 4.11.5. I have had a few problems > > I will try to accurately display them. > > When trying to post a payment FROM a client I search on the client and It > appears as though there is column missing in my table. it startes that > there is a column called > > custbranch.salesperson which does not exist. It is called from the page > CustomerReceipt.php it appears as though there is a custbranch.salesman > column. > > (Note that When I upgraded to 4.11.5 it did not state that there issues > with > the update.) > > > < > http://weberp-accounting.1478800.n4.nabble.com/file/n4657876/SearchCustomerReceipt.jpg > > > > This is the export of the structure of my table. > > -- phpMyAdmin SQL Dump > -- version 3.4.9 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Dec 04, 2014 at 12:18 PM > -- Server version: 5.5.28 > -- PHP Version: 5.3.10-1ubuntu3.4 > > SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; > SET time_zone = "+00:00"; > > -- > -- Database: `weberp` > -- > > -- -------------------------------------------------------- > > -- > -- Table structure for table `custbranch` > -- > > CREATE TABLE IF NOT EXISTS `custbranch` ( > `branchcode` varchar(10) NOT NULL DEFAULT '', > `debtorno` varchar(10) NOT NULL DEFAULT '', > `brname` varchar(40) NOT NULL DEFAULT '', > `braddress1` varchar(40) NOT NULL DEFAULT '', > `braddress2` varchar(40) NOT NULL DEFAULT '', > `braddress3` varchar(40) NOT NULL DEFAULT '', > `braddress4` varchar(50) NOT NULL DEFAULT '', > `braddress5` varchar(20) NOT NULL DEFAULT '', > `braddress6` varchar(40) NOT NULL DEFAULT '', > `lat` float(10,6) NOT NULL, > `lng` float(10,6) NOT NULL, > `estdeliverydays` smallint(6) NOT NULL DEFAULT '1', > `area` char(3) NOT NULL, > `salesman` varchar(4) NOT NULL DEFAULT '', > `fwddate` smallint(6) NOT NULL DEFAULT '0', > `phoneno` varchar(20) NOT NULL DEFAULT '', > `faxno` varchar(20) NOT NULL DEFAULT '', > `contactname` varchar(30) NOT NULL DEFAULT '', > `email` varchar(55) NOT NULL DEFAULT '', > `defaultlocation` varchar(5) NOT NULL DEFAULT '', > `taxgroupid` tinyint(4) NOT NULL DEFAULT '1', > `defaultshipvia` int(11) NOT NULL DEFAULT '1', > `deliverblind` tinyint(1) DEFAULT '1', > `disabletrans` tinyint(4) NOT NULL DEFAULT '0', > `specialinstructions` varchar(40) NOT NULL DEFAULT '', > `brpostaddr1` varchar(40) NOT NULL DEFAULT '', > `brpostaddr2` varchar(40) NOT NULL DEFAULT '', > `brpostaddr3` varchar(40) NOT NULL DEFAULT '', > `brpostaddr4` varchar(50) NOT NULL DEFAULT '', > `brpostaddr5` varchar(20) NOT NULL DEFAULT '', > `brpostaddr6` varchar(40) NOT NULL DEFAULT '', > `custbranchcode` varchar(30) NOT NULL DEFAULT '', > PRIMARY KEY (`branchcode`,`debtorno`), > KEY `BrName` (`brname`), > KEY `DebtorNo` (`debtorno`), > KEY `Salesman` (`salesman`), > KEY `Area` (`area`), > KEY `DefaultLocation` (`defaultlocation`), > KEY `DefaultShipVia` (`defaultshipvia`), > KEY `taxgroupid` (`taxgroupid`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- > -- Constraints for dumped tables > -- > > -- > -- Constraints for table `custbranch` > -- > ALTER TABLE `custbranch` > ADD CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES > `debtorsmaster` (`debtorno`), > ADD CONSTRAINT `custbranch_ibfk_2` FOREIGN KEY (`area`) REFERENCES > `areas` > (`areacode`), > ADD CONSTRAINT `custbranch_ibfk_3` FOREIGN KEY (`salesman`) REFERENCES > `salesman` (`salesmancode`), > ADD CONSTRAINT `custbranch_ibfk_4` FOREIGN KEY (`defaultlocation`) > REFERENCES `locations` (`loccode`), > ADD CONSTRAINT `custbranch_ibfk_6` FOREIGN KEY (`defaultshipvia`) > REFERENCES `shippers` (`shipper_id`), > ADD CONSTRAINT `custbranch_ibfk_7` FOREIGN KEY (`taxgroupid`) REFERENCES > `taxgroups` (`taxgroupid`); > > > > ----- > Using weberp since 2004 > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/CustomerReceipt-php-issue-seems-like-the-tables-was-not-updated-after-upgrade-tp4657876.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil |
