New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Creating new time-accout results in "Field 'contract' doesn't have a default value" #6928

Open
weberhofer opened this Issue Sep 24, 2018 · 4 comments

Comments

2 participants
@weberhofer
Contributor

weberhofer commented Sep 24, 2018

Trying to save a new time account results in an exception:

SQLSTATE[HY000]: General error: 1364 Field 'contract' doesn't have a default value, query was: INSERT INTO `tine20_timetracker_timeaccount` (`title`, `number`, `description`, `budget`, `budget_unit`, `price`, `price_unit`, `is_open`, `is_billable`, `billed_in`, `status`, `cleared_at`, `deadline`, `container_id`, `seq`, `is_deleted`, `created_by`, `creation_time`, `last_modified_by`, `last_modified_time`, `deleted_time`, `deleted_by`, `id`) VALUES (?, ?, ?, NULL, ?, NULL, ?, 1, 1, ?, ?, NULL, ?, ?, 1, 0, ?, ?, NULL, NULL, NULL, NULL, ?)

Allowing NULL in this row and setting the default value to NULL solves the problem.

@pschuele

This comment has been minimized.

Show comment
Hide comment
@pschuele

pschuele Sep 24, 2018

Member

hi,
which version are you using? there shouldn't be a row 'contract' in this table.

Member

pschuele commented Sep 24, 2018

hi,
which version are you using? there shouldn't be a row 'contract' in this table.

@weberhofer

This comment has been minimized.

Show comment
Hide comment
@weberhofer

weberhofer Sep 24, 2018

Contributor

It's version 2018.08.4; this is my personal instance which have been updates since years...

Contributor

weberhofer commented Sep 24, 2018

It's version 2018.08.4; this is my personal instance which have been updates since years...

@pschuele

This comment has been minimized.

Show comment
Hide comment
@pschuele

pschuele Sep 25, 2018

Member

ok, as a hotfix, you can just drop the column "contract". I'll have a look at this.

Member

pschuele commented Sep 25, 2018

ok, as a hotfix, you can just drop the column "contract". I'll have a look at this.

@pschuele pschuele self-assigned this Sep 25, 2018

@pschuele pschuele added this to To do in Tine 2.0 Development via automation Sep 25, 2018

@weberhofer

This comment has been minimized.

Show comment
Hide comment
@weberhofer

weberhofer Sep 26, 2018

Contributor

Thanks, I'll do that.

Contributor

weberhofer commented Sep 26, 2018

Thanks, I'll do that.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment