starred/modoboa-modoboa
1
0
Fork 0
mirror of https://github.com/modoboa/modoboa.git synced 2026-04-26 17:36:01 +03:00
Code Issues 60 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #1048] dovecot: dict(12777): Error: sql dict: commit failed: Field 'messages' doesn't have a default value #880

New issue
Closed
opened 2026-02-27 11:14:04 +03:00 by kerem · 8 comments
kerem commented 2026-02-27 11:14:04 +03:00
Owner
Copy link

Originally created by @cerw on GitHub (Feb 26, 2017).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1048

Impacted versions

  • Modoboa: 1.6.3
  • installer used: Yes
  • Webserver: Nginx

Steps to reproduce

Getting this lots in logs?

dovecot: dict(12777): Error: sql dict: commit failed: Field 'messages' doesn't have a default value

Random in mail.log

Current behavior

Expected behavior

Video/Screenshot link (optional)

Originally created by @cerw on GitHub (Feb 26, 2017). Original GitHub issue: https://github.com/modoboa/modoboa/issues/1048 # Impacted versions * Modoboa: 1.6.3 * installer used: Yes * Webserver: Nginx # Steps to reproduce Getting this lots in logs? ``` dovecot: dict(12777): Error: sql dict: commit failed: Field 'messages' doesn't have a default value ``` Random in mail.log # Current behavior # Expected behavior # Video/Screenshot link (optional)
kerem 2026-02-27 11:14:04 +03:00
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Feb 27, 2017):

What is your database?

On 26/02/2017 13:49, Petr Cervenka wrote:

Impacted versions

  • Modoboa: 1.6.3
  • installer used: Yes
  • Webserver: Nginx

Steps to reproduce

Getting this lots in logs?

|dovecot: dict(12777): Error: sql dict: commit failed: Field 'messages'
doesn't have a default value |

Random in mail.log

Current behavior

Expected behavior

Video/Screenshot link (optional)

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/modoboa/modoboa/issues/1048, or mute the thread
https://github.com/notifications/unsubscribe-auth/AAgc7oeWK5UDeL5fKhx6yPRNiIsh6gaIks5rgXTxgaJpZM4MMX5N.

<!-- gh-comment-id:282656099 --> @tonioo commented on GitHub (Feb 27, 2017): What is your database? On 26/02/2017 13:49, Petr Cervenka wrote: > > > Impacted versions > > * Modoboa: 1.6.3 > * installer used: Yes > * Webserver: Nginx > > > Steps to reproduce > > Getting this lots in logs? > > |dovecot: dict(12777): Error: sql dict: commit failed: Field 'messages' > doesn't have a default value | > > Random in mail.log > > > Current behavior > > > Expected behavior > > > Video/Screenshot link (optional) > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <https://github.com/modoboa/modoboa/issues/1048>, or mute the thread > <https://github.com/notifications/unsubscribe-auth/AAgc7oeWK5UDeL5fKhx6yPRNiIsh6gaIks5rgXTxgaJpZM4MMX5N>. >
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Mar 2, 2017):

@cerw ping

<!-- gh-comment-id:283611373 --> @tonioo commented on GitHub (Mar 2, 2017): @cerw ping
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Apr 20, 2017):

Closed for inactivity.

<!-- gh-comment-id:295654210 --> @tonioo commented on GitHub (Apr 20, 2017): Closed for inactivity.
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@cerw commented on GitHub (May 15, 2017):

