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
taskssetupdated_at= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
asked Nov 20 '18 at 9:10
Rb.m
32
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
taskssetupdated_at= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
asked Nov 20 '18 at 9:10
Rb.m
32
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
taskssetupdated_at= 2018-11-20 09:08:43
Does someone know how to resolve this problem? Thanks in advance.
laravel summernote
asked Nov 20 '18 at 9:10
Rb.m
32
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
taskssetupdated_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.m
32
asked Nov 20 '18 at 9:10
Rb.m
32
asked Nov 20 '18 at 9:10
Rb.m
32
asked Nov 20 '18 at 9:10
Rb.m
32
asked Nov 20 '18 at 9:10
Rb.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);
}
});
}
}
});
answered Nov 20 '18 at 9:47
IndianCoding
88519
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.
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
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);
}
});
}
}
});
answered Nov 20 '18 at 9:47
IndianCoding
88519
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);
}
});
}
}
});
answered Nov 20 '18 at 9:47
IndianCoding
88519
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);
}
});
}
}
});
answered Nov 20 '18 at 9:47
IndianCoding
88519
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
IndianCoding
88519
answered Nov 20 '18 at 9:47
IndianCoding
88519
answered Nov 20 '18 at 9:47
IndianCoding
88519
answered Nov 20 '18 at 9:47
IndianCoding
88519
88519
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.
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
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.
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
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.
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
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 Raval
1,016312
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
answered Nov 20 '18 at 12:26
Dhruv Raval
1,016312
1,016312
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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
