MyBB Community Forums

I have got a forum which i have recently moved from a differnet host

When i click on a members username to view their profile it gives me this error:
"MySQL error: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: SELECT t.*, f.name, i.path FROM fmthreads t LEFT JOIN fmforums f ON (f.fid=t.fid) LEFT JOIN fmicons i ON (i.iid=t.icon) WHERE t.uid='4' ORDER BY t.dateline DESC LIMIT"

How do i go about fixing this?

I think you have an Mysql version mismatch. Try replacing the member.php file with the attached copy and see if it helps. Backup your original file first.

Regards

What MySQL version do you use? Please note that we only support MySQL 4.0 and above and we can't be held liable or responsible for any modifications especially made for your installation.

Do you have a plugin/modification like "Show recent threads on profile" or something?