Auto Update from 3.0.10->3.0.11 hangs?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Tue Sep 25, 2012 3:53 am

Support Request Template
What version of phpBB are you using? phpBB 3.0.10
What is your board's URL? http://stompboxes.co.uk/forum/index.php
Who do you host your board with? heartinternet.co.uk
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
What version of phpBB3 did you update from? phpBB 3.0.10
What styles do you currently have installed? prosilver subsilver2 darksunyellow * Minimal
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
When did your problem begin? On auto update from 3.0.10 -> 3.0.11
Please describe your problem. Downloaded the auto update package here: https://www.phpbb.com/files/release/php ... 3.0.11.zip
Unpacked the archive. Uploaded the complete uncompressed install folder to the phpBB root directory (where your config.php file is).
Pointed browser to the install folder. Followed instructions.

Updating database to latest stable release
Database type :: mysql4 <why does it say Mysql4? I'm using mysql5>
Previous version :: 3.0.10
Updated version :: 3.0.11

Updating database schema
Progress :: Done
Result :: No errors

Updating data
Progress ::

And it just sits there -- no advance.
I stopped after a while and deleted the install folder, so the board's back up, but I can't seem to get it to update to 3.0.11.
Generated by SRT Generator

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Tue Sep 25, 2012 4:50 am

Since you have no MODs the easiest way to update is by file replacement.

Before proceeding backup all files and the database.
  • Download the Latest Version.
  • Unzip to your desktop and open the phpBB3 folder.
  • Remove (delete) the config.php file, and the /images and /files folders from the package.
  • Via FTP upload the remaining files and folders to the root of your board installation on the server overwriting the existing files.
  • In your browser go to http://stompboxes.co.uk/forum/install/d ... update.php
  • Let that run to completion.
  • Via FTP delete the install folder from the root of your board installation.
  • Via FTP open the cache folder and delete everything EXCEPT, index.htm and .htaccess (if you can see that).
  • Done.
Only use a good FTP client, such as FileZilla, to transfer the files. (File transfer utilities provided in host control panels can cause problems.)

Please note: Any 3rd party style will also require updating, style and board versions must match. Your darksunyellow style appears to be for phpBB 3.0.0, so is very out of date and will be causing problems and won't allow you to take advantage of things such as the better anti-spam measures now available.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Tue Sep 25, 2012 4:57 am

Oyabun1 wrote:Since you have no MODs the easiest way to update is by file replacement.

Before proceeding backup all files and the database.
  • Download the Latest Version.
  • Unzip to your desktop and open the phpBB3 folder.
  • Remove (delete) the config.php file, and the /images and /files folders from the package.
  • Via FTP upload the remaining files and folders to the root of your board installation on the server overwriting the existing files.
  • In your browser go to http://stompboxes.co.uk/forum/install/d ... update.php
  • Let that run to completion.
  • Via FTP delete the install folder from the root of your board installation.
  • Via FTP open the cache folder and delete everything EXCEPT, index.htm and .htaccess (if you can see that).
  • Done.
Only use a good FTP client, such as FileZilla, to transfer the files. (File transfer utilities provided in host control panels can cause problems.)

Please note: Any 3rd party style will also require updating, style and board versions must match. Your darksunyellow style appears to be for phpBB 3.0.0, so is very out of date and will be causing problems and won't allow you to take advantage of things such as the better anti-spam measures now available.
Thanks for the info.
What's the best way to update the old darksunyellow style?

User avatar
Lumpy Burgertushie
Registered User
Posts: 66470
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Lumpy Burgertushie » Tue Sep 25, 2012 5:47 am

pick a newer style that is similar. one that far out of date will need hundreds of code edits to bring it up to date.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Tue Sep 25, 2012 6:19 am

Yes, unless you can find an up to date version of that style then you either need to put aside several hours to do the edits or find a new style. There are numerous styles in the Styles database.

Here are the style code changes for 3.0.0 to 3.0.11.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Tue Nov 13, 2012 7:46 am

