2021-10-24, 12:08 PM
I get almost installed when I get SQL Error: 1055 - 'mybb.u.uid' isn't in GROUP BY
What should I try?
![[Image: 8.png]](https://camo.mybb.com/f7afe001a2089edc07545cfe62c50fb0a40c12be/68747470733a2f2f7777772e706572666563746e616d652e636f6d2f382e706e67)
What should I try?
2021-10-24, 02:21 PM
Can you provide the version of MySQL on the server?
See if it helps to change this line in the
to:
See if it helps to change this line in the
inc/class_datacache.php file: https://github.com/mybb/mybb/blob/mybb_1...e.php#L675to:
$group_by = 'u.uid, u.username';
2021-10-25, 11:40 AM
BTW. during installation, did you choose the table prefix "mybb."?
It's not recommended to use dots in database objects - so better choose an underscore instead: "mybb_".
[ETS]
It's not recommended to use dots in database objects - so better choose an underscore instead: "mybb_".
[ETS]
2021-10-25, 11:57 AM
(2021-10-25, 11:40 AM)[ExiTuS] Wrote: [ -> ]BTW. during installation, did you choose the table prefix "mybb."?
It's not recommended to use dots in database objects - so better choose an underscore instead: "mybb_".
[ETS]
I think no prefix has been choosed. mybb.u.user means database mybb, table (or alias) u, field user. The query is done on users, I think that if the prefix was mybb., the query showed will be on mybb.users