Skip to content
This repository has been archived by the owner on Jan 6, 2023. It is now read-only.

Set default value for existing checkbox field cause sql error #739

Closed
KKAries opened this issue Jan 30, 2019 · 0 comments
Closed

Set default value for existing checkbox field cause sql error #739

KKAries opened this issue Jan 30, 2019 · 0 comments
Labels
bug Something isn't working

Comments

@KKAries
Copy link

KKAries commented Jan 30, 2019

Bug Report

Steps to Reproduce

  1. Create a collection with checkbox field and save
  2. Edit the checkbox field to set a default value
  3. Save the field
  4. See error

Expected Behavior

The field update field window is closed and the field is saved.

Actual Behavior

The update field window is not closed and there is error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT 'value3'' at line 2 shown in the browser console. However, there is no error shown on directus UI.

Other Context & Screenshots

Technical Details

Directus APP 7.0.16 and API 2.0.16

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants