Thread: [webERP-users] Error in demo

Accounting & Best Practice Business Administration System

Brought to you by: daintree, exsonqu, rchacon, tim_schofield, turbopt

web-erp-users

[webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-25 09:25:13

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I try to add a new order but error as below.<br>
<br>
<div class="error">
<p><b>Database Error</b> : <br>
Cannot add or update a child row: a foreign key constraint fails</p>
</div>
<b>Database SQL Failure</b> : The SQL that failed was<br>
INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode,
unitprice, quantity, discountpercent, narrative, poline, itemdue)
VALUES (0, 544, '0012', 30, 120, 0, '', '', '2008/04/05' )<br>
<br>
Thanks<br>
<br>
</body>
</html>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-25 09:49:06

This corrected now, the data in the demo looked like it had got
corrupted somehow.

Tim


On 25/03/2008, Romel <ste...@ya...> wrote:
> I try to add a new order but error as below.
>
>
>
> Database Error :
> Cannot add or update a child row: a foreign key constraint failsDatabase SQL
> Failure : The SQL that failed was
> INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice,
> quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544,
> '0012', 30, 120, 0, '', '', '2008/04/05' )
>
> Thanks
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

Re: [webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-26 18:23:17

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tried already, but same problem in entering a new sale order.&nbsp; No
changed.<br>
<br>
Steven<br>
<br>
Tim Schofield &#25552;&#21040;:
<blockquote
 cite="mid:1ca...@ma..."
 type="cite">
  <pre wrap="">This corrected now, the data in the demo looked like it had got
corrupted somehow.

Tim


On 25/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I try to add a new order but error as below.



Database Error :
Cannot add or update a child row: a foreign key constraint failsDatabase SQL
Failure : The SQL that failed was
INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice,
quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544,
'0012', 30, 120, 0, '', '', '2008/04/05' )

Thanks


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
<a class="moz-txt-link-freetext" href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>


    </pre>
  </blockquote>
  <pre wrap=""><!---->
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
<a class="moz-txt-link-freetext" href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>

  </pre>
</blockquote>
</body>
</html>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-26 18:44:00

I have reset it again. The demo data needs wiping and starting from
scratch. I have entered a couple of orders and they work fine.

Tim

On 26/03/2008, Romel <ste...@ya...> wrote:
>
>  Tried already, but same problem in entering a new sale order.  No changed.
>
>  Steven
>
>  Tim Schofield 提到:
>  This corrected now, the data in the demo looked like it had got
> corrupted somehow.
>
> Tim
>
>
> On 25/03/2008, Romel <ste...@ya...> wrote:
>
>
>  I try to add a new order but error as below.
>
>
>
> Database Error :
> Cannot add or update a child row: a foreign key constraint failsDatabase SQL
> Failure : The SQL that failed was
> INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice,
> quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544,
> '0012', 30, 120, 0, '', '', '2008/04/05' )
>
> Thanks
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
>
> -------------------------------------------------------------------------
>  Check out the new SourceForge.net Marketplace.
>  It's the best place to buy or sell services for
>  just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
>  web-ERP-users mailing list
>  web...@li...
>  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-27 13:38:18

I am confused by this. Whenever I leave it an hour or so, the demo
seems to get this problem. But when I try to break it, and I've just
sat here for ages putting in sales orders, trying silly data, choosing
silly options, it refuses to break. Anyone any ideas?

Tim


On 26/03/2008, Tim Schofield <tim...@go...> wrote:
> I have reset it again. The demo data needs wiping and starting from
> scratch. I have entered a couple of orders and they work fine.
>
> Tim
>
> On 26/03/2008, Romel <ste...@ya...> wrote:
> >
> >  Tried already, but same problem in entering a new sale order.  No changed.
> >
> >  Steven
> >
> >  Tim Schofield 提到:
> >  This corrected now, the data in the demo looked like it had got
> > corrupted somehow.
> >
> > Tim
> >
> >
> > On 25/03/2008, Romel <ste...@ya...> wrote:
> >
> >
> >  I try to add a new order but error as below.
> >
> >
> >
> > Database Error :
> > Cannot add or update a child row: a foreign key constraint failsDatabase SQL
> > Failure : The SQL that failed was
> > INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice,
> > quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544,
> > '0012', 30, 120, 0, '', '', '2008/04/05' )
> >
> > Thanks
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > web-ERP-users mailing list
> > web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-users
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > web-ERP-users mailing list
> > web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-users
> >
> >
> >
> > -------------------------------------------------------------------------
> >  Check out the new SourceForge.net Marketplace.
> >  It's the best place to buy or sell services for
> >  just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> > _______________________________________________
> >  web-ERP-users mailing list
> >  web...@li...
> >  https://lists.sourceforge.net/lists/listinfo/web-erp-users
> >
> >
>

