mysql.inc.php was the old (7.6 and below) MySQL driver, while mysqli.inc.php is the new PHP 7.x compatible MySQL driver. Look like mysql.inc.php was removed from the latest ZIP without updating the UPGRADE_CHANGES.txt file.
The following fix should work: Open install/UPGRADE_CHANGES.txt in an editor and add after line 17:
Well I went back to see in 7.7.1 zip the mysqli.inc.php is missing there.. so I went and downloaded 7.7.0 and there is was so I uploaded from 7.7.0 and I passed by all steps and it said Congratulations. You have successfully updated to UBB.threads 7.7.1. Please remove the entire install directory. ... which I did and it seems to work now I have open forum and posted a new thread
I uploaded the files in 16-ubbthreads-7-7-1p1 2019-03-02 Update: A patch to fix "email notifications on PHP 7.1+" issues has been posted to the member area. A release refresh to fix install issues has been posted to the member area.
So I reckon I'm upto date now and can await 7.7.2 before I upgrade my MySQL version to 5.7 or higher
I uploaded a backup copy of mysql.inc.php to the libs directory and clicked check files again only for it to say it needs to be deleted... After that it says it needs to be uploaded, in a continuous loop.
Could this be because I uploaded the files and directories outlined in upgrade guidelines accidentally using "if source newer" and running the upgrade? Once that happened it said a lot of files had the wrong version. So I closed my Filezilla and re-uploaded all the files and directories again, only this time overwriting.
mysql.inc.php has been replaced with mysqli.inc.php in UBB.threads 7.7. It seems the problem is that /install/UPGRADE_CHANGES.txt has still references to mysql.inc.php in it.
You find in attachment an updated UPGRADE_CHANGES.txt where all NEW/CHANGED references to mysql.inc.php has been removed. This should fix the problem.
If you're having problems with the ubbthreads-7-7-1.zip package you've downloaded prior to 2019-03-02, download this main .zip file again. This release refresh also includes within it the patch mentioned above.
I had done a new download of the refresh and applied the patch anyways overwriting the files outlined... I'm attempting a retry on everything.
M4TT, the 7.7.1 patch is for when you already have UBB.threads 7.7.1 installed. It patches 7.7.1.
Your first post (and screenshots) said that you were having problems using the upgrader to install 7.7.1. And that you were not yet on 7.7.1. You need to use the upgrade package to perform the upgrade.
Quote
2019-03-02 UPDATE: [...] • ubbthreads-7-7-1.zip has been updated within the Member Area This is a release refresh and is intended to fix any previously reported install issues. If you're having problems with the ubbthreads-7-7-1.zip package you've downloaded prior to 2019-03-02, download this main .zip file again. This release refresh also includes within it the patch mentioned above.
I downloaded the ubbthreads-7-7-1.zip file from the Member Area last night, it shows 29/01/2019 9:07 AM. I followed the 7 Upgrade Guide twice and the resulting error occurred each time. I've restored my directory prior to the procedures and will attempt another round. Is it possible to do a clean install and somehow patch in the database? I'm able to do clean installations with no error. It's the upgrade that's causing a loop.
The missing mysql.inc.php issue in the upgrader should have been cleared up with the last refresh; could you open the upgrade_changes file and note which instances of mysql.inc.php display? Mine only shows the remove line which is correct (as we've removed it since we've move to mysqli).
And it won't progress past the missing mysql step in the upgrader still? The issue affecting prior installs was previous mentions of the file existing in the upgrader; I guess you could remove that step and then progress through the installer.
This may be redundant/remedial, But when you upload the files to the site. It does not delete existing files.
Maybe you need to clean up the folders on the site first before uploading. Bear in mind that to follow the upgrade directions not the install directions. So you don't wipe needed scripts for a existing site.
I can't fathom why this is so difficult. The last few versions have become almost plug and play compared to prior ones.
From your post , I assume you know the difference from running the upgrade script versus the install script?
Last edited by Ruben; 03/14/20196:17 PM.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
That should be correct. Just a note. It appears that your site is at ubb 7.6.1.1 not 7.6.2. Also you have implemented some custom modifications. Which I have no idea where you did them but If it is in the stock code that was not replaced in the upgrade could be an issue.
Without reading all the changelog notes on db changes on the different versions. You stated a fresh new install works? Why not try a fresh test install again. And then edit the includes/config.inc.php to point to the original database of the one you are attempting to upgrade. The main info is like the first few lines.
Then if it works add in your modifications till it breaks again.
Last edited by Ruben; 03/14/20197:23 PM. Reason: Added Comment
Blue Man Group There is no such thing as stupid questions. Just stupid answers
Giving it a shot! This way I'll overhaul everything and remove what I no longer need in the directories...I'm continuously learning the internals of UBB and coding as a result of the site's work... Thanks Ruben and everyone for your quick response, it is much appreciated...
It was a successful "install" after manually adding modifications, images, etc. Lots of link brokenness and stuff that needs to be fixed as a result, but otherwise it all worked out as far as I can tell at this time. Nothing wrong with the fresh installation to report. I'm rewarding my users with a special lab rat badge if they find any problems lol.
If you are going to keep that install. I stringly suggest to read the upgrade instructions file in the ubb forum zip you downloaded. There are a couple of tweaks to the database you may not have. The instruction tells you how to manually fix it. Plus other info you may need to correct.
Don't forget to make a backup before you touch it.
Blue Man Group There is no such thing as stupid questions. Just stupid answers