Not Solved Install MySQL Error
#1
Not Solved
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]
Reply
#2
Not Solved
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_1...e.php#L675
to:
$group_by = 'u.uid, u.username';
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#3
Not Solved
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]
New Forum / MyBB 1.8.26 + innovative full-responsive Theme
Live-Escape-Game-Forum
Reply
#4
Not Solved
(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
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)