Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

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
Jorup16
Registered User
Posts: 384
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

Post by Jorup16 » Sat Oct 14, 2017 5:09 pm

Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

My forum has version 3.2.0 and I want to update to 3.2.1 I have searched for information and read several topics because I do not like to open themes just because yes, but the truth is that I can not find the solution.

I followed this guide, https://www.phpbb.com/support/docs/en/3 ... ating-32x/ but I have a small problem when updating the forum, it shows me the following error :

Image

Code: Select all

General Error:SQL ERROR [ mysqli ]
Duplicate key name 'itm_usr_mthd' [1061]

SQL
ALTER TABLE phpbb_user_notifications ADD INDEX itm_usr_mthd (item_type, item_id, user_id, method) 
in file /home/ctuchez/public_html/files_xg/phpbb/db/driver/driver.php on line 999

BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: installer_msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1064
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1551
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 671
CALL: phpbb\db\tools\tools->sql_create_index()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/install/module/update_database/task/update.php
LINE: 160
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/install/module_base.php
LINE: 149
CALL: phpbb\install\module\update_database\task\update->run()

FILE: [ROOT]/phpbb/install/installer.php
LINE: 219
CALL: phpbb\install\module_base->run()

FILE: [ROOT]/phpbb/install/controller/update.php
LINE: 133
CALL: phpbb\install\installer->run()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()

FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.php
LINE: 113
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/http-foundation/Response.php
LINE: 380
CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()

FILE: [ROOT]/install/app.php
LINE: 62
CALL: Symfony\Component\HttpFoundation\Response->send()
And below, this:

Code: Select all

Instalando esquema: \phpbb\db\migration\data\v32x\user_notifications_table_temp_index.
Omitir la tarea “installer.update_filesystem.download_updated_files”
Omitir la tarea “installer.update_filesystem.update_files”
Omitir la tarea “installer.update_filesystem.show_file_status”
Omitir la tarea “installer.update_filesystem.diff_files”
Omitir la tarea “installer.update_filesystem.check_task”
Omitir la tarea “installer.obtain_data.update_ftp_settings”
Omitir la tarea “installer.obtain_data.update_files”
Omitir la tarea “installer.obtain_data.file_updater_method”
The update was stuck in 71% and then did not happen and that left it like 30 minutes, but never worked. I have deactivated all the extensions with which I count and yet it does not work.

I have to apologize if my question has already been answered before, but believe me I have not found the ideal subject to solve my doubt

Thanks!

User avatar
Jorup16
Registered User
Posts: 384
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

Post by Jorup16 » Sat Oct 21, 2017 5:15 am

any idea how to solve this problem?

:(

janus_zonstraal
Registered User
Posts: 1735
Joined: Sat Aug 30, 2014 1:30 pm

Re: Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

Post by janus_zonstraal » Sat Oct 21, 2017 8:08 am

Restore your board from the backups.

Than make a copy of your board and database in a "test" directory and try it again.
Sorry! My English is bat ;) !!!

User avatar
Jorup16
Registered User
Posts: 384
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

Post by Jorup16 » Sun Oct 22, 2017 4:16 pm

I already did that, but I still get the same error.

User avatar
Theriddler1
Registered User
Posts: 438
Joined: Sat Aug 27, 2011 11:00 pm
Location: NL
Contact:

Re: Problem updating phpBB 3.2.0 to 3.2.1 | SQL error

Post by Theriddler1 » Mon Oct 23, 2017 9:52 am

drop your index key 'itm_usr_mthd' from table 'phpbb_user_notifications'

see here for more information where to find indexes: https://stackoverflow.com/a/29205358
Theriddler - Moderator @ phpBB.nl | phpBBservice.nl Team-member
ImageSupport Tools | Image My Extensions | buy me a beer Image

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Binano, Froddelaar, MarkDHamill, RamonSBorussia and 21 guests