Re: [webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-28 06:42:29

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I have another error when trying. function opendir error in stocks.php.<br>
<br>
may be the php version or setting is correct.  Will you think about
rebuild a blank sql DB?<br>
<br>
Actually, the main purpose of the test in demo is testing the function
of:<br>
<br>
1. multi delivery and input of same item in one Sale order.<br>
2. If invoicing for above sale order is ok.<br>
3. if the print out invoice show the customer po in sale order.  And
how it show.<br>
<br>
one more mistake in entering new sale order, the input customer code is
mistake as item code.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Tim Schofield 提到:
<blockquote
 cite="mid:1ca...@ma..."
 type="cite">
  <pre wrap="">I am confused by this. Whenever I leave it an hour or so, the demo
seems to get this problem. But when I try to break it, and I've just
sat here for ages putting in sales orders, trying silly data, choosing
silly options, it refuses to break. Anyone any ideas?

Tim


On 26/03/2008, Tim Schofield <a class="moz-txt-link-rfc2396E" href="mailto:tim...@go...">&lt;tim...@go...&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I have reset it again. The demo data needs wiping and starting from
scratch. I have entered a couple of orders and they work fine.

Tim

On 26/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:
    </pre>
    <blockquote type="cite">
      <pre wrap=""> Tried already, but same problem in entering a new sale order.  No changed.

 Steven

 Tim Schofield 提到:
 This corrected now, the data in the demo looked like it had got
corrupted somehow.

Tim


On 25/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:


 I try to add a new order but error as below.



Database Error :
Cannot add or update a child row: a foreign key constraint failsDatabase SQL
Failure : The SQL that failed was
INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice,
quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544,
'0012', 30, 120, 0, '', '', '2008/04/05' )

Thanks


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
<a class="moz-txt-link-freetext" href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
<a class="moz-txt-link-freetext" href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>



-------------------------------------------------------------------------
 Check out the new SourceForge.net Marketplace.
 It's the best place to buy or sell services for
 just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
 web-ERP-users mailing list
 <a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
 <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>


      </pre>
    </blockquote>
  </blockquote>
  <pre wrap=""><!---->-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>
  </pre>
</blockquote>
</body>
</html>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-28 08:44:13

Hi

On 28/03/2008, Romel <ste...@ya...> wrote:
> I have another error when trying. function opendir error in stocks.php.

I have corrected this.

>
> may be the php version or setting is correct.  Will you think about rebuild
> a blank sql DB?
>
> Actually, the main purpose of the test in demo is testing the function of:
>
> 1. multi delivery and input of same item in one Sale order.
> 2. If invoicing for above sale order is ok.
> 3. if the print out invoice show the customer po in sale order.  And how it
> show.

If you are evaluating webERP for your own use, I would strongly
recommend that you set it up on a local machine. The demo is there for
people to get a feel for the software, but with access given to
anybody that chances by the data is always going to become "strange".

>
> one more mistake in entering new sale order, the input customer code is
> mistake as item code.

I can't re-create this, though I do remember a problem like this that
got corrected, but it may have been after the version that is
currently on the demo. Can you give me steps to recreate?

>

Thanks
Tim