Sorry for some reason github did not send me email :(

mysql 5.7.18

<!-- gh-comment-id:301373026 --> @cerw commented on GitHub (May 15, 2017): Sorry for some reason github did not send me email :( mysql 5.7.18
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@cerw commented on GitHub (May 16, 2017):

@tonioo

<!-- gh-comment-id:301655966 --> @cerw commented on GitHub (May 16, 2017): @tonioo
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (May 16, 2017):

@cerw That's strange because the corresponding django model defines a default value for this field...
Can you try to run the following SQL statement please:

ALTER TABLE admin_quota ALTER COLUMN messages SET DEFAULT 0;
<!-- gh-comment-id:301730706 --> @tonioo commented on GitHub (May 16, 2017): @cerw That's strange because the corresponding django model defines a default value for this field... Can you try to run the following SQL statement please: ```sql ALTER TABLE admin_quota ALTER COLUMN messages SET DEFAULT 0; ```
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@cerw commented on GitHub (May 16, 2017):

The date got there via postfixadmin migration script? could this cause it?

I ran the SQL alter command and it seem to fix the messages now i have for bytes.

May 16 19:50:52 modoboa dovecot: dict(22930): Error: sql dict: commit failed: Field 'bytes' doesn't have a default value
M
<!-- gh-comment-id:301758146 --> @cerw commented on GitHub (May 16, 2017): The date got there via postfixadmin migration script? could this cause it? I ran the SQL alter command and it seem to fix the messages now i have for bytes. ``` May 16 19:50:52 modoboa dovecot: dict(22930): Error: sql dict: commit failed: Field 'bytes' doesn't have a default value M ```
kerem commented 2026-02-27 11:14:05 +03:00
Author
Owner
Copy link

@cerw commented on GitHub (May 16, 2017):

After I set default to bytes its seem to be fixed. Thanks

<!-- gh-comment-id:301759428 --> @cerw commented on GitHub (May 16, 2017): After I set default to `bytes` its seem to be fixed. Thanks
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
fix/sievefilters-allow-email-in-rule-name
dependabot/npm_and_yarn/frontend/axios-1.15.0
translations_04c0b653215cb5fa48ab101eae1a1917_ja_JP
translations_5d93982e9fd6dab991db4faf93ce9ded_ja_JP
fix/login-issue-3995
fix/sievefilters-issues
add-vitepress-openapi
2974-dmarc-empty-email
2.3.x
updated-doc-2.3.0
feature/OIDC
delete-all-alarms
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_af_ZA
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ar
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ca
1.x
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_sk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_tr
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_es_ES
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_uk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_zh_CN
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_de_DE
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_da_DK
1.8.x
1.7.x
1.6.x
1.4.x
1.3.x
1.2.x
2.8.2
2.8.1
2.8.0
2.7.2
2.7.1
2.7.0
2.6.5
2.6.4
2.6.3
2.6.2
2.6.1
2.6.0
2.5.1
2.5.0
2.4.11
2.4.10
2.4.9
2.4.8
2.4.7
2.4.6
2.4.5
2.4.4
2.4.3
2.4.2
2.4.1
2.4.0
2.3.6
2.3.5
2.3.4
2.3.3
2.3.2
2.3.1
2.3.0
2.3.0-beta.4
2.3.0-beta.3
2.3.0-beta.2
2.3.0-beta.1
2.2.4
2.2.3
2.2.2
2.2.1
2.2.0
2.1.2
2.1.1
2.1.0
2.0.5
2.0.4
2.0.3
2.0.2
2.0.1
2.0.0
2.0.0-beta.3
2.0.0-beta.2
2.0.0-beta.1
1.17.0
1.16.1
1.16.0
1.15.0
1.14.0
1.13.1
1.13.0
1.12.2
1.12.1
1.12.0
1.11.1
1.11.0
1.10.7
1.10.6
1.10.5
1.10.4
1.10.3
1.10.2
1.10.1
1.10.0
1.9.1
1.9.0
1.8.3
1.8.2
1.8.1
1.8.0
1.7.4
1.7.3
1.7.2
1.7.1
1.7.0
1.6.3
1.6.2
1.6.1
1.6.0
1.5.3
1.5.2
1.5.1
1.5.0
1.4.5
1.4.4
1.4.3
1.4.2
1.4.1
1.4.0
1.3.5
1.3.4
1.2.2
1.3.3
1.3.2
1.3.1
1.3.0
1.2.1
1.2.0
1.2.0-rc2
1.2.0-rc1
1.1.7
1.1.6
1.1.5
1.1.4
1.1.3
1.1.2
1.1.1
1.1.0
1.0.1
1.0.0
0.9.5
0.9.4
0.9.3
0.9.2
0.9.1
0.9
0.8.8
0.8.7
0.8.6.1
0.8.6
0.8.5
0.8.4
0.8.3
0.8.3-rc1
0.8.2
0.8.1
0.8
0.8-rc2
0.8-rc1
0.7.2
0.7.1
0.7
0.6.1
0.6
0.5
0.3
0.2
0.1
Labels
Clear labels   
bug

   
bug

   
dependencies

   
design

   
documentation

   
duplicate

   
enhancement

   
enhancement

   
enhancement

   
feedback-needed

   
help-needed

   
help-needed

   
installer

   
invalid

   
looking-for-sponsors

   
modoboa-contacts

   
new-ui

   
new-ui

   
pr

   
pull-request

Mirrored from GitHub Pull Request

  
pyconfr

   
python

   
question

   
security

   
stale

   
webmail

   
wontfix
No labels
bug
bug
dependencies
design
documentation
duplicate
enhancement
enhancement
enhancement
feedback-needed
help-needed
help-needed
installer
invalid
looking-for-sponsors
modoboa-contacts
new-ui
new-ui
pr
pull-request
pyconfr
python
question
security
stale
webmail
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/modoboa-modoboa#880
No description provided.