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 set updated_at = 2018-11-20 09:08:43




Does someone know how to resolve this problem? Thanks in advance.










share|improve this question


























    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 set updated_at = 2018-11-20 09:08:43




    Does someone know how to resolve this problem? Thanks in advance.










    share|improve this question
























      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 set updated_at = 2018-11-20 09:08:43




      Does someone know how to resolve this problem? Thanks in advance.










      share|improve this question













      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 set updated_at = 2018-11-20 09:08:43




      Does someone know how to resolve this problem? Thanks in advance.







      laravel summernote






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 20 at 9:10









      Rb.m

      32




      32
























          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);
          }
          });
          }
          }
          });





          share|improve this answer




























            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.






            share|improve this answer





















              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',
              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
              });


              }
              });














              draft saved

              draft discarded


















              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








              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);
              }
              });
              }
              }
              });





              share|improve this answer

























                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);
                }
                });
                }
                }
                });





                share|improve this answer























                  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);
                  }
                  });
                  }
                  }
                  });





                  share|improve this answer












                  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);
                  }
                  });
                  }
                  }
                  });






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 20 at 9:47









                  IndianCoding

                  6048




                  6048
























                      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.






                      share|improve this answer

























                        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.






                        share|improve this answer























                          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.






                          share|improve this answer












                          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.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 20 at 12:26









                          Dhruv Raval

                          620111




                          620111






























                              draft saved

                              draft discarded




















































                              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.




                              draft saved


                              draft discarded














                              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





















































                              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







                              Popular posts from this blog

                              404 Error Contact Form 7 ajax form submitting

                              How to know if a Active Directory user can login interactively

                              TypeError: fit_transform() missing 1 required positional argument: 'X'