Forum

Ask, reply and learn. Join the community of Akaunting.

Back

All Discussions

Dedicated Support Collaboration Hub

SQLSTATE[23000]: Integrity constraint violation: 1048

Tributario News ( User )

Commented 5 years ago

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'locale' cannot be null (SQL: insert into `zo0_users` (`name`, `email`, `password`, `locale`, `updated_at`, `created_at`) values (, [email protected], $2y$10$2zU3aWzsiG6xpxybS09wP.VJGVF3z2t9AAQdDGYtWqP0IDnmsYbZm, , 2018-06-25 16:59:36, 2018-06-25 16:59:36))

What error is this?

This happens at the moment. Step 3/3 : Company and Admin Details

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'locale' cannot be null (SQL: insert into `zo0_users` (`name`, `email`, `password`, `locale`, `updated_at`, `created_at`) values (, contato@smaiscontabil.com.br, $2y$10$2zU3aWzsiG6xpxybS09wP.VJGVF3z2t9AAQdDGYtWqP0IDnmsYbZm, , 2018-06-25 16:59:36, 2018-06-25 16:59:36)) 
  
What error is this? 
This happens at the moment. Step 3/3 : Company and Admin Details

Erez Zabusky ( User )

Commented 5 years ago

if using SQL 5.7 or higher make sure password plugin is not activated. (See complete guide post in the fortum) The issue is that Akaunting did not populate the 'locale' field when creating a user and if SQL plugin is activated it does not accept null values.

Soln- uninstall sql server and reinstall again without activating the plugin.

Andres ( User )

Commented 4 years ago

I got the same message but i can't find that plugin you mentioned

Ayodeji Peters ( User )

Commented 3 years ago

Drop the database and recreate the database again in Sql server, ensure you don't refresh the page during installation

Please login or register to leave a response.

Showing 1 to 4 of 4 discussions