Okay I read the expanded version and I see the size limitations of 16MB and or 5,000 rows
So if we don't exceed this limits should we still alter the tables for the future?
i think you and I replied at the same time
as my reply above yours gives an example of why you'd want to alter your temporary table from memory to disk.
I'll post more if you want more reading to whats going on as it relates to the temporary table engine type. But as for UBB.threads, I have not completely explored other options since discovering this issue late last year on a super-forum that was being DDoS attacked, and I had a short time to research what was directly triggering database error.
EDIT:
I've updated my previous post with source/further reading
https://www.ubbcentral.com/forums/u...6/re-we-encountered-a-problem#Post263726
