Akaunting free accounting software

Forum

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

Back
New Discussion

All Discussions

Dedicated Support Collaboration Hub

1364 Error

Blair   ( User )

Commented 3 years ago

Hello

When trying uninstall/disable an app to troubleshoot it not updating, it fails, and the logs show General error: 1364 Field category doesn't have a default value. Has anyone seen this and if so, how did you fix it. Thanks very much.

Denis Dulici   ( Admin )

Commented 3 years ago

Hello,

I'm not able to reproduce such an issue, make sure you're using the latest version of Akaunting.

Regards

Ariel Toledo   ( User )

Commented 3 years ago

Same here when traying to install a new module

Ariel Toledo   ( User )

Commented 3 years ago

In Connection.php line 671:

SQLSTATE[HY000]: General error: 1364 Field 'category' doesn't have a default value (SQL: insert into `qn8_module_histories` (`company_id`, `modul
e_id`, `version`, `description`, `updated_at`, `created_at`) values (1, 4, 1.0.0, extend-item-product installed, 2020-10-21 22:43:36, 2020-10-21
22:43:36))


In PDOStatement.php line 119:

SQLSTATE[HY000]: General error: 1364 Field 'category' doesn't have a default value


In PDOStatement.php line 117:

SQLSTATE[HY000]: General error: 1364 Field 'category' doesn't have a default value

Gary Fonseca   ( User )

Commented 3 years ago

I get the same error when try to create a company

Henry Weismann   ( User )

Commented 3 years ago

Hi,

I got the same error. I then changed in this table qkp_module_histories category to have a default of NULL. It seems category disappeared after I upgraded on of the modules or changed to description.

Please login or register to leave a response.

Showing 1 to 6 of 6 discussions