Joseph H Posted June 6, 2018 Report Share Posted June 6, 2018 Hi guys, today An odd thing happened with 2 of our clients. A client registered today and his account got assigned with a client number which already exists. Invoices were send to the wrong client + he was seeing another clients details in his dashboard. Same was for the staff area, We saw being mixed between 2 separate accounts and all acted as 1 account. We had to delete the new clients data directly from the database and registering again worked fine and we could not replicate the issue. Quote Link to comment Share on other sites More sharing options...
Paul Posted June 6, 2018 Report Share Posted June 6, 2018 That's unusual.. I assume the clients had a different ID internally in MySQL but the same ID code? How far apart did these clients register? Do you have any records from MySQL prior to cleaning it up? Quote Link to comment Share on other sites More sharing options...
Joseph H Posted June 6, 2018 Author Report Share Posted June 6, 2018 1 hour ago, Paul said: That's unusual.. I assume the clients had a different ID internally in MySQL but the same ID code? How far apart did these clients register? Do you have any records from MySQL prior to cleaning it up? The clients are 3018 and 3020 there is a client in between them. And checking mysql I couldn't figure out the problem fast enough Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted June 7, 2018 Report Share Posted June 7, 2018 i think your issue is related to this thread Quote Link to comment Share on other sites More sharing options...
Joseph H Posted June 7, 2018 Author Report Share Posted June 7, 2018 9 hours ago, Blesta Addons said: i think your issue is related to this thread I think It is, I wonder what the cause is Quote Link to comment Share on other sites More sharing options...
Paul Posted June 8, 2018 Report Share Posted June 8, 2018 19 hours ago, Joseph H said: I think It is, I wonder what the cause is Do you see an big jump in ID's? This can happen with automated bots registering accounts that fail to be created. A failure causes the transaction to be rolled back, but MySQL doesn't reuse the ID from the failed database transaction. Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted June 8, 2018 Report Share Posted June 8, 2018 58 minutes ago, Paul said: Do you see an big jump in ID's? On 6/6/2018 at 7:16 PM, Joseph H said: The clients are 3018 and 3020 there is a client in between them. Quote Link to comment Share on other sites More sharing options...
NextToNothing Posted June 21, 2018 Report Share Posted June 21, 2018 Why the hell does the column not have a UNIQUE index on the goddamn column you use as an identifier?? ? ? ? ? ? ? ? ? I mean it should really be the primary key, in an ideal world. If not, at the very minimum, it should be unique indexed. ? If it had the index, the user would have never had their account created in the first place and this whole mess would've been avoided full stop. Not to mention this would clearly break any and all data protection laws. Quote Link to comment Share on other sites More sharing options...
Paul Posted June 21, 2018 Report Share Posted June 21, 2018 12 minutes ago, NextToNothing said: Why the hell does the column not have a UNIQUE index on the goddamn column you use as an identifier?? ? ? ? ? ? ? ? ? I mean it should really be the primary key, in an ideal world. If not, at the very minimum, it should be unique indexed. ? If it had the index, the user would have never had their account created in the first place and this whole mess would've been avoided full stop. Not to mention this would clearly break any and all data protection laws. Wrong. id_value is for display purposes, and it's not joined with any other tables. If id_value were unique, Blesta installs with multiple companies would not be able to have clients, or packages, or many other things with overlapping ID's. Also don't appreciate the language, and your response comes across a bit arrogant. Beav and Michael 2 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.