Summernote image upload gives an SQL error
up vote
0
down vote
favorite
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 |
up vote
0
down vote
favorite
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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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 at 9:10
Rb.m
32
32
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
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 |
up vote
0
down vote
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 |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 |
up vote
0
down vote
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 |
up vote
0
down vote
up vote
0
down vote
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 at 9:47
IndianCoding
6048
6048
add a comment |
add a comment |
up vote
0
down vote
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 |
up vote
0
down vote
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 |
up vote
0
down vote
up vote
0
down vote
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 at 12:26
Dhruv Raval
620111
620111
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