Re: [WebERP-developers] Process Goods Received Error - transactionnumber could not be incremented

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

A setup wizard would be good as long as we don't mean an installation
wizard, as in setup.exe.  That's what I thought you guys were talking about
before.

Steve 

-----Original Message-----
From: web...@li...
[mailto:web...@li...] On Behalf Of Phil
Daintree
Sent: Tuesday, January 16, 2007 1:59 PM
To: st...@se...; webERP Developers
Subject: Re: [WebERP-developers] Process Goods Received Error -
transactionnumber could not be incremented

This sounds like the oft talked of "Setup Wizard" ... its a solid idea 
alright.

Phil

On Wednesday 17 January 2007 01:48, Steve wrote:
> What about the system checking if it's the first time it's ever coming up
> (i.e. it has no periods or however...) and doing some starting maintenance
> including asking the user, who must be an admin, what the month and year
of
> the first period should be?  If it is the first time then the system could
> also check that some other things were properly (or at least somewhat)
> setup as well such as sales to gl, cogs to gl, inv cat, ...
>
> Steve
>
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...] On Behalf Of
Phil
> Daintree
> Sent: Tuesday, January 16, 2007 1:25 AM
> To: webERP Developers
> Subject: Re: [WebERP-developers] Process Goods Received Error -
> transactionnumber could not be incremented
>
> Yes it will be the fact that the periods table is empty. The general
ledger
> postings get updated every time you try to run a trial balance so a period
> 1
>
> is initiated by the posting routine if there is no periods to play with.
>
> Right again with the issue for anyone using weberp-new.sql I need some way
> to
> add a blank period into the database so this issue doesn't affect others.
>
> Phil
>
> On Tuesday 16 January 2007 16:38, William Laakkonen wrote:
> > Thanks for your reply Steve- forgot to thank you with my last post.
> >
> > If I use the weberp-demo.sql I can create and receive POs. If I use the
> > weberp-new.sql I cannot do so. I noted with the weberp-new.sql that if I
> > try to go to GST Reports under general ledger I get the same issue (it's
> > the same date query). If I click on Trial Balance- the first time I get
> > nothing in the drop down boxes- second Time I get the current month (Jan
> > 2007) after which I can create a GST report just fine and I can also now
> > check in a PO as well.
> >
> > It seems to be an issue with doing queries against an unitialised date
in
> > the table.  Hitting the page GLTrialBalance.php just one time seems to
>
> have
>
> > fixed it for me by setting the dates- otherwise the query goes through
> > the date sequences. This should be able to be duplicated by anyone who
> > uses
>
> the
>
> > weberp-new.sql to set up a new install. Perhaps I'm going about the
steps
> > in the wrong order and in so doing ended up here with this issue so I am
> > not sure it is a bug- but it seems it can be duplicated out of the box
so
> > it might appear for others evaluating webERP.
> >
> > So far, I am amazed at the high quality and performance of this package,
> > and not being an accountant (or familiar with the UK ways of accounting)
> > I am still working on wrapping my brain around a couple of the
accounting
> > concepts.
> >
> > Thanks again for your help- I'll take any other topics to the users list
> > and not bother you guys any more in developers.
> >
> > Best Regards
> >
> > Bill Laakkonen
> >
> > On 1/12/07, William Laakkonen <wor...@gm...> wrote:
> > > They are in fact InnoDB tables;
> > >
> > > In the INSTALL file I see "Innodb tables require some parameters to be
> > > set up in my.cnf" - I wonder what parameters are needed here?
> > >
> > > After restarting the server and trying to post the items again I now
> > > see this:
> > >
> > >   IN ( SELECT chartdetails.accountcode, chartdetails.period FROM
> > > chartdetails ) 070112 10:40:00       6 Query       INSERT INTO periods
> > > (periodno, lastdate_in_period) VALUES (57, '1974/09/30')
> > >                       6 Query       INSERT INTO chartdetails
> > > (accountcode, period)
> > >                                                 SELECT
> > > chartmaster.accountcode, periods.periodno
> > >                                                         FROM
> > > chartmaster CROSS JOIN periods
> > >                                                 WHERE (
> > > chartmaster.accountcode, periods.periodno ) NOT
> > >                                                         IN ( SELECT
> > > chartdetails.accountcode, chartdetails.period FROM chartdetails )
> > > 070112 10:40:21       6 Query       INSERT INTO periods (periodno,
> > > lastdate_in_period) VALUES (58, '1974/10/31')
> > >                       6 Query       INSERT INTO chartdetails
> > > (accountcode, period)
> > >                                                 SELECT
> > > chartmaster.accountcode, periods.periodno
> > >                                                         FROM
> > > chartmaster CROSS JOIN periods
> > >                                                 WHERE (
> > > chartmaster.accountcode, periods.periodno ) NOT
> > >                                                         IN ( SELECT
> > > chartdetails.accountcode, chartdetails.period FROM chartdetails )
> > >
> > >
> > > over and over again with the value incrementing and last day of the
> > > month dates from the 1970's for last date in period also incrementing
> > > by month...
> > >
> > > Could it be something I have not initialised in the tables?
> > >
> > > On 1/12/07, Steve <st...@se...> wrote:
> > > > I don't have 3.05 installed to check out right now but assuming
> > > > others are using it and doing what you are without error then a
> > > > question
>
> might
>
> > > > be
> > > >
> > > > Did the tables create as InnoDB or MyISAM?
> > > >
> > > > I think only InnoDB tables can lock records instead of the entire
> > > > table.
> > > >
> > > > Next question though is what you pose, which is why the table
>
> continues
>
> > > > to be locked.  Maybe transaction processing is enabled with MyISAM
> > > > tables now but the entire table is locked until the commit?
Possibly
>
> a
>
> > > > lock tables is being done somewhere...
> > > >
> > > > Possibly some info here
> > > > http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html - maybe
> > > > something to do with indexes. Info at bottom about InnoDB and MySQL
> > > > locking working together and settings.
> > > >
> > > > Steve
> > > >
> > > > -----Original Message-----
> > > > From: web...@li...
> > > > [mailto:web...@li...] On Behalf
> > > > Of William Laakkonen
> > > > Sent: Friday, January 12, 2007 8:55 AM
> > > > To: web...@li...
> > > > Subject: [WebERP-developers] Process Goods Received Error -
> > > > transactionnumber could not be incremented
> > > >
> > > > Hi Guys,
> > > >
> > > > I am new to webERP so hopefully this is the right place to post and
> > > > appropriate. I looked through the archives and the wiki and could
not
> > > > find any reference to a problem such as this.
> > > >
> > > > I just did a fresh install of webERP 3.05 on FreeBSD 6.1 (PC-BSD1.3)
> > > > with PHP5 and MySQL 4.1- Great package- I hope to use it more and
> > > > hopefully contribute as well.
> > > >
> > > > Everything seems to work fine except that when I go to receive items
> > > > on my first Open Purchase order on the page GoodsReceived.php I get
> > > > the following error:
> > > >
> > > > ***ERROR***
> > > > Database Error : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> > > > ASSISTANCE: The transaction number could not be incremented
> > > > Lock wait timeout exceeded; try restarting transaction
> > > >
> > > > Database SQL Failure : The following SQL to increment the
transaction
> > > > number was used
> > > > UPDATE systypes SET typeno = 1 WHERE typeid = 25
> > > > ***END ERROR***
> > > >
> > > > Here is the SQL log leading up to this (after typing in the Delivery
> > > > Quantity and clicking on update, then click "process goods
> > > > received"). ***SQL LOG***
> > > >  ON purchorderdetails.itemcode=stockmaster.stockid
> > > >                                         LEFT JOIN chartmaster
> > > >                                         ON
> > > > purchorderdetails.glcode=chartmaster.accountcode
> > > >                                 WHERE purchorderdetails.completed=0
> > > >                                         AND
purchorderdetails.orderno
> > > > =1 ORDER BY podetailitem
> > > >                      62 Quit
> > > > 070112  8:05:46      63 Connect     weberp@localhost on
> > > >                      63 Init DB     weberp
> > > >                      63 Quit
> > > > 070112  8:06:53      64 Connect     weberp@localhost on
> > > >                      64 Init DB     weberp
> > > >                      64 Query       SELECT itemcode,
> > > >                         glcode,
> > > >                         quantityord,
> > > >                         quantityrecd,
> > > >                         qtyinvoiced,
> > > >                         shiptref,
> > > >                         jobref
> > > >                 FROM purchorderdetails
> > > >                 WHERE orderno=1
> > > >                 AND completed=0
> > > >                 ORDER BY podetailitem
> > > >                      64 Query       BEGIN
> > > >                      64 Query       SELECT typeno FROM systypes
WHERE
> > > > typeid = 25
> > > >                      64 Query       UPDATE systypes SET typeno = 1
> > > > WHERE typeid = 25
> > > > 070112  8:07:07       8 Query       INSERT INTO periods (periodno,
> > > > lastdate_in_period) VALUES (330, '1997/06/30')
> > > >                       8 Query       INSERT INTO chartdetails
> > > > (accountcode, period)
> > > >                                                 SELECT
> > > > chartmaster.accountcode, periods.periodno
> > > >                                                         FROM
> > > > chartmaster CROSS JOIN periods
> > > >                                                 WHERE (
> > > > chartmaster.accountcode, periods.periodno ) NOT
> > > >                                                         IN ( SELECT
> > > > chartdetails.accountcode, chartdetails.period FROM chartdetails )
> > > > 070112  8:07:08      32 Quit
> > > > 070112  8:07:44      64 Quit
> > > > ***END SQL LOG***
> > > >
> > > >
> > > > *** MySQL CLI of systypes***
> > > >
> > > > mysql> describe systypes;
> > > > +----------+-------------+------+-----+---------+-------+
> > > >
> > > > | Field    | Type        | Null | Key | Default | Extra |
> > > >
> > > > +----------+-------------+------+-----+---------+-------+
> > > >
> > > > | typeid   | smallint(6) |      | PRI | 0       |       |
> > > > | typename | char(50)    |      |     |         |       |
> > > > | typeno   | int(11)     |      | MUL | 1       |       |
> > > >
> > > > +----------+-------------+------+-----+---------+-------+
> > > > 3 rows in set (0.00 sec)
> > > >
> > > > mysql> select * from systypes;
> > > > +--------+-------------------------+--------+
> > > >
> > > > | typeid | typename                | typeno |
> > > >
> > > > +--------+-------------------------+--------+
> > > >
> > > > |      0 | Journal - GL            |      0 |
> > > > |      1 | Payment - GL            |      0 |
> > > > |      2 | Receipt - GL            |      0 |
> > > > |      3 | Standing Journal        |      0 |
> > > > |     10 | Sales Invoice           |      0 |
> > > > |     11 | Credit Note             |      0 |
> > > > |     12 | Receipt                 |      0 |
> > > > |     15 | Journal - Debtors       |      0 |
> > > > |     16 | Location Transfer       |      0 |
> > > > |     17 | Stock Adjustment        |      0 |
> > > > |     18 | Purchase Order          |      0 |
> > > > |     20 | Purchase Invoice        |      0 |
> > > > |     21 | Debit Note              |      0 |
> > > > |     22 | Creditors Payment       |      0 |
> > > > |     23 | Creditors Journal       |      0 |
> > > > |     25 | Purchase Order Delivery |      0 |
> > > > |     26 | Work Order Receipt      |      0 |
> > > > |     28 | Work Order Issue        |      0 |
> > > > |     29 | Work Order Variance     |      0 |
> > > > |     30 | Sales Order             |      0 |
> > > > |     31 | Shipment Close          |      0 |
> > > > |     35 | Cost Update             |      0 |
> > > > |     50 | Opening Balance         |      0 |
> > > > |    500 | Auto Debtor Number      |      0 |
> > > >
> > > > +--------+-------------------------+--------+
> > > > 24 rows in set (0.00 sec)
> > > >
> > > > mysql> UPDATE systypes SET typeno = 1 WHERE typeid = 25;
> > > > ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting
> > > > transaction
> > > >
> > > > ***END MySQL CLI***
> > > >
> > > > If I stop and then restart MySQL the UPDATE query above works.
> > > >
> > > > So it seems so simple it's almost embarrassing to ask- almost. Is it
> > > > a previous query leaving the table locked?
> > > >
> > > > Or did I miss something here in my Mysql 4.1.22 configuration or
> > > > compilation?
> > > >
> > > > Best regards and Thanks in advance for your insight with this.
> > > >
> > > > Bill Laakkonen
>
> -----------------------------------------------------------------------
>
> > > >-- Take Surveys. Earn Cash. Influence the Future of IT
> > > > Join SourceForge.net's Techsay panel and you'll get the chance to
>
> share
>
> > > > your opinions on IT & business topics through brief surveys - and
> > > > earn cash
>
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD
>
> > > >EV _______________________________________________
> > > > Web-erp-developers mailing list
> > > > Web...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > > >
> > > > --
> > > > No virus found in this incoming message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.432 / Virus Database: 268.16.9/623 - Release Date:
> > > > 1/11/2007 3:33 PM
> > > >
> > > >
> > > > --
> > > > No virus found in this outgoing message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.432 / Virus Database: 268.16.9/623 - Release Date:
> > > > 1/11/2007 3:33 PM
>
> -----------------------------------------------------------------------
>
> > > >-- Take Surveys. Earn Cash. Influence the Future of IT
> > > > Join SourceForge.net's Techsay panel and you'll get the chance to
>
> share
>
> > > > your opinions on IT & business topics through brief surveys - and
> > > > earn cash
>
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD
>
> > > >EV _______________________________________________
> > > > Web-erp-developers mailing list
> > > > Web...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> >
-------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share
> > your opinions on IT & business topics through brief surveys - and earn
>
> cash
>
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys - and earn
cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.16.12/628 - Release Date: 1/15/2007
> 11:04 AM

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM

Re: [WebERP-developers] Process Goods Received Error - transactionnumber could not be incremented

Accounting & Best Practice Business Administration System

Re: [WebERP-developers] Process Goods Received Error - transactionnumber could not be incremented