Re: [webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-29 02:11:58

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
HI<br>
<br>
I was using webERP since 3.04,&nbsp; so I would like to learn and test some
changes and functions before use in the real system.&nbsp; It is also
because many new function need to try by ourself without instruction,
but don't want to disturbed the real data.&nbsp; <br>
<br>
Other hand, is there any detail history of change in offical website?&nbsp; <br>
<br>
Thanks.<br>
<br>
Steven<br>
<br>
Tim Schofield &#25552;&#21040;:
<blockquote
 cite="mid:1ca...@ma..."
 type="cite">
  <pre wrap="">Hi

On 28/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I have another error when trying. function opendir error in stocks.php.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
I have corrected this.

  </pre>
  <blockquote type="cite">
    <pre wrap="">may be the php version or setting is correct.  Will you think about rebuild
a blank sql DB?

Actually, the main purpose of the test in demo is testing the function of:

1. multi delivery and input of same item in one Sale order.
2. If invoicing for above sale order is ok.
3. if the print out invoice show the customer po in sale order.  And how it
show.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
If you are evaluating webERP for your own use, I would strongly
recommend that you set it up on a local machine. The demo is there for
people to get a feel for the software, but with access given to
anybody that chances by the data is always going to become "strange".

  </pre>
  <blockquote type="cite">
    <pre wrap="">one more mistake in entering new sale order, the input customer code is
mistake as item code.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
I can't re-create this, though I do remember a problem like this that
got corrected, but it may have been after the version that is
currently on the demo. Can you give me steps to recreate?

  </pre>
  <pre wrap=""><!---->
Thanks
Tim

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>

  </pre>
</blockquote>
</body>
</html>

Re: [webERP-users] Error in demo

From: Phil D. <ph...@lo...> - 2008-03-29 04:37:50

You should set yourself up with a test system under a different 
directory and perhaps referring to a copy of your live database as of 
yesterday.

I set a script up at a client to load the backup of the live database 
into a demo database each night so the demo always refers to real life data.

Phil


Romel wrote:
> HI
>
> I was using webERP since 3.04, so I would like to learn and test some 
> changes and functions before use in the real system. It is also 
> because many new function need to try by ourself without instruction, 
> but don't want to disturbed the real data.
>
> Other hand, is there any detail history of change in offical website?
>
> Thanks.
>
> Steven
>
> Tim Schofield 提到:
>> Hi
>>
>> On 28/03/2008, Romel <ste...@ya...> wrote:
>>   
>>> I have another error when trying. function opendir error in stocks.php.
>>>     
>>
>> I have corrected this.
>>
>>   
>>> may be the php version or setting is correct.  Will you think about rebuild
>>> a blank sql DB?
>>>
>>> Actually, the main purpose of the test in demo is testing the function of:
>>>
>>> 1. multi delivery and input of same item in one Sale order.
>>> 2. If invoicing for above sale order is ok.
>>> 3. if the print out invoice show the customer po in sale order.  And how it
>>> show.
>>>     
>>
>> If you are evaluating webERP for your own use, I would strongly
>> recommend that you set it up on a local machine. The demo is there for
>> people to get a feel for the software, but with access given to
>> anybody that chances by the data is always going to become "strange".
>>
>>   
>>> one more mistake in entering new sale order, the input customer code is
>>> mistake as item code.
>>>     
>>
>> I can't re-create this, though I do remember a problem like this that
>> got corrected, but it may have been after the version that is
>> currently on the demo. Can you give me steps to recreate?
>>
>>   
>>
>> Thanks
>> Tim
>>
>> -------------------------------------------------------------------------
>> Check out the new SourceForge.net Marketplace.
>> It's the best place to buy or sell services for
>> just about anything Open Source.
>> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>> _______________________________________________
>> web-ERP-users mailing list
>> web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>   
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> ------------------------------------------------------------------------
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-30 01:35:34

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
It is a very good idea, in testing and also backup.  But mine is
hosting and only one mysql account.  <br>
<br>
However, I will try another solution to setup a dummy as you said.<br>
<br>
Thanks.<br>
<br>
<br>
<br>
Phil Daintree 提到:
<blockquote cite="mid:47E...@lo..." type="cite">
  <pre wrap="">You should set yourself up with a test system under a different 
directory and perhaps referring to a copy of your live database as of 
yesterday.

I set a script up at a client to load the backup of the live database 
into a demo database each night so the demo always refers to real life data.

Phil


Romel wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">HI

I was using webERP since 3.04, so I would like to learn and test some 
changes and functions before use in the real system. It is also 
because many new function need to try by ourself without instruction, 
but don't want to disturbed the real data.

Other hand, is there any detail history of change in offical website?

Thanks.

Steven

Tim Schofield 提到:
    </pre>
    <blockquote type="cite">
      <pre wrap="">Hi

On 28/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:
  
      </pre>
      <blockquote type="cite">
        <pre wrap="">I have another error when trying. function opendir error in stocks.php.
    
        </pre>
      </blockquote>
      <pre wrap="">I have corrected this.

  
      </pre>
      <blockquote type="cite">
        <pre wrap="">may be the php version or setting is correct.  Will you think about rebuild
a blank sql DB?

Actually, the main purpose of the test in demo is testing the function of:

1. multi delivery and input of same item in one Sale order.
2. If invoicing for above sale order is ok.
3. if the print out invoice show the customer po in sale order.  And how it
show.
    
        </pre>
      </blockquote>
      <pre wrap="">If you are evaluating webERP for your own use, I would strongly
recommend that you set it up on a local machine. The demo is there for
people to get a feel for the software, but with access given to
anybody that chances by the data is always going to become "strange".

  
      </pre>
      <blockquote type="cite">
        <pre wrap="">one more mistake in entering new sale order, the input customer code is
mistake as item code.
    
        </pre>
      </blockquote>
      <pre wrap="">I can't re-create this, though I do remember a problem like this that
got corrected, but it may have been after the version that is
currently on the demo. Can you give me steps to recreate?

  

Thanks
Tim

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>

  
      </pre>
    </blockquote>
    <pre wrap="">------------------------------------------------------------------------

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
------------------------------------------------------------------------

_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>
  
    </pre>
  </blockquote>
  <pre wrap=""><!---->

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>
  </pre>
</blockquote>
</body>
</html>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-30 14:43:32

To make it easier for those who want to follow cvs changes, I have
opened a mailing list (web...@li...) which will
have all changes to cvs automatically sent to it, thereby lessening my
feelings of guilt when I forget to update the change log. This can be
subscribed to in the normal way through our sourceforge pages.

Tim


On 30/03/2008, Tim Schofield <tim...@go...> wrote:
> Phil is being kind here, what he means is that I am hopeless at
>  keeping the change log up to date. :-)
>
>  I still think it would be easy enough to keep a local version, it is a
>  fairly easy task to set webERP up on anything from a win2000 machine
>  upwards or any version of Linux.
>
>
>  Tim
>
>
>
>  On 30/03/2008, Phil Daintree <ph...@lo...> wrote:
>  > I try to maintain a change log - which is committed to cvs each time
>  >  there is a change... I must say it is hard to remember to do the change
>  >  log with each update so a fair bit gets missed.
>  >
>  >  For what it's worth it is at:
>  >
>  >  http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup
>  >
>  >
>  >  Phil
>  >
>  >
>  >
>  >  Romel wrote:
>  >  > HI
>  >  >
>  >  > I was using webERP since 3.04, so I would like to learn and test some
>  >  > changes and functions before use in the real system. It is also
>  >  > because many new function need to try by ourself without instruction,
>  >  > but don't want to disturbed the real data.
>  >  >
>  >  > Other hand, is there any detail history of change in offical website?
>  >  >
>  >  > Thanks.
>  >  >
>  >  > Steven
>  >  >
>  >  > Tim Schofield 提到:
>  >  >> Hi
>  >  >>
>  >  >> On 28/03/2008, Romel <ste...@ya...> wrote:
>  >  >>
>  >  >>> I have another error when trying. function opendir error in stocks.php.
>  >  >>>
>  >  >>
>  >  >> I have corrected this.
>  >  >>
>  >  >>
>  >  >>> may be the php version or setting is correct.  Will you think about rebuild
>  >  >>> a blank sql DB?
>  >  >>>
>  >  >>> Actually, the main purpose of the test in demo is testing the function of:
>  >  >>>
>  >  >>> 1. multi delivery and input of same item in one Sale order.
>  >  >>> 2. If invoicing for above sale order is ok.
>  >  >>> 3. if the print out invoice show the customer po in sale order.  And how it
>  >  >>> show.
>  >  >>>
>  >  >>
>  >  >> If you are evaluating webERP for your own use, I would strongly
>  >  >> recommend that you set it up on a local machine. The demo is there for
>  >  >> people to get a feel for the software, but with access given to
>  >  >> anybody that chances by the data is always going to become "strange".
>  >  >>
>  >  >>
>  >  >>> one more mistake in entering new sale order, the input customer code is
>  >  >>> mistake as item code.
>  >  >>>
>  >  >>
>  >  >> I can't re-create this, though I do remember a problem like this that
>  >  >> got corrected, but it may have been after the version that is
>  >  >> currently on the demo. Can you give me steps to recreate?
>  >  >>
>  >  >>
>  >  >>
>  >  >> Thanks
>  >  >> Tim
>  >  >>
>  >  >
>  >
>  >
>  >  -------------------------------------------------------------------------
>  >  Check out the new SourceForge.net Marketplace.
>  >  It's the best place to buy or sell services for
>  >  just about anything Open Source.
>  >  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>  >  _______________________________________________
>  >  web-ERP-users mailing list
>  >  web...@li...
>  >  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>  >
>

