Cannot create user groups ver 9.4.6, mySQL ver 8.4

Installation
1

Unable to install database: An exception occurred while executing 'CREATE TABLE Groups (gID INT UNSIGNED AUTO_INCREMENT NOT NULL …

I thought this was resolved a long time ago… I’m a designer not a coder and I’m totally lost.

2

What’s the exact version? I think 8.4.3 includes the right fixes for the Groups issue.

3

9.4.6 ver…my SQL 8.4. This is a new install. I’ve tried with full Atomic and blank Atomic. It looks to me like the entire database installs except for groups table.

5

thanks. sometimes I can be so dense.

Database server

  • Server: 10.123.0.165 via TCP/IP

  • Server type: MySQL

  • Server connection: SSL is not being used

  • Server version: 8.4.5 - Source distribution

  • Protocol version: 10

  • Server charset: UTF-8 Unicode (utf8mb3)

7

I don’t think swittching to MariaDB would help.

Anyway, it’s a very strange error: we used to have it on old ConcreteCMS/concrete5 versions, but this issue should have been fixed in Concrete version 8.4.3…

Maybe that error occurs because of some custom code?

8

I dont know what custom code it would be. I just installed Concrete on the server. Created a database and pointed my browser to start the install.

Im familiar its a problem with older versions when My Sql changed to 8. Could it be because its a subdomain?

9

I don’t think that installing in a subdomain can be the cause of your issue.

I’d double check the actual Concrete version you are installing…
When you configure the setup of Concrete, you should see the version in the upper right corner of the window: is it really 9.4.6?

1000044223
10000442231536×908 79.9 KB

10

ssGWinstall
ssGWinstall600×283 37.4 KB

ssGWinstallVer

11

Is there a possibility of problems using Concrete 9.4.6 (very new) and SQL 8.4 (very new) and PHP 7.3 (very old)? Perhaps downgrade to SQL 8.0-ish? (a Claude AI suggestion)