web-erp-developers

[WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.

[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.

Re: [WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.

[gilberto d. s. a. <gs...@gm...>]

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

Re: [WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.

[ExsonQu <hex...@gm...>]

*Hi, Wertthey,*

          Thank you for your report!

          I've corrected the field name. Please check if the problem solved
or still exists other problem. 

          Thanks and again and sorry for the errors introduced. 

          Best regards!

          Exson CustomerReceipt.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4657881/CustomerReceipt.zip>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CustomerReceipt-php-issue-seems-like-the-tables-was-not-updated-after-upgrade-tp4657876p4657881.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.

[wertthey <jp...@nu...>]

Thanks *gsavix* for double checking what I was seeing. I had some issues
during the upgrade years ago to 4.01 which I had to do a lot of
modifications to correct my upgrade and was quietly wondering if this was a
lingering issue. 



-----
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-tp4657876p4657885.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.