[3.2.5] Timeout fail during update

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
thecas
Registered User
Posts: 26
Joined: Sun Feb 04, 2018 4:25 pm

[3.2.5] Timeout fail during update

Post by thecas » Tue Mar 05, 2019 11:27 am

Hi, everyone. A classic error for me when i try to upgrade my board from 3.2.4 to 3.2.5:
The installer detected a timeout 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.

Before this:
- I've backed up the old files,
- remove the path suggested from the docs,
- upload the complete phpbb 3.2.5 package,


What version of phpBB are you using? phpBB 3.2.4 (failed update)
What is your board's URL? http://www.wisp-forum.it
What version of phpBB3 did you update from? phpBB 3.2.5


The forum has only 2k message. I don't think that this could be a server limitation.
Is there any easy way to update the database with preserving the data?
Thank you.


Edit: i've already inserted into config.php these ini set:

@ini_set('memory_limit', '256M');
@ini_set('max_input_vars','2000');

Can you confirm that config.php isn't bad? :)

User avatar
warmweer
Registered User
Posts: 2011
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: [3.2.5] Timeout fail during update

Post by warmweer » Tue Mar 05, 2019 5:02 pm

thecas wrote:
Tue Mar 05, 2019 11:27 am

- remove the path suggested from the docs,

Is there any easy way to update the database with preserving the data?

Edit: i've already inserted into config.php these ini set:

@ini_set('memory_limit', '256M');
@ini_set('max_input_vars','2000');
What do you mean with removing the path suggested from the docs?

