Update 3.3.0>3.3.1 | SQL error INDEX itm_usr_mthd

[ssl]

Hello
I am having a problem with an update to 3.3.1, here is the error message:

General Error:SQL ERROR [ mysqli ]Duplicate key name 'itm_usr_mthd' [1061]SQLALTER TABLE caf20_user_notifications ADD INDEX itm_usr_mthd (item_type, item_id, user_id, method) in file /home/phpbhhvj/public_html/forum/phpbb/db/driver/driver.php on line 1023

[Lumpy Burgertushie]

exactly how did you do the update?
what method did you use?


robert

[ssl]

Hi

Like this :

• Download the full package of the latest version

• Unzip the archive on the desktop and open the folder phpBB3.

• Delete the file from the archive config.php directory as well as the /images- /store- /files and /ext.

• From the forum, go to the administration panel then in " Général --> Configuration du forum". Make sure that Prosilver is set as the default style .

• Using an FTP client, delete the directories /vendor and /cache the root of your forum.

• Transfer the files and directories from the previously unzipped archive (i.e. the CONTENTS of the / phpBB3 directory) to the forum root on the server via an FTP client, making sure to overwrite any existing files

• If there are files install_config.php, * .lock ou migration * in the folder /store, delete them.

Now start the update wizard by pointing the browser to the " install" directory .
Choose the update tab and follow the instructions.

[david63]

Did you disable all of your extensions?

[ssl]

Not at all
I updated a forum hosted by OVH without deactivating extensions, no problem.
And then another hosted at Planet Hoster, there error message.

With the forum hosted at Planet Hoster I tried by disabling the extensions, same error message.

[saltymichael]

im having an issue where it has renamed my main forum page to sample.com/phpBB3/index.html instead of just being the sample.com and now it gives me errors when login and logout and moving a round some...

[Siguza]

im having an issue where it has renamed my main forum page to sample.com/phpBB3/index.html instead of just being the sample.com and now it gives me errors when login and logout and moving a round some...

please start a new topic about this

[ssl]

Hi
The error speaks of notification, on the forum I had installed an extension for Lavigor web push notifications. This extension has never worked, probably the problem is.
I will try the update again to verify.


EDIT

Same problem

[ssl]

Hi
Problem solved, I thank steph from the French support forum for the solution.
This problem has already been mentioned here