Re: [webERP-users] Error in demo

From: Romel <ste...@ya...> - 2008-03-31 03:34:37

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Tim &amp; Phil,<br>
<br>
Thanks for your kindly reply.  I already add my email in cvs mail lists.<br>
<br>
Steven.<br>
<br>
Tim Schofield 提到:
<blockquote
 cite="mid:1ca...@ma..."
 type="cite">
  <pre wrap="">To make it easier for those who want to follow cvs changes, I have
opened a mailing list (<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>) which will
have all changes to cvs automatically sent to it, thereby lessening my
feelings of guilt when I forget to update the change log. This can be
subscribed to in the normal way through our sourceforge pages.

Tim


On 30/03/2008, Tim Schofield <a class="moz-txt-link-rfc2396E" href="mailto:tim...@go...">&lt;tim...@go...&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Phil is being kind here, what he means is that I am hopeless at
 keeping the change log up to date. :-)

 I still think it would be easy enough to keep a local version, it is a
 fairly easy task to set webERP up on anything from a win2000 machine
 upwards or any version of Linux.


 Tim



 On 30/03/2008, Phil Daintree <a class="moz-txt-link-rfc2396E" href="mailto:ph...@lo...">&lt;ph...@lo...&gt;</a> wrote:
 &gt; I try to maintain a change log - which is committed to cvs each time
 &gt;  there is a change... I must say it is hard to remember to do the change
 &gt;  log with each update so a fair bit gets missed.
 &gt;
 &gt;  For what it's worth it is at:
 &gt;
 &gt;  <a class="moz-txt-link-freetext" href="http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup">http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup</a>
 &gt;
 &gt;
 &gt;  Phil
 &gt;
 &gt;
 &gt;
 &gt;  Romel wrote:
 &gt;  &gt; HI
 &gt;  &gt;
 &gt;  &gt; I was using webERP since 3.04, so I would like to learn and test some
 &gt;  &gt; changes and functions before use in the real system. It is also
 &gt;  &gt; because many new function need to try by ourself without instruction,
 &gt;  &gt; but don't want to disturbed the real data.
 &gt;  &gt;
 &gt;  &gt; Other hand, is there any detail history of change in offical website?
 &gt;  &gt;
 &gt;  &gt; Thanks.
 &gt;  &gt;
 &gt;  &gt; Steven
 &gt;  &gt;
 &gt;  &gt; Tim Schofield 提到:
 &gt;  &gt;&gt; Hi
 &gt;  &gt;&gt;
 &gt;  &gt;&gt; On 28/03/2008, Romel <a class="moz-txt-link-rfc2396E" href="mailto:ste...@ya...">&lt;ste...@ya...&gt;</a> wrote:
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;&gt; I have another error when trying. function opendir error in stocks.php.
 &gt;  &gt;&gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt; I have corrected this.
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;&gt; may be the php version or setting is correct.  Will you think about rebuild
 &gt;  &gt;&gt;&gt; a blank sql DB?
 &gt;  &gt;&gt;&gt;
 &gt;  &gt;&gt;&gt; Actually, the main purpose of the test in demo is testing the function of:
 &gt;  &gt;&gt;&gt;
 &gt;  &gt;&gt;&gt; 1. multi delivery and input of same item in one Sale order.
 &gt;  &gt;&gt;&gt; 2. If invoicing for above sale order is ok.
 &gt;  &gt;&gt;&gt; 3. if the print out invoice show the customer po in sale order.  And how it
 &gt;  &gt;&gt;&gt; show.
 &gt;  &gt;&gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt; If you are evaluating webERP for your own use, I would strongly
 &gt;  &gt;&gt; recommend that you set it up on a local machine. The demo is there for
 &gt;  &gt;&gt; people to get a feel for the software, but with access given to
 &gt;  &gt;&gt; anybody that chances by the data is always going to become "strange".
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;&gt; one more mistake in entering new sale order, the input customer code is
 &gt;  &gt;&gt;&gt; mistake as item code.
 &gt;  &gt;&gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt; I can't re-create this, though I do remember a problem like this that
 &gt;  &gt;&gt; got corrected, but it may have been after the version that is
 &gt;  &gt;&gt; currently on the demo. Can you give me steps to recreate?
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt;
 &gt;  &gt;&gt; Thanks
 &gt;  &gt;&gt; Tim
 &gt;  &gt;&gt;
 &gt;  &gt;
 &gt;
 &gt;
 &gt;  -------------------------------------------------------------------------
 &gt;  Check out the new SourceForge.net Marketplace.
 &gt;  It's the best place to buy or sell services for
 &gt;  just about anything Open Source.
 &gt;  <a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
 &gt;  _______________________________________________
 &gt;  web-ERP-users mailing list
 &gt;  <a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
 &gt;  <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>
 &gt;

    </pre>
  </blockquote>
  <pre wrap=""><!---->-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