Hi, thanks for all the help so far.
I ditched the out of date style and followed the instructions for replacing the phpBB install with the latest version (keeping my old config.php, images and files directories).

When I run http://*********/forum/install/database_update.php it still hangs.

Any idea how I can debug this further? I don't seem to be able to update the forum SW to 3.0.11

Thanks
Attachments
borkedupdate.png
update hangs at this screen
borkedupdate.png (32.5 KiB) Viewed 412 times

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Tue Nov 13, 2012 8:58 am

You will probably need to to the database update in stages.

Try uploading the /install folder and running the database_update.php file, in turn, from:
phpBB-3.0.0_to_3.0.4.zip
then
phpBB-3.0.4_to_3.0.6.zip
then the one already tried.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Tue Nov 13, 2012 9:07 am

You reckon? The board is already at 3.0.10 though ... and I've ditched that old style for a newer one.
The last update to 3.0.10 went fine, it's just this 3.0.10->3.0.11 that is causing me grief.
Even after uploading the full install, except my config.php and images and files directories, my ACP still says the board is out of date and is running 3.0.10.
I've tried leaving the database update running for hours and it doesn't advance.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Tue Nov 13, 2012 9:16 am

Sorry, I was mixing up board versions and style versions.

If the update didn't finish you may need to clear the database entry phpBB uses to track that. Run this SQL query

Code: Select all

DELETE FROM phpbb_config WHERE config_name = 'version_update_from';
Change phpbb_ if that is not your table prefix.

Always backup the database before making any changes to it.

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running queries.

Then try the database update again.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Wed Nov 14, 2012 7:04 am

Thanks -- cleared that entry in the database but the update still just hangs ... :?

Code: Select all

Updating database to latest stable release
Database type :: mysql4
Previous version :: 3.0.10
Updated version :: 3.0.11
Updating database schema
Progress :: Done
Result :: No errors
Updating data
Progress :: . 
It just sits there -- no change.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Wed Nov 14, 2012 8:03 am

There were very few database changes from 3.0.10 to 3.0.11, so I'm not sure why it wouldn't complete.

It may be that the database is already up to date. Run this query

Code: Select all

SELECT field_show_novalue FROM phpbb_profile_fields
Should return an empty result rather than an unknown column error.

Also this query

Code: Select all

SELECT config_value FROM `phpbb_config` WHERE config_name = 'version';
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Wed Nov 14, 2012 8:19 am

Oyabun1 wrote:There were very few database changes from 3.0.10 to 3.0.11, so I'm not sure why it wouldn't complete.
It may be that the database is already up to date. Run this query

Code: Select all

SELECT field_show_novalue FROM phpbb_profile_fields
Should return an empty result rather than an unknown column error.
I get 6 entries all with a value of 0, so empty.
Oyabun1 wrote:Also this query

Code: Select all

SELECT config_value FROM `phpbb_config` WHERE config_name = 'version';
3.0.10

I'm stumped...

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by Oyabun1 » Wed Nov 14, 2012 8:34 am

It should be safe to just update the version number in the database with these queries

Code: Select all

DELETE FROM phpbb_config WHERE config_name = 'version_update_from';
UPDATE phpbb_config SET config_value = '3.0.11' WHERE config_name = 'version';
Then you should be done.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
devnulljp
Registered User
Posts: 43
Joined: Fri Aug 20, 2010 4:07 pm

Re: Auto Update from 3.0.10->3.0.11 hangs?

Post by devnulljp » Wed Nov 14, 2012 8:48 am

Oyabun1 wrote:It should be safe to just update the version number in the database with these queries

Code: Select all

DELETE FROM phpbb_config WHERE config_name = 'version_update_from';
UPDATE phpbb_config SET config_value = '3.0.11' WHERE config_name = 'version';
Then you should be done.
Thanks! That seems to have done the trick.

Locked

Return to “[3.0.x] Support Forum”