An unexpected database error occurred. Please try again later.

I have xenforo insatlled and it was working fine, but just gone back onto my site, and I am presented with this error, can anyone help?

The first thing you should do is try to figure out the actual error message. Check whether XenForo logs their errors somewhere or whether you can set a debug flag to make XenForo output the real error message.