albertlast

Results 22 issues of albertlast

Based on the discussion #6405 i checked the existing mb4 logic of smf and found a spot which got not covered atm. In general when someone plan to convert his...

MySQL
Database
Charset/Encoding

#### Description When you go to the memberlist and use the jump list in the right top, for exp. start with n https://www.simplemachines.org/community/index.php?action=mlist;sa=all;start=n#lettern where you can jump to a start...

Performance

Fix partial: #7253 (only pg)

Search
Performance
PR: unreviewed

move the base table to the left side of the on statement like mention here: #6199

Database
PR: reviewed-approved

Since we believe that the member_name and email_address is unique we should check this. got the idea by reading the issue: https://github.com/SimpleMachines/SMF2.1/issues/6207 The result is shown in the welcome screen:...

Upgrader

Well the pr got more complex/intresting as expected... The root cause is that mysql know two escaping symbole, on the one side it know the sql default one ``''`` (double...

Database

With pg 12 release you can use collation which are case insensitive also in mysql you can use collation which are case sensitive, to give the admin a chance to...

PostgreSQL
MySQL

two possible issues get fixed, first that default script can't find the sequence found by @sbulen see https://github.com/SimpleMachines/SMF2.1/pull/6319#issuecomment-719897874 second issue is, that a sequence survive a table drop. When now...

PostgreSQL
Database

this pr got a depency to #6208 but not vice versa. Would fixes #6207

Upgrader

Add support for the webp image format, since imagetype stuff on php side is used, the needed php version is 5.6.26 or 7.0.10 (we are on 5.4.0). https://www.php.net/manual/en/image.constants.php Could handle...

Attachments