UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support Changing Domain and Upgrading together

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

This is not a ubb issue but a Apache issue.
Never change the case on a ubb script file because Apache will not find it.
Assuming you have the default ubbt prefix in your MYSQL which it looks like you do.
Looking at the first table it should look like:
ubbt_ADDRESS_BOOK
then the next should be
ubbt_ADMIN_LOG
And so on.
I don't even want to get into asp pages. I used them, two years later I am still going through hoops to fix redirects.

As far as external files the habit to use lower case is not the issue.
say you made a home page index.html that is fine.
But if you add a reference to that page somewhere else say in a island and you typed Index.html. Windows will work fine.
But Apache will bark back and say the file does not exist. Because the first letter is upper case.
Also If you have a home page and your url goes to say Ubbthreads.php instead of ubbthreads.php it will not work because of Apache thinks it is a different file.
The funny part in my previous example about the three index.html files. You can have all three in the same folder but when you download a backup it will just overwrite each one.
Just a FYI

I think that all of our links are lowercase.

As for the databases, the names should be uppercase (where your table prefix would be whatever you have set in your config file)

Sorry, guys. I'm getting killed here... been trying for over a day to get the links fixed. This is amazing since I've run a UBB site for over 8 years!!! Ouch.

Here's what I transferred from the old site. (name changed to olddomain.)

'FULL_PATH' => '\\Inetpub\\vhosts\\olddomain.org\\httpdocs\\forum',

AND THE ERROR THAT I GET
Failed opening required '/Inetpub/vhosts/newdomain.org/httpdocs/forum/libs/functions_forums.inc.php' (include_path='.:')

I've changed every "\\" to a "/" and it still doesn't work. Also changed just one at a time and still no workee.

It seems to me that two "\" equals one. Right?

Any ideas what I can try next?

Oh, what the heck... here's the current link:
http://vcca.org/forum/

I doubt that path is correct; I highly doubt your new host has inetpub since it's a linux host... you'll want to get the new full path from the host.

They'll likely give you the full path to the directory under your web root (where you end up when you login via a FTP client) from here you'd have to direct it to your ubb install.

Example, if they tell you:
/home/yoursite.tld/

And when you login to your FTP you see "public_html" and you have a "forum" directory under that, then your UBB directory would be:
/home/yoursite.tld/public_html/forum

Yep.. That was it... dang... so obvious... Linux (NOT Windows)
For the record the path was:

/var/www/vhosts/domain.com/httpdocs