Posted By: DennyP 7.6.2 Installation Pickle - 01/01/2019 5:43 AM
I'm afraid I've gotten myself in a pickle. I was running a installation. I was refreshing some directories on my web site by uploading directories from my source copy of directoris to my web server. I accidentally clicked on my ubbthreads source directory and uploaded ALL the files and subdirectories to my server. Needless to say, that has stopped my message board from working. I downloaded and unzipped the 7.6.2 install files and followed the upgrade documentation and uploaded files from the new 7.6.2 install directories to my server. I started the upgrade script.

The Check Files listed changed, new and removed files. I manually removed the files from my server that were in the removed files section. I confirmed that the files in the new files section were on the server. I reuploaded all the files listed in the changed files section. I clicked on Check Files again and the same files were listed in each section. I can't get past the check files screen.

Any suggestions.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/01/2019 6:33 AM
The files in the Changed Files section are:

The files in the New Files section are: (they are all there)

The files in the Removed section are: (I deleted these files)
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/01/2019 5:00 PM
I did check file permissions.

The upgrade document has a sentence saying to upload files and directories from the unzipped file except for a couple of directories and one php file. Under that sentence is Upload These: followed by a list of files and directories.

There are some files and directories that are not lised under Upload These - like templates/compile and some files in the styles directory. The instructions don't include those files in the list that should be uploaded and they also are not in the list to not be uploaded. Should those be uploaded?
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/01/2019 5:55 PM
Originally Posted by DennyP
I was running a installation..
I wasn't doing an installation. I have been on a system running successfully for quite some time. I wanted to clarify that. I wasn't doing an installation.
Posted By: Gizmo Re: 7.6.2 Installation Pickle - 01/01/2019 6:04 PM
I would copy all files from a hard backup back to the site to restore it to working conditions; as data is stored in a database the above actions shouldn't affect any forum data.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/01/2019 6:08 PM
Thanks for that reply. If I had a hard backup of the server ubbthreads directory, I would have already tried that. But unfortunately, I don't. Any other suggestions?

I back up my server settings and email. I don't have enough storage to backup my whole server.
Posted By: Gizmo Re: 7.6.2 Installation Pickle - 01/01/2019 6:15 PM
Other than restoration from a backup, there isn't really a method to restore your configuration, or wrappers configuration (styles), or custom islands from being overwritten.

What all did you replace? The only thing that should really matter is that your includes directory is complete as it includes information for scripts to communicate with the database.

Are you attempting to perform an upgrade to a new version or to one you're already running? The upgrade utility assumes that you are upgrading a fully functioning forum.

Files displayed in the management screen in the upgrade utility can be found in the install folder, I believe it's upgrade_changes.txt, simply remove the offending lines between your target version and existing (the lines have version indications).

UBB.threads is only a few megabytes if you only backup operational files, I'm sure you have enough space for it to be included in your backup plan.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/01/2019 6:30 PM
I basically copied the entire ubb source directory (& all subdirectories and files) from the source location to the server. I was uploading some non-ubb related directories and accidentally clicked on the ubb source directory in my FTP program.

I then downloaded the 7.6.2 zip files, unzipped them, and uploaded directories and files as listed in the upgrade docs. I then ran the ugprade script and ran into the Check Files issue.

So to answer your question, I wasn't running a 7.6.2 upgrade on a fully functional forum. It was broken because a lot of files were overwritten from the source of

My database is intact (and backed up nightly). Can I just download that version's install files and do a clean install without initializing the database? Or is there some other suggestion you might have.

Is there a way to verify for certainty what version my system was on before doing the clean install to be sure my database is the correct version for the code?

I probaby do have enough space to backup operational files once I get working again. Is there a list of what those files would be that I need?

I also need to be sure I don't call my local source directory the same as it is called on the server in case the same thing were to occur again.

Thanks again.
Posted By: Gizmo Re: 7.6.2 Installation Pickle - 01/01/2019 11:39 PM
You're now in the waters of a "non standard upgrade", meaning that anything can really happen and support will be marginal at best. In order to upgrade your database you will need to fully process through the upgrade script.

You can utilize the UBB.threads System Requirements Test to report the version number stored in your database.

How I'd tackle it would be to either snag a blank configuration file and populate the UBB.threads database information for your server (which was made specifically for this reason), or restore one from backup so you can connect to the database, then update the configuration options through the Control Panel; again, this is what a full backup of your site will contain...

You'll have to sort through the upgrade error you indicated, where it shows files to be managed which aren't being managed, you'll need to update the "UPGRADE_CHANGES.txt" file in the install/ folder to remove the entries so they're not checked; as previously stated. I would ONLY remove files from here if you're attempting to get the upgrade script to process your CURRENT version; as files were changed in v7.6.2.

I had a complete drive failure at one of my hosts several years back, part of my recovery was to restore files from backup that I had on hand, vs waiting on the host to figure out if they had backups and figure out when to delegate them to me. I fear to know what will happen if something happens to you. I create weekly database backups and a monthly flatfile system backup, and store the resulting files on my DropBox Professional account (off site storage).

At the VERY LEAST I'd advise backing up your /cache_builders/custom and /includes folders, and the /styles/wrappers.php file; but unless you're familiar with advanced recovery I'd advise that you take a backup of all of the files in your UBB.threads install (keep in mind, if you loose your attachments or gallery folders you'll loose a lot of content, if attachments or gallery forums are something that your forum offers).
Posted By: Ruben Re: 7.6.2 Installation Pickle - 01/02/2019 4:26 PM
the first recover mistake made was trying to upgrade a non functional forum from to 7.6.2

