Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
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.
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
29 Sep 2020, 21:50
(This post was last modified: 29 Sep 2020, 21:50 by 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...
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
29 Sep 2020, 23:02
(This post was last modified: 29 Sep 2020, 23:05 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...
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
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.
Posts: 4,337
Thanks received: 5914
Thanks given: 3256
Joined: Dec 2006
Hmmm....tried to upload a few .gif files and got the error message (above)
Not sure if its me or the site?
MJ
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
(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.
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
Just discovered that the registration system is broken after the upgrade. Investigating...
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
New SQL error: "SQL Error: 1364 - Field 'passwordconvert' doesn't have a default value".
Posts: 25,875
Thanks received: 12865
Thanks given: 6913
Joined: Jul 2006
01 Oct 2020, 13:48
(This post was last modified: 01 Oct 2020, 13:56 by 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.
Posts: 4,337
Thanks received: 5914
Thanks given: 3256
Joined: Dec 2006
(01 Oct 2020, 13:48 )Like Ra Wrote: STRICT_TRANS_
Now that sounds very kinky!
MJ
|