Never mind. I found where it forces the mode. It's in joomla.php. I changed it so I'm back to mode 5. I'm hoping that everything will work under this mode. Hopefully Mysql 5 mode is faster than 4, guess we'll see.