UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Database Move = Failure!

UBB.Threads 6.5.4 | PHP 4.3.9 | MySQL 5.0.24a | Apache 2.0.x

I just moved my database to a different mysql server. I updated the config.inc.php file with the new connection information, but my forums won't come up - I just get a blank page. My apache log has tons of errors too. Here's a little sample:
[][client 65.191.146.5] PHP Notice: Undefined variable: tbopen in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1457, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Notice: Undefined variable: tbclose in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1458, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: not_right(/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//ubbt_notright.tmpl): failed to open stream: No such file or directory in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 618, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: not_right(): Failed opening '/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//ubbt_notright.tmpl' for inclusion (include_path='.:/Library/Tenon/WebServer/WebSites/globals') in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 618, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: table_wrapper(/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//tbopen.tmpl): failed to open stream: No such file or directory in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1454, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: table_wrapper(): Failed opening '/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//tbopen.tmpl' for inclusion (include_path='.:/Library/Tenon/WebServer/WebSites/globals') in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1454, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: table_wrapper(/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//tbclose.tmpl): failed to open stream: No such file or directory in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1455, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Warning: table_wrapper(): Failed opening '/Library/Tenon/WebServer/WebSites/www.realtree.com/forums//templates//tbclose.tmpl' for inclusion (include_path='.:/Library/Tenon/WebServer/WebSites/globals') in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1455, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Notice: Undefined variable: tbopen in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1457, referer: http://www.realtree.com/
[client 65.191.146.5] PHP Notice: Undefined variable: tbclose in /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php on line 1458, referer: http://www.realtree.com/<br />
<hr /></blockquote><font class="post">

Notice that "Default" is missing from the template path. What gives?

On line 217 of ubbt.inc.php I have:
$tempstyle = "default";

Hmm, that's odd. Did anything else get changed at all? Are those the only errors in the error log? Anything about the mysql connection?

No errors related to the MySQL connection. All I did was move my dumped database to a new server and import it. I have other apps on my webserver connecting to the MySQL server with no problems. If I change the $config['dbserver'] from "localhost" to "216.168.63.109", my board will immediately fail with the errors above.

Any idea why the template path is failing?

I went from using MySQL 4.0.18 to 5.0.24a.

I had to change the MySQL password to the old format, then I was able to connect. But, I'm getting a new error now:

Script: /Library/Tenon/WebServer/WebSites/www.realtree.com/forums/ubbt.inc.php
Line#: 1608
SQL Error: Table 'ubb-realtree.w3t_Users' doesn't exist
SQL Error #: 1146
Query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned,U_LastOn,U_OC_Userid FROM w3t_Users WHERE U_Number = ''

Aren't table names case sensitive? If so, ubb-realtree.w3t_Users should be ubb-realtree.w3t_users

And, a clean install of 6.5.5 is working. This is weird.

I just noticed that my original database is all lower case. The clean install uses upper case for the table names.

That's definitely a problem. It doesn't seem that it preserved the case of your database when exporting or importing. You'll want to check the backup to see if it was an issue when backing up or when importing.

One more thing. Just noticed that you said you've moved to MYSQL 5. The current 6.5.5 version does not fully support MySQL 5, only MySQL 4. We do fully support this in version 7 however.

I capitalized table names, and the problems seem to be gone.

What types of things should I look out for with MySQL 5?