Site performance, Server errors, outages and tunings

[Like Ra]

The operating system has just been upgraded from 18.04 LTS to 20.04.1 LTS. Quite a jump, not everything went smoothly. This is the first time when I refrained from usual Ubuntu upgrades in April and October every year and stuck to LTS (Long Time Support). Not sure it was the right decision - a lot has changed since then, OTOH, not all packages are up to date with Ubuntu releases.

As always, please let me know if everything is working fine here.

[Like Ra]

Found one 😟 Forum stats does not work because of ThankYou plugin SQL query:

Code:

SQL Error: 1055 - Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'u.usergroup' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT l.pid, count( * ) AS likes, p.subject, p.username, p.uid, p.fid, p.tid, u.usergroup, u.displaygroup
                                                                        FROM mybb_g33k_thankyoulike_thankyoulike l
                                                                        LEFT JOIN mybb_users u ON (l.puid=u.uid)
                                                                        LEFT JOIN mybb_posts p ON (l.pid=p.pid)
                                                                        WHERE visible='1'  
                                                                        GROUP BY l.pid
                                                                        ORDER BY likes DESC, l.pid ASC
                                                                        LIMIT 0,20
        <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:597]

Hm... Investigating...

[Like Ra]

A similar one for the games section:

Code:

SQL Error: 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 's.dateline' which is not in SELECT list; this is incompatible with DISTINCT
Query: SELECT DISTINCT s.gid, s.uid, s.username, s.score, g.title
        FROM mybb_games_scores s
        LEFT JOIN mybb_games g ON (s.gid=g.gid)
        WHERE g.active='1'
        ORDER BY s.dateline DESC
        LIMIT 0,1

That's the difference between MySQL 5.7 and 8. Apparently lots of plugins have to be tweaked. More work... 😟 Or change the sql_mode to silence some of them...

[Like Ra]

OK, the errors are "removed" by removing ONLY_FULL_GROUP_BY from sql_mode. So, everything is working now, but the plugins must be fixed anyway.

[madjack]

   

Hmmm....tried to upload a few .gif files and got the error message (above)

Not sure if its me or the site?

MJ

[Like Ra]

tried to upload a few .gif files

I bet they weren't gifs, but webm files with .gif extension. MyBB can upload only correctly "extended" files.

[Like Ra]

Just discovered that the registration system is broken after the upgrade. Investigating...

[Like Ra]

New SQL error: "SQL Error: 1364 - Field 'passwordconvert' doesn't have a default value".

[Like Ra]

Arrgh... The default STRICT_TRANS_TABLES should be removed from sql_mode...

Fixed!

Also removed two unused columns passwordconvert and passwordconverttype from mybb_users table.

[madjack]

STRICT_TRANS_

Now that sounds very kinky!

MJ