+- Like Ra's Naughty Forum (https://www.likera.com/forum/mybb)
+-- Forum: Technical section (https://www.likera.com/forum/mybb/Forum-Technical-section)
+--- Forum: Site (https://www.likera.com/forum/mybb/Forum-Site)
+--- Thread: Site performance, Server errors, outages and tunings (/Thread-Site-performance-Server-errors-outages-and-tunings)
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
RE: Site performance, Server errors, outages and tunings - Like Ra - 29 Sep 2020
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.
RE: Site performance, Server errors, outages and tunings - Like Ra - 29 Sep 2020
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...
RE: Site performance, Server errors, outages and tunings - Like Ra - 29 Sep 2020
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,1That'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...
RE: Site performance, Server errors, outages and tunings - Like Ra - 29 Sep 2020
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.
RE: Site performance, Server errors, outages and tunings - madjack - 30 Sep 2020
Hmmm....tried to upload a few .gif files and got the error message (above)
Not sure if its me or the site?
MJ
RE: Site performance, Server errors, outages and tunings - Like Ra - 30 Sep 2020
(30 Sep 2020, 15:28 )madjack Wrote: tried to upload a few .gif filesI bet they weren't gifs, but webm files with .gif extension. MyBB can upload only correctly "extended" files.
RE: Site performance, Server errors, outages and tunings - Like Ra - 01 Oct 2020
Just discovered that the registration system is broken after the upgrade. Investigating...
RE: Site performance, Server errors, outages and tunings - Like Ra - 01 Oct 2020
New SQL error: "SQL Error: 1364 - Field 'passwordconvert' doesn't have a default value".
RE: Site performance, Server errors, outages and tunings - Like Ra - 01 Oct 2020
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.
RE: Site performance, Server errors, outages and tunings - madjack - 01 Oct 2020
(01 Oct 2020, 13:48 )Like Ra Wrote: STRICT_TRANS_
Now that sounds very kinky!
MJ