MyBB Community Forums
Install MySQL Error - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Install MySQL Error (/thread-234093.html)



Install MySQL Error - TexasGreg - 2021-10-24

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]


RE: Install MySQL Error - Devilshakerz - 2021-10-24

Can you provide the version of MySQL on the server?

See if it helps to change this line in the inc/class_datacache.php file: https://github.com/mybb/mybb/blob/mybb_1827/inc/class_datacache.php#L675
to:
$group_by = 'u.uid, u.username';



RE: Install MySQL Error - [ExiTuS] - 2021-10-25

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]


RE: Install MySQL Error - Crazycat - 2021-10-25

(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