Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Help please

Help
2007-09-07
2013-04-17
  • When I try to create a new operation I receive this error.

    MySQL Error :
    1062(Duplicate entry '118400538058000' for key 1)
    Database :
    Invalid SQL: INSERT INTO MPM_op (
                   OPID,
                   NUMID,
                   TEMPID,
                   VALID_OP,
                   USERID,
                   DATES,
                   CAT,
                   THIRD,
                   COREL,
                   COMMENTS,
                   SOUTT,
                   IMP,
                   ACCOUNT,
                   BALANCE,
                   PERIOD
             )
             VALUES('118400538058000-9223372036854775808','','1','0','118400538058','2007-09-14','1184005380580003','118400538058006','0','','0','17630.58','118400538058000','0','0')

    Any idea with this.

     
    • hpfn
      hpfn
      2007-09-08

      Hi,

      This OPID, the first value, seems to be wrong - '118400538058000-9223372036854775808'.

      I made a new instalation and create 10 new operations without errors.
      Some interruption happened during the attempt to create a new operation?
      How many operations exists?

      Regards
      hpfn

       
    • I have like 100 operations.

       
    • hpfn
      hpfn
      2007-09-16

      clarifying: it was possible to create new operations and one failed ?

      bcsub is uses only like bcsub($VAR,{1,2}).
      And i don't see where '118400538058000-9223372036854775808' is possible.

      Regards
      hpfn