IPB also know as Invision Power Board is a popular forum system who for whatever reason has not decided to make some simple changes to their package that will make their BBS mysql 5 compatible.
These are the know issues and fixes contributed by John-Marc one of the best programmers in the west.
Partch #1:
sources/Boards.php
~line 66 from find the lines that look like:
Then change toCode:from ibf_forums f,ibf_categories c
Code:from ibf_categories c,ibf_forums f