Skip to content
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

SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "categoryID" violates not-null constraint #101

Open
junmingyeo opened this issue Nov 24, 2020 · 1 comment

Comments

@junmingyeo
Copy link

junmingyeo commented Nov 24, 2020

Hi, I have chance upon this great Laravel E commerce Tutorial, it have all been a smooth flow until now where I have this issue when trying to create a Category in Voyager itself.

I am using the following versions for my installations:

  • PHP v7.4.11
  • Laravel v8.14
  • Voyager v1.4
  • Database: Posgresql v12.1

Below are the details of the error:
image

Below are my table column names in pgsql:
image

This are my migration method in my codes:
image

This is my Category Model codes:
image

Please kindly assist on this if anyone have the solution for it!
P.S. Pardon for my poor posting of questions as this is my first time using github

Thanks!

@junmingyeo
Copy link
Author

Okay I tried around apparently once I unchecked the Add visibility for my categoryID column in the Edit Bread page of the Voyager admin page, I am able to add a new category through voyager.

Is this a bug or some logic was not met?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant