I wouldn't run any mysql steps through the UBB; I'd instead do it through PHPMyAdmin or the MySQL command line.

As for your error, it tells you what the problem is:
Quote
Fatal error: require() [function.require]: Failed opening required 'libs/smarty/Smarty.class.php' (include_path='.:') in /var/www/vhosts/dennyp.com/httpdocs/ubbthreads/ubbthreads.php on line 55

It's unable to read the smarty files that SHOULD be in the libs/smarty folder.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!