Summernote image upload gives an SQL error
I am stuck with a problem containing Summernote. I added the Summernote bar to my div, all functions work except the image uploader. It allows the image to be uploaded but when I click save. This error shows up:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: update
tasks
setupdated_at
= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
add a comment |
I am stuck with a problem containing Summernote. I added the Summernote bar to my div, all functions work except the image uploader. It allows the image to be uploaded but when I click save. This error shows up:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: update
tasks
setupdated_at
= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
add a comment |
I am stuck with a problem containing Summernote. I added the Summernote bar to my div, all functions work except the image uploader. It allows the image to be uploaded but when I click save. This error shows up:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: update
tasks
setupdated_at
= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
I am stuck with a problem containing Summernote. I added the Summernote bar to my div, all functions work except the image uploader. It allows the image to be uploaded but when I click save. This error shows up:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: update
tasks
setupdated_at
= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
laravel summernote
asked Nov 20 '18 at 9:10
Rb.mRb.m
32
32
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
First option:
You can make description
column type text
without length.
Second option:
By default summernote insert image data to src. You can reduce data length, by upload images to server and insert image url instead of image data.
$('.summernote').summernot({
callbacks: {
onImageUpload: function(image, editor) {
let data = new FormData();
data.append('file', image[0]);
$.ajax({
url: 'path to your upload method',
cache: false,
contentType: false,
processData: false,
data: data,
type: 'post',
success: function (url) {
editor.summernote('insertImage', url);
}
});
}
}
});
add a comment |
Change description
column type to TEXT
. if that is allready TEXT
then change it to MEDIUMTEXT
.
Remember length of TEXT
type is 65,635 character only.
Use MEDIUMTEXT
or LONGTEXT
for big content.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53389607%2fsummernote-image-upload-gives-an-sql-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
First option:
You can make description
column type text
without length.
Second option:
By default summernote insert image data to src. You can reduce data length, by upload images to server and insert image url instead of image data.
$('.summernote').summernot({
callbacks: {
onImageUpload: function(image, editor) {
let data = new FormData();
data.append('file', image[0]);
$.ajax({
url: 'path to your upload method',
cache: false,
contentType: false,
processData: false,
data: data,
type: 'post',
success: function (url) {
editor.summernote('insertImage', url);
}
});
}
}
});
add a comment |
First option:
You can make description
column type text
without length.
Second option:
By default summernote insert image data to src. You can reduce data length, by upload images to server and insert image url instead of image data.
$('.summernote').summernot({
callbacks: {
onImageUpload: function(image, editor) {
let data = new FormData();
data.append('file', image[0]);
$.ajax({
url: 'path to your upload method',
cache: false,
contentType: false,
processData: false,
data: data,
type: 'post',
success: function (url) {
editor.summernote('insertImage', url);
}
});
}
}
});
add a comment |
First option:
You can make description
column type text
without length.
Second option:
By default summernote insert image data to src. You can reduce data length, by upload images to server and insert image url instead of image data.
$('.summernote').summernot({
callbacks: {
onImageUpload: function(image, editor) {
let data = new FormData();
data.append('file', image[0]);
$.ajax({
url: 'path to your upload method',
cache: false,
contentType: false,
processData: false,
data: data,
type: 'post',
success: function (url) {
editor.summernote('insertImage', url);
}
});
}
}
});
First option:
You can make description
column type text
without length.
Second option:
By default summernote insert image data to src. You can reduce data length, by upload images to server and insert image url instead of image data.
$('.summernote').summernot({
callbacks: {
onImageUpload: function(image, editor) {
let data = new FormData();
data.append('file', image[0]);
$.ajax({
url: 'path to your upload method',
cache: false,
contentType: false,
processData: false,
data: data,
type: 'post',
success: function (url) {
editor.summernote('insertImage', url);
}
});
}
}
});
answered Nov 20 '18 at 9:47
IndianCodingIndianCoding
1,054119
1,054119
add a comment |
add a comment |
Change description
column type to TEXT
. if that is allready TEXT
then change it to MEDIUMTEXT
.
Remember length of TEXT
type is 65,635 character only.
Use MEDIUMTEXT
or LONGTEXT
for big content.
add a comment |
Change description
column type to TEXT
. if that is allready TEXT
then change it to MEDIUMTEXT
.
Remember length of TEXT
type is 65,635 character only.
Use MEDIUMTEXT
or LONGTEXT
for big content.
add a comment |
Change description
column type to TEXT
. if that is allready TEXT
then change it to MEDIUMTEXT
.
Remember length of TEXT
type is 65,635 character only.
Use MEDIUMTEXT
or LONGTEXT
for big content.
Change description
column type to TEXT
. if that is allready TEXT
then change it to MEDIUMTEXT
.
Remember length of TEXT
type is 65,635 character only.
Use MEDIUMTEXT
or LONGTEXT
for big content.
answered Nov 20 '18 at 12:26
Dhruv RavalDhruv Raval
1,066312
1,066312
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53389607%2fsummernote-image-upload-gives-an-sql-error%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