• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

I can not register a admin

Status
Not open for further replies.
S

soulman

Chevereto Member
HTML: 
Fatal error [400]: SQLSTATE[HY000]: General error: 1364 Field 'user_name' doesn't have a default value
Triggered in /app/lib/classes/class.user.php at line 142

Stack trace:
#0 /app/routes/route.signup.php(139): CHV\User::insert(Array)
#1 /lib/G/classes/class.handler.php(204): G\Handler->{closure}(G\Handler)
#2 /lib/G/classes/class.handler.php(100): G\Handler->processRequest()
#3 /app/loader.php(180): G\Handler->__construct(Array)
#4 /index.php(21): include_once('/app/loader.php')

Time installing the script, I could not register the administrator.
And I can not go through the normal registration on the site. What's the problem?

What need to add folders and libraries?
 
Delete the old /admin folder and go to /dashboard in your site.
 
5b1f4e47d60b71f8f95e9a911a1e555d.jpg
 
There is a field in the chv_users table which affects MySQL servers running in strict mode.

Run this query in your MySQL
Code: 
ALTER TABLE `chv_users` MODIFY `user_name` varchar(255) DEFAULT NULL

This will be added in 3.1
 
Code: 
Fatal error [400]: SQLSTATE[HY000]: General error: 1364 Field 'login_secret' doesn't have a default value
Triggered in /app/lib/classes/class.login.php at line 91

Stack trace:
#0 /app/routes/route.account.php(319): CHV\Login::login('1', 'session')
#1 /lib/G/classes/class.handler.php(204): G\Handler->{closure}(G\Handler)
#2 /lib/G/classes/class.handler.php(100): G\Handler->processRequest()
#3 /app/loader.php(180): G\Handler->__construct(Array)
#4 /index.php(21): include_once('/app/loader.php')

And when you try to activate the e-mail
 
Try to switch your MySQL to non strict mode or wait for the 3.1 release.
 
Last edited:
Yes the issue is that I didn't tested the system using MySQL strict mode which is a still not standard method (in the way that is considered a MUST) but it seems that they are pushing it or at least trying. Not even in my very last servers that mode comes turned on by default so I had to force that mode to start testing it.
 
Status
Not open for further replies.
Back
Top