I read through the thread, and still can't help with the info provided.
It looks like you have a database error, but the query generating the error and the Mysql query is not displayed by your mambo install.
Try turning site debug ON, maybe you will get more info.
Important: did you try CB TOOLS -> CHECK DATABASES links ?
All green everywhere there ?