UBBCentral

upgrade issue 7.6.2 >>> 7.7.1

Posted By: Morgan

upgrade issue 7.6.2 >>> 7.7.1 - 03/02/2019 12:39 PM

Hi I am upgrading right now from 7.6.2 >>> 7.7.1

The forum is closed

I clicked on the upgrade link and passed one page now at File check and one file is out of date

The following files are reporting a wrong version number
(Make sure you updated these files)
libs/mysql.inc.php

see image, There is no such file in the 7.7.1 zip file. However there is a file named mysqli.inc.php which is almost same..

Please advise help help help

PS I did notice that in the Libs directory some files are set to 666, 755 and 777. should all be 666 within the Libs directory?

See http://www.britbike.com/ubbt_test.php there is a missmatch in the versions

Attached picture Skärmavbild 2019-03-02 kl. 13.27.14.jpg
Posted By: Philipp

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/02/2019 1:42 PM

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:
Code
VERSION-7.7.1:CHANGED: templates/default/newpost.tpl


the following:
Code
VERSION-7.7.1:REMOVED: libs/mysql.inc.php
Posted By: Morgan

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/02/2019 1:49 PM

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
Posted By: Morgan

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/02/2019 1:52 PM

Phillip I only saw your reply after I did above
I am using MYSQL 5.6 43

Thanks for your help anyway
Posted By: Morgan

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/03/2019 8:13 AM

Have now used 7.7.1 for a day and it works fine with Mysql 5.6.
I would like to address above issue as a bug. Could the thread be moved there?

Cheers
Posted By: isaac

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/03/2019 5:48 PM

https://www.ubbcentral.com/forums/u...threads-7-7-1-released-updates-and-fixes
Posted By: Morgan

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/03/2019 9:08 PM

@Isaac

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
Posted By: isaac

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/03/2019 9:09 PM

thumbsup
Posted By: M4TT

libs/mysql.inc.php upgrade problem - 03/13/2019 7:30 AM

Hi,

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.

Attached picture bug.png
Attached picture bug2.png
Posted By: Philipp

Re: libs/mysql.inc.php upgrade problem - 03/13/2019 7:52 AM

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.
Posted By: isaac

Re: libs/mysql.inc.php upgrade problem - 03/13/2019 7:53 AM

it sounds like you are trying to upgrade with the old upgrader. this issue has been patched and commented on within the changelog discussion thread at
https://www.ubbcentral.com/forums/u...threads-7-7-1-released-updates-and-fixes

Quote
2019-03-02 Update:
A release refresh to fix install issues has been posted to the member area.
Posted By: M4TT

Re: libs/mysql.inc.php upgrade problem - 03/13/2019 8:11 AM

Quote
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.
Posted By: isaac

Re: libs/mysql.inc.php upgrade problem - 03/13/2019 8:44 AM

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.


Source
https://www.ubbcentral.com/forums/ubbthreads.php/topics/262141/7-7-1-changelog-discussion
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/13/2019 11:33 PM

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.
Posted By: Gizmo

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/13/2019 11:54 PM

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).
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/13/2019 11:59 PM

Originally Posted by Gizmo
[...]could you open the upgrade_changes file and note which instances of mysql.inc.php display?


From upgrade_changes (date modified 02/03/2019 2:46 pm):

VERSION-7.7.1:REMOVED: libs/mysql.inc.php
Posted By: Gizmo

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 12:01 AM

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.
Posted By: Ruben

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 10:12 PM

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?
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 10:15 PM

I will say it again, I have followed the "upgrade guide", not the install guide. How does one remove the step that causes this loop?
Posted By: Ruben

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 10:19 PM

Just to make sure the upgrade guide you used is correct for the current version.
Which one did you use?
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 10:31 PM

This 7 upgrade guide:

https://www.ubbcentral.com/doc_upgrade7.php
Posted By: Ruben

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/14/2019 10:52 PM

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.






Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/15/2019 6:50 AM

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...
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/15/2019 10:28 AM

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.
Posted By: Ruben

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/15/2019 4:28 PM

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.
Posted By: M4TT

Re: upgrade issue 7.6.2 >>> 7.7.1 - 03/15/2019 9:36 PM

Okay, because every time I do a forum search, it highlights the keyword searched on every post and the highlights literally save everywhere.

For example, I search "Patch Notes" and any posts that have that phrase is highlighted permanently, even when I leave the search query.
© 2019 UBB.threads PHP Forum Software Community