Re: SelectOrderItems issue

View: New views
2 Messages — Rating Filter:   Alert me  

Parent Message unknown Re: SelectOrderItems issue

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Paul,

Is there a reason you stopped at -rc2 and not the full 3.11 release?
I'm not sure that this is related to your problem but if you could
upgrade to 3.11 it would help in diagnosing the problem.

Thanks
Tim


2009/10/29 lnichols <p.taylor@...>:

>
> Hi all,
>
> Apologies if this is a stupid question, I can't find anything previously
> posted however regarding this issue.
>
> We are currently running 3.11-rc2 with the latest mysql updates applied, I
> have inherited this system so am somewhat new to it.
>
> On the SelectOrderItems page, when initially selecting a customer, we are
> receiving the following error:
>
> ERROR Message Report : The branch details for branch code: against customer
> code: SP3 could not be retrieved. Check the set up of the customer and
> branch
>
> The SQL that failed to get the branch details was:
> SELECT custbranch.brname, custbranch.braddress1, custbranch.braddress2,
> custbranch.braddress3, custbranch.braddress4, custbranch.braddress5,
> custbranch.braddress6, custbranch.phoneno, custbranch.email,
> custbranch.defaultlocation, custbranch.defaultshipvia,
> custbranch.deliverblind, custbranch.specialinstructions,
> custbranch.estdeliverydays, locations.locationname, custbranch.salesman FROM
> custbranch INNER JOIN locations ON
> custbranch.defaultlocation=locations.loccode WHERE custbranch.branchcode=''
> AND custbranch.debtorno = 'SP3'
>
> In the code, I have traced this down to being a problem around line 386,
> where the $_POST['Select'] value is allocated to
> $_SESSION['Items'.$identifier]->Branch, which does not appear to be
> happening. The POST value is set to the correct value at this stage however.
> >From experimenting, and hard-coding this value into the query, the correct
> branch is loaded, but the page only displays a credit warning for the
> customer, nothing regarding adding a new order into the system.
>
> I'm sure it must be something simple, didn't want to hack into the code
> myself however, as I imagine there will be a better solution!
>
>
> Any help greatly appreciated
>
>
> Paul
> --
> View this message in context: http://www.nabble.com/SelectOrderItems-issue-tp26111897p26111897.html
> Sent from the web-erp-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: SelectOrderItems issue

by lnichols :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Tim,

Not at all, just because that is what has been passed over to me! I solved this in the end, it was just down to the session.auto_start issue, which I should probably have probably clocked onto myself!

Will look into upgrading to 3.11 proper, thanks for response


Paul


Tim Schofield wrote:
Hi Paul,

Is there a reason you stopped at -rc2 and not the full 3.11 release?
I'm not sure that this is related to your problem but if you could
upgrade to 3.11 it would help in diagnosing the problem.

Thanks
Tim


2009/10/29 lnichols <p.taylor@laranichols.com>:
>
> Hi all,
>
> Apologies if this is a stupid question, I can't find anything previously
> posted however regarding this issue.
>
> We are currently running 3.11-rc2 with the latest mysql updates applied, I
> have inherited this system so am somewhat new to it.
>
> On the SelectOrderItems page, when initially selecting a customer, we are
> receiving the following error:
>
> ERROR Message Report : The branch details for branch code: against customer
> code: SP3 could not be retrieved. Check the set up of the customer and
> branch
>
> The SQL that failed to get the branch details was:
> SELECT custbranch.brname, custbranch.braddress1, custbranch.braddress2,
> custbranch.braddress3, custbranch.braddress4, custbranch.braddress5,
> custbranch.braddress6, custbranch.phoneno, custbranch.email,
> custbranch.defaultlocation, custbranch.defaultshipvia,
> custbranch.deliverblind, custbranch.specialinstructions,
> custbranch.estdeliverydays, locations.locationname, custbranch.salesman FROM
> custbranch INNER JOIN locations ON
> custbranch.defaultlocation=locations.loccode WHERE custbranch.branchcode=''
> AND custbranch.debtorno = 'SP3'
>
> In the code, I have traced this down to being a problem around line 386,
> where the $_POST['Select'] value is allocated to
> $_SESSION['Items'.$identifier]->Branch, which does not appear to be
> happening. The POST value is set to the correct value at this stage however.
> >From experimenting, and hard-coding this value into the query, the correct
> branch is loaded, but the page only displays a credit warning for the
> customer, nothing regarding adding a new order into the system.
>
> I'm sure it must be something simple, didn't want to hack into the code
> myself however, as I imagine there will be a better solution!
>
>
> Any help greatly appreciated
>
>
> Paul
> --
> View this message in context: http://www.nabble.com/SelectOrderItems-issue-tp26111897p26111897.html
> Sent from the web-erp-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-developers