I've decided to just truncate the whole transactions table due to the reason it's the fastest and best solution at the moment. 99% of the transactions were either way just Status Transactions so who fucking cares.

It looks like the database table is corrupt.

There is currently a problem where transactions cannot be displayed.