Error during database update going from v3.3.13 to 3.3.14

[Bob Jacobs]

Thanks both. I deleted them prior to the initial Full Package update, but not for the Changed Files attempt. I'll go back and try again with a clean slate. Thanks again.

No, this is not true, I just checked the instructions I followed and it said to leave the store folder in place, so I don't believe I deleted them at any point. But I'll give this a go and see where that leaves me. Thanks.

[invenio]

https://www.phpbb.com/support/docs/en/3 ... ide/minor/

Regardless of which update method you use, the instructions tell you to remove those files.

[P_I]

It is mentioned in Minor Updates Within 3.3.x. Unfortunately it doesn't get mentioned in the various subsections, i.e. Full Package.

Added: Created https://tracker.phpbb.com/browse/PHPBB-17440 to cover this missing information

[invenio]

It is mentioned in Minor Updates Within 3.3.x. Unfortunately it doesn't get mentioned in the various subsections, i.e. Full Package.

Beat you!

Is there a way to petition to have it changed so that it is listed on each individual update instruction page? I've seen this dupe so many people and it's simply because it's mentioned on a top level update instruction page instead of the specific individual ones. Seems like a simple edit of the documentation could substantially help a lot of people.

[P_I]

Is there a way to petition to have it changed so that it is listed on each individual update instruction page?

Yup. I edited my previous post to include the newly created tracker entry for the issue.

[Bob Jacobs]

Thanks everyone. I deleted those files and have gone through the Full Package update. I'm now back to the original error message:

Screenshot 2024-11-24 153818.png

Since my original post and prior to this attempt I removed the phpbb_interests field from the ACP and the database.

Any advice? Thanks again.

[invenio]

Any chance that user_interests somehow got added back into the database?

Also, have you tried deactivate all extensions to try to do this as "cleanly" as possible?

[Bob Jacobs]

Any chance that user_interests somehow got added back into the database?

Also, have you tried deactivate all extensions to try to do this as "cleanly" as possible?

Thanks. I've checked the database and it's not there, but it's a good call.

The only extension listed in the ACP is VigLink, which is disabled.

[warmweer]

Just checked:
There is a default phpbb_interests field in the profilefields table and a default pf_phpbb_interests in the profile_fields_data table in phpbb 3.3.13 and in 3.3.14

[rxu]

The question is why \phpbb\db\migration\data\v310\profilefield_interests migration is attempting to install at all, because for phpBB 3.3.13 it should have been [effectively] installed already and just skipped during the update to 3.3.14. Probably phpbb_migrations DB table is incomplete/broken in some way (f.e. restored from too old backup) or something.

[Bob Jacobs]

Thanks all.

I rolled back to the v3.3.13 files and database, ensured that the two files in the /store directory discussed upthread were deleted, and tried once more to apply the Changed Files update package. This again gave me the local_url_bbcode error that I posted earlier.

Any suggestions would be welcome. Grateful thanks.

[invenio]

Any particular reason you are using the "changed files" method vs full package?

[Bob Jacobs]

Any particular reason you are using the "changed files" method vs full package?

I've used that for some time and never had a problem. For this update I chose to use the full package as I thought that might be a better thing to do.

After the discussion earlier, and having learned about the two files in the /store folder, I wondered if I would get a better result by going back to the Changed Files package with those files deleted, having found that the Full Package with them deleted still gave me an error.

So I now appear to have two repeatable issues, one with the Full Package update which gives the 'user_interests' error and one with the Changed Files package which gives the local_url_bbcode error.

I did see "user_interests" in one of the update files earlier (profilefield_interests.php), which probably explains where it's coming from, rather than from the database.

Thanks.

[invenio]

Weird as the base files should be the same with either update method. Any chance you had made some kind of mod to one of the files previously and since you used the Changed Files method it was carried on? Or perhaps a changed file did not overwrite a previous version?

I don't really know, I'm just trying to think what would cause a difference between Changed Files vs Full Package updates... as it really shouldn't be any. I think officially the recommended update method is the Full Package.

[Bob Jacobs]

You're right about the Full Package being the recommended update path, which I didn't appreciate until I used it this time around.

The site has been running since 2012 and I haven't made any mods in that time. (It originally ran from 2006 to 2010/11 and I made mods back then, but opted not to for simplicity when it opened up the second time.)

It does seem odd, but I've had no problems at all with updates in the past. This came as a surprise