Updating Database times out

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
bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Updating Database times out

Post by bsolah » Tue Jan 10, 2017 3:50 pm

When updating to the new version of PHPBB, I've uploaded all the 3.2 files to the server and go to /install and update the database, it just comes up with this:

Code: Select all

The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.
How do I increase the time out?
Image

bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Re: Updating Database times out

Post by bsolah » Wed Jan 11, 2017 2:18 pm

Bump.

Forum has been down for 3 days now. Really need this solved.
Image

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7618
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Updating Database times out

Post by JimA » Wed Jan 11, 2017 2:33 pm

Increasing the timeout limit should be done through the server, in the php.ini files.
Usually you don't have access to that yourselves, your host has. Ask them to increase the limit.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Re: Updating Database times out

Post by bsolah » Wed Jan 11, 2017 2:51 pm

JimA wrote:
Wed Jan 11, 2017 2:33 pm
Increasing the timeout limit should be done through the server, in the php.ini files.
Usually you don't have access to that yourselves, your host has. Ask them to increase the limit.
Where might I find those files? Can I access them via FTP or do I have to go into PHPmyAdmin
Image

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7618
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Updating Database times out

Post by JimA » Wed Jan 11, 2017 2:53 pm

Like I said, they are usually not accessible for you when you are on a shared hosting plan as hosting providers don't want to give everybody the ability to mess with the general server configuration. :)

If you can't easily find them, you will probably have to ask your host to increase the limit for you.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Re: Updating Database times out

Post by bsolah » Wed Jan 11, 2017 3:35 pm

Ah, they told me I had to create a phprc file and I increased the timeout that way, which helped me update the database. Just deleting the install folder now. Hopefully that works.

Do you know if my old theme proflat will still work?
Image

bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Re: Updating Database times out

Post by bsolah » Wed Jan 11, 2017 3:36 pm

It updated. Theme is broken though.
Image

User avatar
Talk19Zehn
Registered User
Posts: 343
Joined: Tue Aug 09, 2011 1:10 pm
Contact:

Re: Updating Database times out

Post by Talk19Zehn » Wed Jan 11, 2017 3:44 pm

Hello, If phpBB does not deliver the temporal minimum? The error messages in the matter have unfortunately accumulated for some time 3.2.x. Is the new patch still not compatible worldwide? In it there is a problem in this details, which so far unfortunately unclear or misunderstood for a script execution is even aligned.

BTW:
30 seconds is a minimum experience and not every user has rented his own server and not every user can control the limit at the hoster. The answer thus does not in the form at all, I still think.
This error can in my opinion not generally (!) to the users and their hosting packages be shifted. Is this execution time responsible?


Or did I not understand something? ;)

;) Regards
World Meteorological Organization (WMO) Weather - Climate - Water
BTW: My own works - phpBB - read more: ongray-design-de or look here: phpBB VT Theme

User avatar
chimp77
Registered User
Posts: 326
Joined: Sat Mar 24, 2007 8:11 pm
Location: Georgia
Contact:

Re: Updating Database times out

Post by chimp77 » Thu Jan 12, 2017 5:59 am

I am having this same issue. My database update keeps disconnecting with a timeout error. I have never had this issue with any other update.
Certified Broadcast Meteorologist - Hurricane Expert

bsolah
Registered User
Posts: 86
Joined: Sun Feb 19, 2006 12:32 am
Location: Melbourne, Australia
Contact:

Re: Updating Database times out

Post by bsolah » Thu Jan 12, 2017 8:45 am

Call your host and ask them how to increase the time out or create a phprc file. It threw me off too.
Image

User avatar
chienwen
Registered User
Posts: 2
Joined: Thu Jan 26, 2006 10:07 am
Location: Taiwan
Contact:

Re: Updating Database times out

Post by chienwen » Sun Mar 31, 2019 2:48 am

I got the same error. now I know the answer.
it is not due to timeout setting or phprc file.
please just check ./cache write permissions. for example:

Code: Select all

chmod 777 cache
(may be you can set chmod 775 for security, but Apache must have the group permissions)
and you must empty cache after run chmod.

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

Re: Updating Database times out

Post by Lumpy Burgertushie » Sun Mar 31, 2019 3:07 am

cache should be set to 777
it is not a security issue. if it was then all the millions of sites out there that have the cache folder and the other folders that need to be set to 777, would have had a problem. I have never heard of a security problem with this .


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
bipolarmorgan
Registered User
Posts: 98
Joined: Tue Jul 07, 2015 7:27 pm
Location: Cyberspace
Name: Morgan
Contact:

Re: Updating Database times out

Post by bipolarmorgan » Mon Apr 01, 2019 9:42 am

try to use the CLI
Last edited by HiFiKabin on Mon Apr 01, 2019 10:13 am, edited 1 time in total.
Reason: unneeded formatting removed

Post Reply

Return to “[3.2.x] Support Forum”