web-erp-users

[webERP-users] database error what is wrong?

[Heinrich S. <Mr...@gm...>]

Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The supplier invoice transaction could not be added to the
database because
Duplicate entry '1003-20' for key 'TypeTransNo'
Database SQL Failure : The following SQL to insert the supplier invoice was
used
INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20 ,
'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
'1.00000000', '', '2017-08-21')
Database Rollback Due to Error Above : Rolling Back Transaction OK



-----
using webERP v4.11.2
Apache version 2.4
Mysql 5.7.19
Ubuntu 16.04
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658833.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] database error what is wrong?

[Heinrich S. <Mr...@gm...>]

Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The supplier invoice transaction could not be added to the
database because
Duplicate entry '1003-20' for key 'TypeTransNo'
Database SQL Failure : The following SQL to insert the supplier invoice was
used
INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20 ,
'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
'1.00000000', '', '2017-08-21')
Database Rollback Due to Error Above : Rolling Back Transaction OK



-----
using webERP v4.11.2
Apache version 2.4
Mysql 5.7.19
Ubuntu 16.04
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658834.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] database error what is wrong?

[<ph...@lo...>]

You may have to manually increment the transno in systypes for typeno=20 
to be able to process further AP invoices.

Run the SQL
UPDATE systypes SET typeno='1004' WHERE typeid='20'

then give it another go.

How did it happen .... would like to know?

Phil
On 2017-08-21 05:39, Heinrich Steuber wrote:
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice 
> was
> used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, 
> trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 
> 20 ,
> 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK
> 
> 
> 
> -----
> using webERP v4.11.2
> Apache version 2.4
> Mysql 5.7.19
> Ubuntu 16.04
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658834.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

Re: [webERP-users] database error what is wrong?

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

*Hi, Heinrich,*

     It's a bug. 
     You can alter the table in mysql by following statement:
      ALTER table supptrans DROP KEY `TypeTransNo`;
     ALTER table supptrans ADD KEY `TypeTransNo`(`transno`,`type`);

         Thanks and best regards!

     Exson

       

Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK





--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html

Re: [webERP-users] database error what is wrong?

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

*Hi, Heinrich,*

   It's a bug and fixed in the trunk. 
   
   You can fixed it by issue following statements:

ALTER table supptrans DROP KEY `TypeTransNo`; 
ALTER table supptrans ADD KEY `TypeTransNo`(`transno`,`type`); 

    Thanks and best regards!
    Exson

 

Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK





--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html

Re: [webERP-users] database error what is wrong?

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

Hi, Heinrich, 
 
       It's fixed in the trunk.

       Best regards!
 
       Exson

Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK





--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html

Re: [webERP-users] database error what is wrong?

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

*Hi, Heinrich,*

It's fixed in the trunk now. 

Best regards!

Exson

Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK





--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html