db upgrade question

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

db upgrade question

Post by Curmudgeon »

Upgraded from 3.1.x

It is telling me I need to go to the updater, selected "upgrade db only" but I do not see that as an option.
It won't allow me to do anything but click the update button for all from the install folder.

Warning I'm getting:
Incomplete update
We noticed that the last update of your phpBB installation hasn’t been completed. Visit the database updater, ensure Update database only is selected and click on Submit. Don't forget to delete the "install"-directory after you have updated the database successfully.
~~~
Image

I cannot just select the "Update database" I can only click on the update button.
Image

Sure I've missed something simple.

I'm currently trying to find the procedure for manually accomplishing this.

Thanks
Last edited by Curmudgeon on Thu Dec 13, 2018 5:11 pm, edited 1 time in total.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

Curmudgeon wrote: Thu Dec 13, 2018 4:45 pm Upgraded from 3.1.x

It is telling me I need to go to the updater, selected "upgrade db only" but I do not see that as an option.
It won't allow me to do anything but click the update button for all from the install folder.
...
somemore information is needed. Use the SRT (https://www.phpbb.com/support/srt/).
Not sure what you're doing, but hopefully it's not the autoupdate.
If you're upgrading to 3.2.x go to install/app.php and select update_database (something similar to that) (it's not on the first page).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: db upgrade question

Post by Lumpy Burgertushie »

what happens when you click on that big "update" button at the bottom of the page you showed above?

click on that, on the next page you should see a message about updating the database only, click on that.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

Support Request Template
What version of phpBB are you using? phpBB 3.2.4
What is your board's URL? http://mobtalk.org/board/
Who do you host your board with? Bluehost.com
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.1.2
What styles do you currently have installed? ProSilver
What language(s) is your board currently using? British English
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Followed upgrade procedure provided by phpBB support site.
Please describe your problem. Sta2tes I need to update my database.

Files Version 3.2.4
Database version 3.1.1
Generated by SRT Generator
Last edited by Curmudgeon on Thu Dec 13, 2018 5:32 pm, edited 1 time in total.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

Lumpy Burgertushie wrote: Thu Dec 13, 2018 5:20 pm what happens when you click on that big "update" button at the bottom of the page you showed above?

click on that, on the next page you should see a message about updating the database only, click on that.


robert
Image
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

The picture immediately point to the cause.

Make sure you have the correct files for the version you want to upgrade to.It's best to reupload a new set of files (read the documentation).
Should you not follow the procedure described, then
replace your install directory by a new one (from the download)
delete from /cache: the directories /installer and /production
delete from /store: io_lock.lock + any files with names migrationXXXX

go to install/app.php and do database update
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

There is no "module" subdirectory in the 3.2.4 pkg so not on server either.

Image


I did find the "language.php" but not in the specified path.


Image

So I can just copy the file to the proper subdir?
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

Curmudgeon wrote: Thu Dec 13, 2018 6:10 pm So I can just copy the file to the proper subdir?
That's not what I said (at all).
The error is that you used autoupdate which should only be used for minor version updates (hence "update") . You are going from 3.1 to 3.2 and that's an upgrade.
Full package is the way to go. What I said about removing some specific files was to ensure that you would know about it, in case you decided to overwrite with the full package, instead of replacing.
BTW don't overwrite your config.php

edited for spelling mistakes, missing letters, etc..
Last edited by warmweer on Thu Dec 13, 2018 7:08 pm, edited 1 time in total.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

I didn't use autoupdate until after I got the error and couldn't select the database part of it.

In either case still a missing path/subdirectory.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

Curmudgeon wrote: Thu Dec 13, 2018 6:32 pm I didn't use autoupdate until after I got the error and couldn't select the database part of it.

In either case still a missing path/subdirectory.
It doesn't matter. Now you have to use the full files package and update database (through install.app). (and make sure that the files I mentioned are removed).

What I would do (but is strictly speaking not necessary) is to:
check the config_table, set the version back to the version you upgraded from (3.1.2)
migrations_table: Remove all entries higher than your start version (so anything above 3.1.2 would be removed) (again this is my personal advice, not endorsed by phpBB).


added: you might want to apply the fixes for 3.2.4 (see the sticky Known Isuues in 3.2.4) before the upgrade.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

Sorry for the delay, decided to finish my redoing my living room.

Ready to tackle this again now.

I restored my 3.1.2 forum & have followed the update procedure for 3.2.4 it again.

I have NOT hit the "Update" for any part of it.

It isn't letting me selected the "Update database" option.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

Curmudgeon wrote: Mon Dec 17, 2018 8:45 pm I have NOT hit the "Update" for any part of it.

It isn't letting me selected the "Update database" option.
There should be an update button somewhere This wil take you to the next page where you can choose database update.

BTW, immediately after upgrading: be sure to apply the fixes for 3.2.4 mentioned in viewtopic.php?f=556&t=2492371.
Alternatively you could apply the fixes before upgrading.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Curmudgeon
Registered User
Posts: 67
Joined: Thu Jun 14, 2012 9:51 am

Re: db upgrade question

Post by Curmudgeon »

Never figured out how to get there to update the db & no one ever responded with a manual way to do the update. I'm just going to start from scratch.

Now, I'm not a programmer, the guy who did had to quit to address his own health issue. This sort of thing has never been more than a hobby, no fees ever charged, no advertising...just talk.

The "fix" you linked to, do I just save those to a file of the same name and put them into the proper path/directory or do I need to edit files of that name? I am not clear on that. This is all I have left to do, the new system is up, running and waiting for me to flesh it out.

I will be tackling learning some programming in the near future my own education, phpbb & for some robotics or delving into the Python arena.

btw, Thanks for your assistance & patience in this.
User avatar
warmweer
Jr. Extension Validator
Posts: 11233
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: db upgrade question

Post by warmweer »

Curmudgeon wrote: Fri Dec 21, 2018 9:10 pm The "fix" you linked to, do I just save those to a file of the same name and put them into the proper path/directory or do I need to edit files of that name?
There is a link to 2 files to download: those 2 files are the fixed ones, and should replace the 2 files with the same names (bbcode.php and functions_content.php, both in/incudes IIRC)
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “[3.2.x] Support Forum”