Can't create admin user

[Serverology]

Can't create admin user:
SQLSTATE[HY000]: General error: 1364 Field 'user_name' doesn't have a default value

pls help

 

[Serverology]

 

[Serverology]

and if I go to /install.php again, it says: "Request denied"

 

[Rodolfo]

There is a field in the chv_users table which affects MySQL servers running in strict mode.

Run this query in your MySQL

ALTER TABLE `chv_users` MODIFY `user_name` varchar(255) DEFAULT NULL

This will be added in 3.1

 

[Serverology]

Thank you Rodolfo

Your SQL query has been executed successfully (Query took 0.7537 sec)

/install.php still says: "Request denied"

and when I visit the main site, it's already up, but with no admin account
how should I carry on?

Thanks

 

[Rodolfo]

Ahh... gosh sorry, my bad. Create any normal account using the conventional signup method then in your db edit chv_users table and set is_admin 1 to your user. You can also skip this instructions and try a clean install/update with the upcoming version 3.1 which should arrive tomorrow.

Cheers.

 

[Serverology]

Ahh... gosh sorry, my bad. Create any normal account using the conventional signup method then in your db edit chv_users table and set is_admin 1 to your user. You can also skip this instructions and try a clean install/update with the upcoming version 3.1 which should arrive tomorrow.

Cheers.

Great! Thanks Rodolfo!

 

[Rodolfo]

Patch added to 3.1

 

[Serverology]

This issue was solved with 3.1 update, works flawlessly now!

 

[Rodolfo]

This issue was solved with 3.1 update, works flawlessly now!

Cool, glad to help.