<a class="moz-txt-link-freetext" href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</a>
_______________________________________________
web-ERP-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:web...@li...">web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-users">https://lists.sourceforge.net/lists/listinfo/web-erp-users</a>
  </pre>
</blockquote>
</body>
</html>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-30 18:10:34

Thanks Ian, can you check out the latest version of Areas.php from
cvs, and see if the problem still happens.

Thanks
Tim


On 30/03/2008, Ian McNulty <ia...@mc...> wrote:
> I've been testing the latest csv and getting quite a few Database SQL
>  failures so I decided to and started again from scratch testing 2 fresh
>  local installs of webERP side-by-side (using Apache VirtualHost, PHP
>  5.2.5 and MySQL 5.0.45)
>
>  1) http://weberp-v3.08 runs on files from the downloaded zip with DB
>  weberp-308 (created from weberp-new.sql)
>  2) http://webERP-cvs runs on files from the cvs with DB weberp-cvs
>  (created from cvs version of weberp-new.sql)
>
>  I'm working step-by-step through Create New System (from the Manual).
>
>  All goes well until I try to set up Sales Areas.
>
>  Installation 1) works no problems.
>
>  But installation 2) returns:
>
>  *Database Error* :
>  Unknown column 'EU' in 'where clause'
>
>
>  *Database SQL Failure* : The SQL that failed was
>
> SELECT count(areacode) from areas WHERE areacode="EU"
>
>  Don't know if this is a bug or not, but thought I ought to report it anyway.
>
>
>  Ian
>
>
>
>  Tim Schofield wrote:
>  > To make it easier for those who want to follow cvs changes, I have
>  > opened a mailing list (web...@li...) which will
>  > have all changes to cvs automatically sent to it, thereby lessening my
>  > feelings of guilt when I forget to update the change log. This can be
>  > subscribed to in the normal way through our sourceforge pages.
>  >
>  > Tim
>  >
>  >
>  > On 30/03/2008, Tim Schofield <tim...@go...> wrote:
>  >
>  >> Phil is being kind here, what he means is that I am hopeless at
>  >>  keeping the change log up to date. :-)
>  >>
>  >>  I still think it would be easy enough to keep a local version, it is a
>  >>  fairly easy task to set webERP up on anything from a win2000 machine
>  >>  upwards or any version of Linux.
>  >>
>  >>
>  >>  Tim
>  >>
>  >>
>  >>
>  >>  On 30/03/2008, Phil Daintree <ph...@lo...> wrote:
>  >>  > I try to maintain a change log - which is committed to cvs each time
>  >>  >  there is a change... I must say it is hard to remember to do the change
>  >>  >  log with each update so a fair bit gets missed.
>  >>  >
>  >>  >  For what it's worth it is at:
>  >>  >
>  >>  >  http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup
>  >>  >
>  >>  >
>  >>  >  Phil
>  >>  >
>  >>  >
>  >>  >
>  >>  >  Romel wrote:
>  >>  >  > HI
>  >>  >  >
>  >>  >  > I was using webERP since 3.04, so I would like to learn and test some
>  >>  >  > changes and functions before use in the real system. It is also
>  >>  >  > because many new function need to try by ourself without instruction,
>  >>  >  > but don't want to disturbed the real data.
>  >>  >  >
>  >>  >  > Other hand, is there any detail history of change in offical website?
>  >>  >  >
>  >>  >  > Thanks.
>  >>  >  >
>  >>  >  > Steven
>  >>  >  >
>  >>  >  > Tim Schofield 提到:
>  >>  >  >> Hi
>  >>  >  >>
>  >>  >  >> On 28/03/2008, Romel <ste...@ya...> wrote:
>  >>  >  >>
>  >>  >  >>> I have another error when trying. function opendir error in stocks.php.
>  >>  >  >>>
>  >>  >  >>
>  >>  >  >> I have corrected this.
>  >>  >  >>
>  >>  >  >>
>  >>  >  >>> may be the php version or setting is correct.  Will you think about rebuild
>  >>  >  >>> a blank sql DB?
>  >>  >  >>>
>  >>  >  >>> Actually, the main purpose of the test in demo is testing the function of:
>  >>  >  >>>
>  >>  >  >>> 1. multi delivery and input of same item in one Sale order.
>  >>  >  >>> 2. If invoicing for above sale order is ok.
>  >>  >  >>> 3. if the print out invoice show the customer po in sale order.  And how it
>  >>  >  >>> show.
>  >>  >  >>>
>  >>  >  >>
>  >>  >  >> If you are evaluating webERP for your own use, I would strongly
>  >>  >  >> recommend that you set it up on a local machine. The demo is there for
>  >>  >  >> people to get a feel for the software, but with access given to
>  >>  >  >> anybody that chances by the data is always going to become "strange".
>  >>  >  >>
>  >>  >  >>
>  >>  >  >>> one more mistake in entering new sale order, the input customer code is
>  >>  >  >>> mistake as item code.
>  >>  >  >>>
>  >>  >  >>
>  >>  >  >> I can't re-create this, though I do remember a problem like this that
>  >>  >  >> got corrected, but it may have been after the version that is
>  >>  >  >> currently on the demo. Can you give me steps to recreate?
>  >>  >  >>
>  >>  >  >>
>  >>  >  >>
>  >>  >  >> Thanks
>  >>  >  >> Tim
>  >>  >  >>
>  >>  >  >
>  >>  >
>  >>  >
>  >>  >  -------------------------------------------------------------------------
>  >>  >  Check out the new SourceForge.net Marketplace.
>  >>  >  It's the best place to buy or sell services for
>  >>  >  just about anything Open Source.
>  >>  >  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>  >>  >  _______________________________________________
>  >>  >  web-ERP-users mailing list
>  >>  >  web...@li...
>  >>  >  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>  >>  >
>  >>
>  >>
>  > -------------------------------------------------------------------------
>  > Check out the new SourceForge.net Marketplace.
>  > It's the best place to buy or sell services for
>  > just about anything Open Source.
>  > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>  > _______________________________________________
>  > web-ERP-users mailing list
>  > web...@li...
>  > https://lists.sourceforge.net/lists/listinfo/web-erp-users
>  >
>
>  -------------------------------------------------------------------------
>  Check out the new SourceForge.net Marketplace.
>  It's the best place to buy or sell services for
>  just about anything Open Source.
>  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>  _______________________________________________
>  web-ERP-users mailing list
>  web...@li...
>  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [webERP-users] Error in demo

