Could not convert database value to Doctrine Type json
I`m new user of Symfony 4 framework and i wish to build a correct login system using built-in auth system. However, i got an error while doctrine query.
Here is my screenshot:
And here is my migration of database:
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL,
email VARCHAR(180) NOT NULL,
roles TEXT NOT NULL,
password VARCHAR(255) NOT NULL,
UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
Should I change type of "roles" property to Json?
php mysql json
edited Jan 22 at 20:08
Dave
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
add a comment |
I`m new user of Symfony 4 framework and i wish to build a correct login system using built-in auth system. However, i got an error while doctrine query.
Here is my screenshot:
And here is my migration of database:
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL,
email VARCHAR(180) NOT NULL,
roles TEXT NOT NULL,
password VARCHAR(255) NOT NULL,
UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
Should I change type of "roles" property to Json?
php mysql json
edited Jan 22 at 20:08
Dave
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
add a comment |
I`m new user of Symfony 4 framework and i wish to build a correct login system using built-in auth system. However, i got an error while doctrine query.
Here is my screenshot:
And here is my migration of database:
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL,
email VARCHAR(180) NOT NULL,
roles TEXT NOT NULL,
password VARCHAR(255) NOT NULL,
UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
Should I change type of "roles" property to Json?
php mysql json
edited Jan 22 at 20:08
Dave
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
I`m new user of Symfony 4 framework and i wish to build a correct login system using built-in auth system. However, i got an error while doctrine query.
Here is my screenshot:
And here is my migration of database:
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL,
email VARCHAR(180) NOT NULL,
roles TEXT NOT NULL,
password VARCHAR(255) NOT NULL,
UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
Should I change type of "roles" property to Json?
php mysql json
php mysql json
edited Jan 22 at 20:08
Dave
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
edited Jan 22 at 20:08
Dave
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
edited Jan 22 at 20:08
Dave
20427
edited Jan 22 at 20:08
Dave
20427
edited Jan 22 at 20:08
Dave
20427
20427
asked Jan 22 at 20:00
NoLimesNoLimes
112
asked Jan 22 at 20:00
NoLimesNoLimes
112
asked Jan 22 at 20:00
NoLimesNoLimes
112
112
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1397149%2fcould-not-convert-database-value-to-doctrine-type-json%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1397149%2fcould-not-convert-database-value-to-doctrine-type-json%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