Updating does exactly that, your files are updated (manually) and the update process updates the database: all forumdata is preserved (if it wouldn't then nobody would update ).

Why edit the config.php. Where did you find any instruction to do so?
You config.php for 3.2.4 wil not be edited by the update.

You should follow the instructions in https://www.phpbb.com/support/documents ... n=3#update and use the full package or the changed files package.
A bug is a feature that hasn't made it to the manual (yet)

thecas
Registered User
Posts: 26
Joined: Sun Feb 04, 2018 4:25 pm

Re: [3.2.5] Timeout fail during update

Post by thecas » Sun Mar 17, 2019 10:07 am

I've modify the config.php because someone wrote in this forum with the same issue to do that. some topic with the same error.
When i said: " remove the path suggested from the docs" in the past post i wanted to say that i follow the 4.2.i point of the manual:
First, you should make a copy of your existing config.php file; keep it in a safe place! Next, delete all the existing phpBB files, you should leave your files/, images/ and ext/ directories in place, otherwise you will lose your file attachments, uploaded images and get errors due to missing extension files. You can leave alternative styles in place too. With this complete, you can upload the new phpBB files (see New installation for details if necessary). Once complete, copy back your saved config.php, replacing the new one. Another method is to just replace the existing files with the files from the full package - though make sure you do not overwrite your config.php file.
The only way to set up again my board now is start the php command line on my local machine?

.m.
Registered User
Posts: 369
Joined: Wed Nov 04, 2009 8:39 pm

Re: [3.2.5] Timeout fail during update

Post by .m. » Sun Mar 17, 2019 10:25 am

looks like your database size is huge.
so as you said, it would be better to use command line based update
(provided that you have the shell access [SSH])

thecas
Registered User
Posts: 26
Joined: Sun Feb 04, 2018 4:25 pm

Re: [3.2.5] Timeout fail during update

Post by thecas » Sun Mar 17, 2019 11:06 am

I'm from my local machine.
Mysql does some errors: (i really don't manually change my db in this installation)


What is the field user_msnm?

Code: Select all

C:\Users\emanuele>C:\xampp\php\php.exe C:\xampp\htdocs\forum\bin\phpbbcli.php --
safe-mode db:migrate
Schema installato: \phpbb\db\migration\data\v30x\local_url_bbcode; tempo: 0.00 s
econdi
Installazione dati: \phpbb\db\migration\data\v30x\local_url_bbcode; tempo: 0.03
secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_12_rc2; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_12_rc2; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_12_rc3; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_12_rc3; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_12; tempo: 0.00 sec
ondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_12; tempo: 0.00 se
condi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_13_rc1; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_13_rc1; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_13; tempo: 0.00 sec
ondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_13; tempo: 0.00 se
condi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_13_pl1; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_13_pl1; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_14_rc1; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_14_rc1; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v30x\release_3_0_14; tempo: 0.00 sec
ondi
Installazione dati: \phpbb\db\migration\data\v30x\release_3_0_14; tempo: 0.00 se
condi
Schema installato: \phpbb\db\migration\data\v310\mod_rewrite; tempo: 0.00 second
i
Installazione dati: \phpbb\db\migration\data\v310\mod_rewrite; tempo: 0.00 secon
di
Schema installato: \phpbb\db\migration\data\v310\mysql_fulltext_drop; tempo: 0.2
5 secondi
Installazione dati: \phpbb\db\migration\data\v310\mysql_fulltext_drop; tempo: 0.
00 secondi
Schema installato: \phpbb\db\migration\data\v310\namespaces; tempo: 0.00 secondi

Installazione dati: \phpbb\db\migration\data\v310\namespaces; tempo: 0.00 second
i
Schema installato: \phpbb\db\migration\data\v310\notifications_cron; tempo: 0.00
 secondi
Installazione dati: \phpbb\db\migration\data\v310\notifications_cron; tempo: 0.0
0 secondi
Schema installato: \phpbb\db\migration\data\v310\notifications_schema_fix; tempo
: 0.64 secondi
Installazione dati: \phpbb\db\migration\data\v310\notifications_schema_fix; temp
o: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v310\notification_options_reconvert;
 tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v310\notification_options_reconvert
; tempo: 0.08 secondi
Schema installato: \phpbb\db\migration\data\v310\notifications_cron_p2; tempo: 0
.00 secondi
Installazione dati: \phpbb\db\migration\data\v310\notifications_cron_p2; tempo:
0.12 secondi
Schema installato: \phpbb\db\migration\data\v310\avatar_types; tempo: 0.00 secon
di
Installazione dati: \phpbb\db\migration\data\v310\avatar_types; tempo: 0.05 seco
ndi
Schema installato: \phpbb\db\migration\data\v310\passwords; tempo: 0.11 secondi
Installazione dati: \phpbb\db\migration\data\v310\passwords; tempo: 0.00 secondi

Schema installato: \phpbb\db\migration\data\v310\profilefield_types; tempo: 0.06
 secondi
Installazione dati: \phpbb\db\migration\data\v310\profilefield_types; tempo: 0.0
3 secondi
Schema installato: \phpbb\db\migration\data\v310\passwords_p2; tempo: 0.02 secon
di
Installazione dati: \phpbb\db\migration\data\v310\passwords_p2; tempo: 0.00 seco
ndi
Schema installato: \phpbb\db\migration\data\v310\profilefield_wlm; tempo: 0.31 s
econdi
PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Unknown column 'user_msnm' in
'field list' [1054]<br /><br />Si è verificato un errore SQL richiamando questa
 pagina. Contatta un <a href="mailto:info@wisp-forum.it">amministratore</a> se i
l problema persiste. in C:\xampp\htdocs\forum\phpbb\db\driver\driver.php on line
 997

Fatal error: SQL ERROR [ mysqli ]<br /><br />Unknown column 'user_msnm' in 'fiel
d list' [1054]<br /><br />Si è verificato un errore SQL richiamando questa pagi
na. Contatta un <a href="mailto:info@*******">amministratore</a> se il pro
blema persiste. in C:\xampp\htdocs\forum\phpbb\db\driver\driver.php on line 997

C:\Users\emanuele>C:\xampp\php\php.exe C:\xampp\htdocs\forum\bin\phpbbcli.php --
safe-mode db:migrate
PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Unknown column 'user_msnm' in
'field list' [1054]<br /><br />Si è verificato un errore SQL richiamando questa
 pagina. Contatta un <a href="mailto:info@wisp-forum.it">amministratore</a> se i
l problema persiste. in C:\xampp\htdocs\forum\phpbb\db\driver\driver.php on line
 997

Fatal error: SQL ERROR [ mysqli ]<br /><br />Unknown column 'user_msnm' in 'fiel
d list' [1054]<br /><br />Si è verificato un errore SQL richiamando questa pagi
na. Contatta un <a href="mailto:info@****">amministratore</a> se il pro
blema persiste. in C:\xampp\htdocs\forum\phpbb\db\driver\driver.php on line 997

C:\Users\emanuele>
I've added the field user_msnm into the users table.
Now the cli says this error:
[ERROR] Esiste già un modulo: ACP_CONTACT_SETTINGS
(already exists the module: ACP_CONTACT_SETTINGS

User avatar
Mick
Support Team Member
Support Team Member
Posts: 20718
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: [3.2.5] Timeout fail during update

Post by Mick » Sun Mar 17, 2019 12:34 pm

Also, it appears you're using SSL. That being the case you need to pay attention to use https when typing your url, or put a redirect in .htaccess.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.

thecas
Registered User
Posts: 26
Joined: Sun Feb 04, 2018 4:25 pm

Re: [3.2.5] Timeout fail during update

Post by thecas » Sun Mar 17, 2019 12:54 pm

After some other nerding i'm coming to this stage:

Code: Select all

C:\Users\emanuele>C:\xampp\php\php.exe C:\xampp\htdocs\forum\bin\phpbbcli.php -
safe-mode db:migrate
Installazione dati: \phpbb\db\migration\data\v310\contact_admin_acp_module; tem
o: 0.20 secondi
Schema installato: \phpbb\db\migration\data\v310\passwords_convert_p1; tempo: 0
00 secondi
Installazione dati: \phpbb\db\migration\data\v310\passwords_convert_p1; tempo:
.00 secondi
Schema installato: \phpbb\db\migration\data\v310\captcha_plugins; tempo: 0.00 s
condi
Installazione dati: \phpbb\db\migration\data\v310\captcha_plugins; tempo: 0.03
econdi
Schema installato: \phpbb\db\migration\data\v310\rename_too_long_indexes; tempo
 0.02 secondi
Installazione dati: \phpbb\db\migration\data\v310\rename_too_long_indexes; temp
: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v310\search_type; tempo: 0.00 secon
i
Installazione dati: \phpbb\db\migration\data\v310\search_type; tempo: 0.00 seco
di
Schema installato: \phpbb\db\migration\data\v310\topic_sort_username; tempo: 0.
6 secondi
Installazione dati: \phpbb\db\migration\data\v310\topic_sort_username; tempo: 0
00 secondi
Schema installato: \phpbb\db\migration\data\v310\notifications_use_full_name; t
mpo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v310\notifications_use_full_name;
empo: 0.12 secondi
Schema installato: \phpbb\db\migration\data\v310\profilefield_field_validation_
ength; tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v310\profilefield_field_validation
length; tempo: 0.02 secondi
Schema installato: \phpbb\db\migration\data\v310\bot_update; tempo: 0.00 second

Installazione dati: \phpbb\db\migration\data\v310\bot_update; tempo: 0.03 secon
i
Schema installato: \phpbb\db\migration\data\v31x\style_update; tempo: 0.00 seco
di
Installazione dati: \phpbb\db\migration\data\v31x\style_update; tempo: 0.05 sec
ndi
Schema installato: \phpbb\db\migration\data\v31x\m_softdelete_global; tempo: 0.
0 secondi
Installazione dati: \phpbb\db\migration\data\v31x\m_softdelete_global; tempo: 0
02 secondi
Schema installato: \phpbb\db\migration\data\v31x\plupload_last_gc_dynamic; temp
: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\plupload_last_gc_dynamic; tem
o: 0.06 secondi
Schema installato: \phpbb\db\migration\data\v31x\profilefield_remove_underscore
from_alpha; tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\profilefield_remove_underscor
_from_alpha; tempo: 0.02 secondi
Schema installato: \phpbb\db\migration\data\v31x\profilefield_yahoo_update_url;
tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\profilefield_yahoo_update_url
 tempo: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\update_custom_bbcodes_with_idn
 tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\update_custom_bbcodes_with_id
; tempo: 0.03 secondi
Schema installato: \phpbb\db\migration\data\v31x\m_pm_report; tempo: 0.00 secon
i
Installazione dati: \phpbb\db\migration\data\v31x\m_pm_report; tempo: 0.00 seco
di
Schema installato: \phpbb\db\migration\data\v31x\increase_size_of_dateformat; t
mpo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\increase_size_of_dateformat;
empo: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_
ptions; tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config
options; tempo: 0.06 secondi
Schema installato: \phpbb\db\migration\data\v31x\add_latest_topics_index; tempo
 0.09 secondi
Installazione dati: \phpbb\db\migration\data\v31x\add_latest_topics_index; temp
: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\add_log_time_index; tempo: 0.0
 secondi
Installazione dati: \phpbb\db\migration\data\v31x\add_log_time_index; tempo: 0.
0 secondi
Schema installato: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_op
ions; tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_o
tions; tempo: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\increase_size_of_emotion; temp
: 0.02 secondi
Installazione dati: \phpbb\db\migration\data\v31x\increase_size_of_emotion; tem
o: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\remove_duplicate_migrations; t
mpo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v31x\remove_duplicate_migrations;
empo: 0.00 secondi
Schema installato: \phpbb\db\migration\data\v31x\update_hashes; tempo: 0.00 sec
ndi
Installazione dati: \phpbb\db\migration\data\v31x\update_hashes; tempo: 0.03 se
ondi
Schema installato: \phpbb\db\migration\data\v320\allowed_schemes_links; tempo:
.00 secondi
Installazione dati: \phpbb\db\migration\data\v320\allowed_schemes_links; tempo:
0.00 secondi
Schema installato: \phpbb\db\migration\data\v320\text_reparser; tempo: 0.00 sec
ndi
Installazione dati: \phpbb\db\migration\data\v320\text_reparser; tempo: 1.31 se
ondi
Schema installato: \phpbb\db\migration\data\v320\remove_profilefield_wlm; tempo
 0.19 secondi
Installazione dati: \phpbb\db\migration\data\v320\remove_profilefield_wlm; temp
: 0.09 secondi
Schema installato: \phpbb\db\migration\data\v320\font_awesome_update; tempo: 0.
0 secondi
Installazione dati: \phpbb\db\migration\data\v320\font_awesome_update; tempo: 0
00 secondi
Schema installato: \phpbb\db\migration\data\v320\icons_alt; tempo: 0.00 secondi
Installazione dati: \phpbb\db\migration\data\v320\icons_alt; tempo: 0.00 second

Schema installato: \phpbb\db\migration\data\v320\log_post_id; tempo: 0.00 secon
i
Installazione dati: \phpbb\db\migration\data\v320\log_post_id; tempo: 0.00 seco
di
Schema installato: \phpbb\db\migration\data\v320\remove_outdated_media; tempo:
.00 secondi
Installazione dati: \phpbb\db\migration\data\v320\remove_outdated_media; tempo:
0.05 secondi
Schema installato: \phpbb\db\migration\data\v320\notifications_board; tempo: 0.
0 secondi
Installazione dati: \phpbb\db\migration\data\v320\notifications_board; tempo: 0
25 secondi
PHP Fatal error:  SQL ERROR [ mysqli ]<br /><br />Incorrect table definition; t
ere can be only one auto column and it must be defined as a key [1075]<br /><br
/>Si è verificato un errore SQL richiamando questa pagina. Contatta un <a href
"mailto:info@wisp-forum.it">amministratore</a> se il problema persiste. in C:\x
mpp\htdocs\forum\phpbb\db\driver\driver.php on line 997

Fatal error: SQL ERROR [ mysqli ]<br /><br />Incorrect table definition; there
an be only one auto column and it must be defined as a key [1075]<br /><br />Si
è verificato un errore SQL richiamando questa pagina. Contatta un <a href="mai
to:info@wisp-forum.it">amministratore</a> se il problema persiste. in C:\xampp\
tdocs\forum\phpbb\db\driver\driver.php on line 997
It seems that for some unknown reason my db has lost some integrity rules and default values (i.e. auto increment not null rules).
Is there some diagnostical script to fix the db? With this logs i can't.

P.S. I'm not using ssl. I'm only use it in the online version, offline i only try to update the board.

.m.
Registered User
Posts: 369
Joined: Wed Nov 04, 2009 8:39 pm

Re: [3.2.5] Timeout fail during update

Post by .m. » Sun Mar 17, 2019 2:30 pm

how did you take backup of the database & imported to localhost ?

if possible, try using shell / command line for both the tasks !

thecas
Registered User
Posts: 26
Joined: Sun Feb 04, 2018 4:25 pm

Re: [3.2.5] Timeout fail during update

Post by thecas » Sun Mar 17, 2019 4:40 pm

Via phpMyadmin.
In any case i can't diagnose the reason of this error.
If the db is damaged why the board works well now online? All the feature i'm usually use works well.

.m.
Registered User
Posts: 369
Joined: Wed Nov 04, 2009 8:39 pm

Re: [3.2.5] Timeout fail during update

Post by .m. » Sun Mar 17, 2019 5:03 pm

you said
... for some unknown reason my db has lost some integrity rules and default values
(i.e. auto increment not null rules)
such things happen (esp. for large databases) while taking DB backup through browser &
while importing & exporting via phpMyAdmin , also due to usage of different DB systems !

unable to find a DB integrity checker for phpBB 3.2.x ... :(

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Big Mac, bonelifer and 22 guests