UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support SQL Error #: 1146

I was thrown into a project where we're moving a forum from one server to another. I have no experience with ubbthreads, but I like what I see so far

My current issue is outlined below.

UBB Message We encountered a problem. The reason reported was

Script: /home/mdsfound/public_html/forums/libs/user.inc.php
Line#: 467
SQL Error: Table 'mdsfound_forum.ubbt_USERS' doesn't exist
SQL Error #: 1146
Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = '' AND t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

Any insight would be awesome! We have this setup so DNS is still pointing to live site. I've changed my host file so local DNS resolves to the new server while we work out the bugs.

Thanks in advance for your insights!

The database file was not uploaded into the MySQL.

If it is a large file I usually always do it by command line into the MySQL Server.

I resolved the error by changing the values of the files in questions. The old database used UPPERCASE for tables and the new uses lowercase. I simply changed UPPERCASE values to lowercase and it worked

Now my issue looks like:

Fatal error: require_once() [function.require]: Failed opening required '/home/mdsfound/public_html/forums/scripts/libs/functions_forums.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mdsfound/public_html/forums/scripts/cfrm.inc.php on line 50

Anything look wrong here>?

The table name issue is definitely a gotcha when going from windows to linux. We're going to finally resolve that in v8.

As for your new error. It's a bit strange. It's looking for /forums/scripts/libs/functions_forums.inc.php when it should be looking for /forums/libs/functions_forums.inc.php

Are you getting that from the main page?

I think it has to do with my "FULL_PATH setting in config.inc.php

The old value was c:/inetpub/wwwroot/mds-foundation.org/forums

The new is /home/mdsfound/public_html/forums/scripts

Does this look right?

That was it!!! I took out the /scripts so it refers to /forums without /scripts and I'm on the next error which are more UPPERCASE to lowercase related issues

I'll report back with stuff I get stuck on!

Ah, there's your problem. Chop the /scripts off the end of the new path.

Beat me to the punch

Ok - so it seems that the only problems left are the UPPERCASE table names.

Is there any kind of something to help with this. I got the forum to come up, but of course visiting any link throws more errors.

Any help is greatly appreciated.

you'll need to rename your tables to uppercase.. i've run into this a couple of times

Went through this myself a while back going from windows to Linux.
Assuming your Table Prefix is ubbt the default setting.

The first table should appear as:

ubbt_ADDRESS_BOOK

Done and worked like a charm...

Now I just need to reset the admin password in phpMyAdmin...

Okay , Don't forget the password is stored in the config.inc.php file via the ubb control panel.

Password for database user?

I'll post a new topic about resetting my admin pass.

Yes the database user login.
Kinda a catch 22.
Usually it is easier to edit the config file.