If you have nothing as far as a backup of your files. You may try to contact your host and see if they can restore the folders.
They do make backups on some time basis. just for their use and they may offer a solution to reload the folders.

Some of the important folders is as gizmo stated

If the host can't help you, you may also try to do a fresh install in the same folder but use a net new database just for the install..
Make a backup of the site files first
Then I would just watch the ftp program and overwrite everything from the zip file in the members area ver
Then just edit includes/config.inc.php with the old original good database connection info.
Then you can go over the complete cp and manually add back all of your missing items that you can.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/02/2019 4:54 PM
I saved both the original source and server directories. I renamed the original database and did a fresh install. It did come up ok.

I will try pointing the config file to the original database and see if I can salvage anything.

I really do appreciate all the assistance.
Posted By: Ruben Re: 7.6.2 Installation Pickle - 01/02/2019 4:59 PM
what ever is missing you may be able to salvage from the files backup you made.


But it appears you still have ver 7.6.2 loaded.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/02/2019 6:03 PM
Ruben - I think you're a genius. I pointed my new 7.6.2 install to the old 7.1.1 sql file and the system came up with what appears to be all users and posts intact. Of course I have to go back through the CP and make some updates, but that is minor. So I think I'm in business. I do have to do more checking to be sure everything is working. Thank you so much for the suggestion.

Were there any sql file updates between 7.1.1 and 7.6.2 that might come back to bite me? If so, is there a script to do the update available?

Thanks again.
Posted By: Ruben Re: 7.6.2 Installation Pickle - 01/02/2019 6:13 PM
I don't think there were any db changes.
But you should have used the file first.
Any way your html includes may be gone which may be in the includes folde(header/footer)r as well as some styles which you may be able to just copy the files back from your backup..(the pointer is in the db, but still needs the file)
Then if you have custom islands they will be in the cachbuilders/custom folder.

Then if you have a gallery forum the will be in the gallery folder..
Some files would have been over written.
But some will not have been.

Anyway when you get it close make another backup of your files.

The posts should all be good they are in the db.
But another place to look is uploaded avatars and images for missing files.

Since I am not sure what you actually did to break the site.

Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/02/2019 6:24 PM
Originally Posted by Ruben

But you should have used the file first.

The initial problem was that I had overwritten all the server files with the base install files and overwrote anything that was changed since the upgrade of 7.6.1 months ago. I did not have a backup of the server files other than a daily database backup.

I don't use the gallery. I do have some styles to reload - that's a minor task. I do have some other small CP updates. But so far, it's looking a lot better than it was yesterday.

Thanks again.
Posted By: Ruben Re: 7.6.2 Installation Pickle - 01/02/2019 6:26 PM
You still have the forum closed so I can't see anything

One more thought.
You may or may not need to run the re builders to clean it up.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/02/2019 6:30 PM
Yes, I am keeping it closed until I go through the whole CP and get things back to "normal". Otherwise I'll be swamped with calls and emails about it not looking and operating the same.

Thanks so much.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/07/2019 2:21 AM
Since I had a lot of useful help above, I wanted to pay it back with a summary of what I did in case it might help anyone else.

Summary of problem - the server ubbthreads directory was overwritten with a copy of the old install directory in effect wiping out everything on the server. The database was fine and untoucher.

  • I downloaded the current install zip file
  • Installed the current version using a different database name
  • Changed the database name in the config.php file in the include directory to point back to the original database
  • Logged in and ran all the rebuild scripts
  • Went though all the contral panel settings to set them to what I had before
  • Reinstalled all the style wrappers

I thank everyone who helped get back in operation with no loss of data or members.
Posted By: isaac Re: 7.6.2 Installation Pickle - 01/07/2019 3:32 AM
backup, backup, and backup.

Keep a scheduled backup.
Backup before you make major changes or upgrades.
If it means anything to you now, make a backup of it for for later when you may need it.

If everything is setup and working for you now, it's time to make that backup thumbsup

NOTES from UBB.threads 7.6.1 Changelog dated 2017-05-02:
[NEW] The current forum config file is now backed up before new changes are saved. Normally there would be no need for this step, though an incorrectly configured server or php.ini setting may cause havoc and corrupt the new config file creation process. A forum owner can now roll back to their backup config file, if the new one was corrupted upon its creation.
SOURCE: https://www.ubbcentral.com/forums/u...e-ubb-threads-7-6-1-changelog#Post260196

UBB.threads 7.6.1 also brings with it some much needed updating of the SQL database exporting utility:

Though, none of that means anything unless you export that data from your server, and store it elsewhere.
Posted By: Ruben Re: 7.6.2 Installation Pickle - 01/07/2019 7:40 PM
And back up means database and all folders and files.
Most hosts have a back up utility in the control panel such as cpanel. for both.

And remember that after the next post the backup is outdated.
Posted By: DennyP Re: 7.6.2 Installation Pickle - 01/07/2019 7:46 PM
I do use Plesk on my server to back up system files like email and control panel files for the system. But my web site has well over 20,000 files and is too large to back up. I do maintain a source copy of all the pages on my local system. Those copies do get backed up to 2 places (on site and off site) each night. Additionally, there is a real time backup of changes using Carbonite. It was only the ubbthreads directory that isn't in my souce copy locally since it dynamically changes. I wrote a script to back that up nightly.

So now, I think at most my exposure is one day of new/changed posts and subscriber activity. I can live with that.

Thanks again.
© 2019 UBB.threads PHP Forum Software Community