From: Ian M. <ia...@mc...> - 2008-03-30 18:43:11

Many thanks Tim. That's a worker.

Onwards and upwards!

Ian


Tim Schofield wrote:
> Thanks Ian, can you check out the latest version of Areas.php from
> cvs, and see if the problem still happens.
>
> Thanks
> Tim
>
>
> On 30/03/2008, Ian McNulty <ia...@mc...> wrote:
>   
>> I've been testing the latest csv and getting quite a few Database SQL
>>  failures so I decided to and started again from scratch testing 2 fresh
>>  local installs of webERP side-by-side (using Apache VirtualHost, PHP
>>  5.2.5 and MySQL 5.0.45)
>>
>>  1) http://weberp-v3.08 runs on files from the downloaded zip with DB
>>  weberp-308 (created from weberp-new.sql)
>>  2) http://webERP-cvs runs on files from the cvs with DB weberp-cvs
>>  (created from cvs version of weberp-new.sql)
>>
>>  I'm working step-by-step through Create New System (from the Manual).
>>
>>  All goes well until I try to set up Sales Areas.
>>
>>  Installation 1) works no problems.
>>
>>  But installation 2) returns:
>>
>>  *Database Error* :
>>  Unknown column 'EU' in 'where clause'
>>
>>
>>  *Database SQL Failure* : The SQL that failed was
>>
>> SELECT count(areacode) from areas WHERE areacode="EU"
>>
>>  Don't know if this is a bug or not, but thought I ought to report it anyway.
>>
>>
>>  Ian
>>
>>
>>
>>  Tim Schofield wrote:
>>  > To make it easier for those who want to follow cvs changes, I have
>>  > opened a mailing list (web...@li...) which will
>>  > have all changes to cvs automatically sent to it, thereby lessening my
>>  > feelings of guilt when I forget to update the change log. This can be
>>  > subscribed to in the normal way through our sourceforge pages.
>>  >
>>  > Tim
>>  >
>>  >
>>  > On 30/03/2008, Tim Schofield <tim...@go...> wrote:
>>  >
>>  >> Phil is being kind here, what he means is that I am hopeless at
>>  >>  keeping the change log up to date. :-)
>>  >>
>>  >>  I still think it would be easy enough to keep a local version, it is a
>>  >>  fairly easy task to set webERP up on anything from a win2000 machine
>>  >>  upwards or any version of Linux.
>>  >>
>>  >>
>>  >>  Tim
>>  >>
>>  >>
>>  >>
>>  >>  On 30/03/2008, Phil Daintree <ph...@lo...> wrote:
>>  >>  > I try to maintain a change log - which is committed to cvs each time
>>  >>  >  there is a change... I must say it is hard to remember to do the change
>>  >>  >  log with each update so a fair bit gets missed.
>>  >>  >
>>  >>  >  For what it's worth it is at:
>>  >>  >
>>  >>  >  http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup
>>  >>  >
>>  >>  >
>>  >>  >  Phil
>>  >>  >
>>  >>  >
>>  >>  >
>>  >>  >  Romel wrote:
>>  >>  >  > HI
>>  >>  >  >
>>  >>  >  > I was using webERP since 3.04, so I would like to learn and test some
>>  >>  >  > changes and functions before use in the real system. It is also
>>  >>  >  > because many new function need to try by ourself without instruction,
>>  >>  >  > but don't want to disturbed the real data.
>>  >>  >  >
>>  >>  >  > Other hand, is there any detail history of change in offical website?
>>  >>  >  >
>>  >>  >  > Thanks.
>>  >>  >  >
>>  >>  >  > Steven
>>  >>  >  >
>>  >>  >  > Tim Schofield 提到:
>>  >>  >  >> Hi
>>  >>  >  >>
>>  >>  >  >> On 28/03/2008, Romel <ste...@ya...> wrote:
>>  >>  >  >>
>>  >>  >  >>> I have another error when trying. function opendir error in stocks.php.
>>  >>  >  >>>
>>  >>  >  >>
>>  >>  >  >> I have corrected this.
>>  >>  >  >>
>>  >>  >  >>
>>  >>  >  >>> may be the php version or setting is correct.  Will you think about rebuild
>>  >>  >  >>> a blank sql DB?
>>  >>  >  >>>
>>  >>  >  >>> Actually, the main purpose of the test in demo is testing the function of:
>>  >>  >  >>>
>>  >>  >  >>> 1. multi delivery and input of same item in one Sale order.
>>  >>  >  >>> 2. If invoicing for above sale order is ok.
>>  >>  >  >>> 3. if the print out invoice show the customer po in sale order.  And how it
>>  >>  >  >>> show.
>>  >>  >  >>>
>>  >>  >  >>
>>  >>  >  >> If you are evaluating webERP for your own use, I would strongly
>>  >>  >  >> recommend that you set it up on a local machine. The demo is there for
>>  >>  >  >> people to get a feel for the software, but with access given to
>>  >>  >  >> anybody that chances by the data is always going to become "strange".
>>  >>  >  >>
>>  >>  >  >>
>>  >>  >  >>> one more mistake in entering new sale order, the input customer code is
>>  >>  >  >>> mistake as item code.
>>  >>  >  >>>
>>  >>  >  >>
>>  >>  >  >> I can't re-create this, though I do remember a problem like this that
>>  >>  >  >> got corrected, but it may have been after the version that is
>>  >>  >  >> currently on the demo. Can you give me steps to recreate?
>>  >>  >  >>
>>  >>  >  >>
>>  >>  >  >>
>>  >>  >  >> Thanks
>>  >>  >  >> Tim
>>  >>  >  >>
>>  >>  >  >
>>  >>  >
>>  >>  >
>>  >>  >  -------------------------------------------------------------------------
>>  >>  >  Check out the new SourceForge.net Marketplace.
>>  >>  >  It's the best place to buy or sell services for
>>  >>  >  just about anything Open Source.
>>  >>  >  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>>  >>  >  _______________________________________________
>>  >>  >  web-ERP-users mailing list
>>  >>  >  web...@li...
>>  >>  >  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>  >>  >
>>  >>
>>  >>
>>  > -------------------------------------------------------------------------
>>  > Check out the new SourceForge.net Marketplace.
>>  > It's the best place to buy or sell services for
>>  > just about anything Open Source.
>>  > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>>  > _______________________________________________
>>  > web-ERP-users mailing list
>>  > web...@li...
>>  > https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>  >
>>
>>  -------------------------------------------------------------------------
>>  Check out the new SourceForge.net Marketplace.
>>  It's the best place to buy or sell services for
>>  just about anything Open Source.
>>  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>>  _______________________________________________
>>  web-ERP-users mailing list
>>  web...@li...
>>  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>     
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [webERP-users] Error in demo

