I was trying to move from our current Domain name with V 7.5.3
to NewDomain name with 7.5.4.1

Started by copying it to NewDomain, but got a UBB error.
So, tried this.
Copied the 7.5.4.1 files with the old database in place on the new server.
Ran the Update.php -- fixed the file permissions.
Couldn't find ubbt_VERSION.
This table was listed as "ubbt_version" in the db.
Changed it to upper case and then the update check worked.
Then it couldn't find "ubbt_USERS"...
etc etc.

Well, all of my files have lower case names since current Domain was a Windows server.

New Domain is Linux.

QUESTION: Why is 7.5.4.1 looking for Upper Case file names?

Current login error is:
"UBB Message
We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please click back to return to the previous page."

Upgrade either before or after you move, don't try to do both at the same time.

Changing the domain is easy, open your config file and update the domain name

Okay, I think I'll go back to square one - and upgrade my Current Domain first. Then copy it all over.

Queston about Language files. The instructions are unclear on the upgrade screen. When it talks about manual updates or automatic.

I want to keep all of my previous changes (naturally). But if I select the "automatic" selection, will it just add the three new changes to my current file, or does it overwrite my entire file with all new stuff?

Well, manual is if you want to take the "new strings" and add them by yourself; automatic means it'll try to update it for you

One other thought... after reading the other thread about "Which files do I really need to copy over?"... haha

I sort of agree... do I have to copy ALL of the dang files just for a x.x.x.1 upgrade? Arghhhhh...

Also, why can't the exception folders/files be put under a different location so we don't have to piece-meal them out of the upgrade process? Invent a new folder called "custom" and put EVERYTHING under that which never gets replaced or overwritten.

Oh, well.. going to do the upgrade now... see you later.

yes, I noticed that you avoided answering the UpperCase verses LowerCase question from my first post. :-)

Okay -- I need help.

1. Closed my Forum. Backed up the db and all files
Installed 7.5.4.1 Everything works good.

2. Backed up the db and new files.
Copied the db and new files to my new VPS location.

3. Modified the config.inc file to change each place where it read "old-domain" and replaced with "new-domain"

4. Went to http://new-domain.org/forum/

Got this error message:
"UBB Message We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please click back to return to the previous page."

Looked at the SQL error files and there is no posting with today's date.

SO--- HOW DO I FIND THE ERROR?

Just as I was going to post this, I remembered how to change the setting in libs/mysql.inc.php HOORAY!!!

so -- here it is... dang it... I'm back to the UpperCase vs. LowerCase issue again.

UBB Message
We encountered a problem. The reason reported was
Script: /var/www/vhosts/vcca.org/httpdocs/forum/libs/user.inc.php
Line#: 467
SQL Error: Table 'vccachat_org_-_chat.ubbt_USERS' doesn't exist
SQL Error #: 1146

<<But Table 'vccachat_org_-_chat.ubbt_users' does exist!!!!!>>

I changed the 2 or 3 tables that needed to be upper case.

Now I get this error:

Fatal error: require_once() [function.require]: Failed opening required '\Inetpub\vhosts\vcca.org\httpdocs\forum/libs/functions_forums.inc.php' (include_path='.:') in /var/www/vhosts/vcca.org/httpdocs/forum/scripts/cfrm.inc.php on line 50

The file exists and the "path" appears to be valid. All I see is the mixed / vs \ . It seems to me that a few years ago that was an issue. Is that it again?

All paths in your config file need to use forward slashes vs backslashes.

The file name issue is a windows issue, it doens't care about case, so installed everything lowercase; Linux however does care about case, and wants what it's told it's supposed to use.

Like Gizmo said need to change the slashes to forward.
Easiest thing to do is open your config.inc.php file and scroll through it for incorrect paths.
Like attachments folders etc.

Also you will need to change the case in all of the 60 something tables not just the ones that popped up during the upgrade.

I changed from windows a couple years ago and forgot about metioning those two items.

You will also need to check the case on any url links you may have added in say islands. In Apache, index.html and Index.html and INDEX.html are treated as three unique file names. And can exist in the same folder.
In windows if you attempted to have the same it would just overwrite the previous file and still be one file in the folder.

So, my habit (in Windows) has always been to user LOWER CASE all the time. All files that I've ever created were lower case.

Does UBB demand uppercase on some of the file names? I guess that I never realized that.

So, if I ready your reponses correctly, I should go ahead and RENAME all of my tables to uppercase.
ie. database.ubbt_TABLE