You mention using the download package from phpBB but you also mention you did the update via ACP.bbforum20 wrote: ↑Tue Jun 15, 2021 6:21 pm Support Request Template
...
How did you install your board? I used the download package from phpBB.com
...
What version of phpBB3 did you update from? phpBB 3.2.0
So I decided to update to 3.3, did update via ACP and then told me I needed to finish updated database.
Updated database via CLI (other way did not work).
Then you did not follow the instructions in the link Warmweer provided. Step 7 of those instructions says:
OK, if you followed those instructions exactly, then perhaps the first instance of updating broke something.bbforum20 wrote: ↑Wed Jun 16, 2021 7:07 pm How did I use the auto update?
I downloaded the file you just linked to https://www.phpbb.com/downloads/#install , transferred via FTP (steps 9 & 10).
Then used the url /yourforum/install to update the database (step 12).
I did not use autoupdate, I followed the instructions on https://www.phpbb.com/support/docs/en/3 ... upgrade32/
Then with the DB error I got in ACP (after completing all of the above), I used CLI to update the DB again and now I get the error in the title of this post.
What should I do next?
Sorry, I misread one of your prior posts.
Code: Select all
CREATE TABLE `phpbb_notification_types` (
`notification_type_id` smallint(4) UNSIGNED NOT NULL,
`notification_type_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`notification_type_enabled` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
ALTER TABLE `phpbb_notification_types`
ADD PRIMARY KEY (`notification_type_id`),
ADD UNIQUE KEY `type` (`notification_type_name`);
ALTER TABLE `phpbb_notification_types`
MODIFY `notification_type_id` smallint(4) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
phpbb_
.