Getting this error when I try to view JSON data for all apps on a Self Hosted: fnExecuteNonQuery :: fnDbGetResult (get result)<br>Database Error!<br/>Error #:1062<br/>Error: Duplicate entry '51291' for key 'PRIMARY' I thought maybe this might have something do with some possible back-end CP updates BT might be doing? But no one else is reporting it and it has trashed all JSON for all apps on this install. Not liking some of the solutions I see out there to fix this.... Most say you have to rebuild the table from a back-up. The most promising fix I see for this issue is someone suggesting that the auto increment field may have reached a limit?

FIXED: There were indeed 2 entries for that ID in the bt_api_requests table deleted the last one and all works again. It's almost like 2 clients made an API request at the same exact time and were both issued that same ID for the primary key of that record. Bizzare.

Very bizzare...never EVER seen this before. LOL. Writing another post about updates now, look for it in a bit. d.

Would recommend getting buzzpurge for that table, can really speed things up, make your database significantly smaller and cleaned. https://buzztouchmods.com/downloads.php?cat_id=2&download_id=44 Nice to see you posting atrain.. we should catch up via text soon. Cheers friend. David

Thanks brother, we'll catch up soon. I was not aware that table was growing so large so quickly! I know there were some future control panel options that were touting a purge and sql back-up in the last SH. I wonder if this will be in 2.1.9? I'll look at the buzzpurge as well, very useful tool. Any other server maintenance you perform that I should also consider? Good luck with the 2.1.9 updates. I'll be at it next week sometime, too much football to watch and beer to drink this weekend. Happy to see you're relocated and doing great out there - just don't become a USC fan!