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...
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...
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.
[
attachment=44039]
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.
(01 Oct 2020, 13:48 )Like Ra Wrote: [ -> ]STRICT_TRANS_
Now that sounds very kinky!
MJ