Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

ordercheck duplicate keys


Recommended Posts

This contribution works fine but has a worrying little dependency, it presumes you will never edit an order on the good order side. If you do you will knock the indexes out of line. The indexes use increment_next_val in the data base and when you try to move orders when these go out of line you get duplicate key error s and strange behaviour after that.


There needs to be on key fix added into this.


When the problem order is being moved it needs to not pass the next val keys into the good order area. Let these keys be generated automatically as they should.

The problem order then needs to be deleted after it is moved / locked so as to prevent another move from happening.




free is often better than cheap

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...