From: Phil D. <ph...@lo...> - 2008-03-30 02:57:10

I try to maintain a change log - which is committed to cvs each time 
there is a change... I must say it is hard to remember to do the change 
log with each update so a fair bit gets missed.

For what it's worth it is at:

http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup

Phil


Romel wrote:
> HI
>
> I was using webERP since 3.04, so I would like to learn and test some 
> changes and functions before use in the real system. It is also 
> because many new function need to try by ourself without instruction, 
> but don't want to disturbed the real data.
>
> Other hand, is there any detail history of change in offical website?
>
> Thanks.
>
> Steven
>
> Tim Schofield 提到:
>> Hi
>>
>> On 28/03/2008, Romel <ste...@ya...> wrote:
>>   
>>> I have another error when trying. function opendir error in stocks.php.
>>>     
>>
>> I have corrected this.
>>
>>   
>>> may be the php version or setting is correct.  Will you think about rebuild
>>> a blank sql DB?
>>>
>>> Actually, the main purpose of the test in demo is testing the function of:
>>>
>>> 1. multi delivery and input of same item in one Sale order.
>>> 2. If invoicing for above sale order is ok.
>>> 3. if the print out invoice show the customer po in sale order.  And how it
>>> show.
>>>     
>>
>> If you are evaluating webERP for your own use, I would strongly
>> recommend that you set it up on a local machine. The demo is there for
>> people to get a feel for the software, but with access given to
>> anybody that chances by the data is always going to become "strange".
>>
>>   
>>> one more mistake in entering new sale order, the input customer code is
>>> mistake as item code.
>>>     
>>
>> I can't re-create this, though I do remember a problem like this that
>> got corrected, but it may have been after the version that is
>> currently on the demo. Can you give me steps to recreate?
>>
>>   
>>
>> Thanks
>> Tim
>>     
>

Re: [webERP-users] Error in demo

From: Tim S. <tim...@go...> - 2008-03-30 08:37:40

Phil is being kind here, what he means is that I am hopeless at
keeping the change log up to date. :-)

I still think it would be easy enough to keep a local version, it is a
fairly easy task to set webERP up on anything from a win2000 machine
upwards or any version of Linux.

Tim


On 30/03/2008, Phil Daintree <ph...@lo...> wrote:
> I try to maintain a change log - which is committed to cvs each time
>  there is a change... I must say it is hard to remember to do the change
>  log with each update so a fair bit gets missed.
>
>  For what it's worth it is at:
>
>  http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup
>
>
>  Phil
>
>
>
>  Romel wrote:
>  > HI
>  >
>  > I was using webERP since 3.04, so I would like to learn and test some
>  > changes and functions before use in the real system. It is also
>  > because many new function need to try by ourself without instruction,
>  > but don't want to disturbed the real data.
>  >
>  > Other hand, is there any detail history of change in offical website?
>  >
>  > Thanks.
>  >
>  > Steven
>  >
>  > Tim Schofield 提到:
>  >> Hi
>  >>
>  >> On 28/03/2008, Romel <ste...@ya...> wrote:
>  >>
>  >>> I have another error when trying. function opendir error in stocks.php.
>  >>>
>  >>
>  >> I have corrected this.
>  >>
>  >>
>  >>> may be the php version or setting is correct.  Will you think about rebuild
>  >>> a blank sql DB?
>  >>>
>  >>> Actually, the main purpose of the test in demo is testing the function of:
>  >>>
>  >>> 1. multi delivery and input of same item in one Sale order.
>  >>> 2. If invoicing for above sale order is ok.
>  >>> 3. if the print out invoice show the customer po in sale order.  And how it
>  >>> show.
>  >>>
>  >>
>  >> If you are evaluating webERP for your own use, I would strongly
>  >> recommend that you set it up on a local machine. The demo is there for
>  >> people to get a feel for the software, but with access given to
>  >> anybody that chances by the data is always going to become "strange".
>  >>
>  >>
>  >>> one more mistake in entering new sale order, the input customer code is
>  >>> mistake as item code.
>  >>>
>  >>
>  >> I can't re-create this, though I do remember a problem like this that
>  >> got corrected, but it may have been after the version that is
>  >> currently on the demo. Can you give me steps to recreate?
>  >>
>  >>
>  >>
>  >> Thanks
>  >> Tim
>  >>
>  >
>
>
>  -------------------------------------------------------------------------
>  Check out the new SourceForge.net Marketplace.
>  It's the best place to buy or sell services for
>  just about anything Open Source.
>  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>  _______________________________________________
>  web-ERP-users mailing list
>  web...@li...
>  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [webERP-users] Error in demo

