Site performance, Server errors, outages and tunings

1557 Replies, 448953 Views

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.
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...
(This post was last modified: 29 Sep 2020, 21:50 by 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...
(This post was last modified: 29 Sep 2020, 23:05 by 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.
 Capture.JPG   

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

Not sure if its me or the site?

MJ
(30 Sep 2020, 15:28 )madjack Wrote: 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.
Just discovered that the registration system is broken after the upgrade. Investigating...
New SQL error: "SQL Error: 1364 - Field 'passwordconvert' doesn't have a default value".
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.
(This post was last modified: 01 Oct 2020, 13:56 by Like Ra.)
(01 Oct 2020, 13:48 )Like Ra Wrote: STRICT_TRANS_

Now that sounds very kinky!

MJ

Possibly Related Threads…
Thread Author Replies Views Last Post
  An interesting read for site admins Max515 4 414 10 Jun 2025, 17:04
Last Post: Zooy
  Site reviews Like Ra 6 482 12 Feb 2025, 00:49
Last Post: Like Ra
  Site access blocked from some public places Like Ra 11 5,629 07 Apr 2024, 01:18
Last Post: Like Ra
  Site rendering on Apple devices Like Ra 85 15,012 13 Aug 2023, 17:25
Last Post: Like Ra
  How to improve the site navigation Like Ra 10 7,598 03 Aug 2023, 23:27
Last Post: Like Ra