Search found 7 matches

by oferlaor
Sun Aug 11, 2024 5:45 pm
Forum: [3.x] Discussion
Topic: question about invalid upload file names
Replies: 2
Views: 171

Re: question about invalid upload file names

yeah, the source of the issue is that the file name was generated by an iOS shortcut.
by oferlaor
Sat Aug 10, 2024 5:28 am
Forum: [3.x] Discussion
Topic: question about invalid upload file names
Replies: 2
Views: 171

question about invalid upload file names

I use an iOS shortcut called "Apple frames", while it's very useful (it basically wraps screenshots with the right phone background that the screenshot was taken on), it has the peculiar behavior of changing the file name to the date. The file name is valid on iOS, but no where else (it uses the ...
by oferlaor
Wed Aug 07, 2024 6:44 am
Forum: [3.x] Discussion
Topic: cache flush ultra slow query - index optimization fix
Replies: 2
Views: 328

Re: cache flush ultra slow query - index optimization fix

yes, I doubt this will have an adverse effect on other DBMSs. MySQL is pretty popular (as is MariaDB, which probably will behave the same, I haven't tested it). The additional index doesn't harm anything, it basically fixes a wrong (albeit a very logical) assumption that if you have an index that ...
by oferlaor
Fri Jul 19, 2024 5:26 pm
Forum: [4.x] Discussion
Topic: list of changes/features between 3.3 and 4?
Replies: 6
Views: 901

Re: list of changes/features between 3.3 and 4?

Nice. Will 3.3 plugins run on 4?
by oferlaor
Thu Jul 18, 2024 8:03 pm
Forum: [4.x] Discussion
Topic: list of changes/features between 3.3 and 4?
Replies: 6
Views: 901

Re: list of changes/features between 3.3 and 4?

Mostly interested in feature changes. what's the big diff between 4.0 and 3.3
by oferlaor
Sun Jul 14, 2024 4:59 pm
Forum: [4.x] Discussion
Topic: list of changes/features between 3.3 and 4?
Replies: 6
Views: 901

list of changes/features between 3.3 and 4?

Is there an official list of changes/improvements/features that phpBB4 includes beyond 3.3?

Sorry if this is duplicated somewhere, but I could not find a post about this or a feature changelog
by oferlaor
Sun Jul 14, 2024 4:41 pm
Forum: [3.x] Discussion
Topic: cache flush ultra slow query - index optimization fix
Replies: 2
Views: 328

cache flush ultra slow query - index optimization fix

I've seen increasingly slow starts on 3.3.12 as the site grows. The issue is pretty simple, immediately after a cache flush, there are two queries that run:

SELECT ug.user_id, a.forum_id, r.auth_setting, r.auth_option_id, ao.auth_option
FROM phpbb_acl_groups a, phpbb_user_group ug, phpbb_groups g ...