From: Ian M. <ia...@mc...> - 2008-03-30 17:58:05

I've been testing the latest csv and getting quite a few Database SQL 
failures so I decided to and started again from scratch testing 2 fresh 
local installs of webERP side-by-side (using Apache VirtualHost, PHP  
5.2.5 and MySQL 5.0.45)

1) http://weberp-v3.08 runs on files from the downloaded zip with DB 
weberp-308 (created from weberp-new.sql)
2) http://webERP-cvs runs on files from the cvs with DB weberp-cvs 
(created from cvs version of weberp-new.sql)

I'm working step-by-step through Create New System (from the Manual).

All goes well until I try to set up Sales Areas.

Installation 1) works no problems.

But installation 2) returns:

*Database Error* :
Unknown column 'EU' in 'where clause'

*Database SQL Failure* : The SQL that failed was
SELECT count(areacode) from areas WHERE areacode="EU"

Don't know if this is a bug or not, but thought I ought to report it anyway.

Ian


Tim Schofield wrote:
> To make it easier for those who want to follow cvs changes, I have
> opened a mailing list (web...@li...) which will
> have all changes to cvs automatically sent to it, thereby lessening my
> feelings of guilt when I forget to update the change log. This can be
> subscribed to in the normal way through our sourceforge pages.
>
> Tim
>
>
> On 30/03/2008, Tim Schofield <tim...@go...> wrote:
>   
>> Phil is being kind here, what he means is that I am hopeless at
>>  keeping the change log up to date. :-)
>>
>>  I still think it would be easy enough to keep a local version, it is a
>>  fairly easy task to set webERP up on anything from a win2000 machine
>>  upwards or any version of Linux.
>>
>>
>>  Tim
>>
>>
>>
>>  On 30/03/2008, Phil Daintree <ph...@lo...> wrote:
>>  > I try to maintain a change log - which is committed to cvs each time
>>  >  there is a change... I must say it is hard to remember to do the change
>>  >  log with each update so a fair bit gets missed.
>>  >
>>  >  For what it's worth it is at:
>>  >
>>  >  http://web-erp.cvs.sourceforge.net/web-erp/webERP/doc/Change.log.html?view=markup
>>  >
>>  >
>>  >  Phil
>>  >
>>  >
>>  >
>>  >  Romel wrote:
>>  >  > HI
>>  >  >
>>  >  > I was using webERP since 3.04, so I would like to learn and test some
>>  >  > changes and functions before use in the real system. It is also
>>  >  > because many new function need to try by ourself without instruction,
>>  >  > but don't want to disturbed the real data.
>>  >  >
>>  >  > Other hand, is there any detail history of change in offical website?
>>  >  >
>>  >  > Thanks.
>>  >  >
>>  >  > Steven
>>  >  >
>>  >  > Tim Schofield 提到:
>>  >  >> Hi
>>  >  >>
>>  >  >> On 28/03/2008, Romel <ste...@ya...> wrote:
>>  >  >>
>>  >  >>> I have another error when trying. function opendir error in stocks.php.
>>  >  >>>
>>  >  >>
>>  >  >> I have corrected this.
>>  >  >>
>>  >  >>
>>  >  >>> may be the php version or setting is correct.  Will you think about rebuild
>>  >  >>> a blank sql DB?
>>  >  >>>
>>  >  >>> Actually, the main purpose of the test in demo is testing the function of:
>>  >  >>>
>>  >  >>> 1. multi delivery and input of same item in one Sale order.
>>  >  >>> 2. If invoicing for above sale order is ok.
>>  >  >>> 3. if the print out invoice show the customer po in sale order.  And how it
>>  >  >>> show.
>>  >  >>>
>>  >  >>
>>  >  >> If you are evaluating webERP for your own use, I would strongly
>>  >  >> recommend that you set it up on a local machine. The demo is there for
>>  >  >> people to get a feel for the software, but with access given to
>>  >  >> anybody that chances by the data is always going to become "strange".
>>  >  >>
>>  >  >>
>>  >  >>> one more mistake in entering new sale order, the input customer code is
>>  >  >>> mistake as item code.
>>  >  >>>
>>  >  >>
>>  >  >> I can't re-create this, though I do remember a problem like this that
>>  >  >> got corrected, but it may have been after the version that is
>>  >  >> currently on the demo. Can you give me steps to recreate?
>>  >  >>
>>  >  >>
>>  >  >>
>>  >  >> Thanks
>>  >  >> Tim
>>  >  >>
>>  >  >
>>  >
>>  >
>>  >  -------------------------------------------------------------------------
>>  >  Check out the new SourceForge.net Marketplace.
>>  >  It's the best place to buy or sell services for
>>  >  just about anything Open Source.
>>  >  http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>>  >  _______________________________________________
>>  >  web-ERP-users mailing list
>>  >  web...@li...
>>  >  https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>  >
>>
>>     
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>