From the UBB.threads 6.x Discussion
Assorted MySQL queries / Common MySQL Errors & Solutions
https://www.ubbcentral.com/forums/ubbthreads.php/ubb/showflat/Number/39296/page/1#Post39296

Would be great if someone could write up a similar article of that applies to the 7.x version and common things found and how to fix.