Announcement

Collapse
No announcement yet.

Document (Database) Field Type Issue

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Document (Database) Field Type Issue

    I have a form including Document(Database) Field Type.
    When I'm adding a record with a pdf type document everything goes well.
    After updating , I 'm trying to view the record it is ok too but when I try to view the pdf document, after download I got an error " the file is damaged and could not repaired."

    Any suggestion ?

    Thanks,

  • #2
    Check your field type for the database column. It should be a type that does not convert the data, e.g. CLOB in oracle would be a wrong type, BLOB would be correct.
    BLOB would be corretc in mysql, TEXT would be wrong.

    Comment


    • #3
      It is BLOB type of course. I checked it. The error only occurs for pdf files. Word or other types are OK. I couldn't find why pdf files raises this error.

      The same error also occurs in the Project Management Sample on Scriptcase Website.
      You can see the error simply uploading a pdf file from the "add document" form.

      Comment


      • #4
        Could you look into the html header? Might have a wrong reference. Does it do that on different pc's? It might be that the filetype is bound to the wrong reader.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Originally posted by aducom View Post
          Could you look into the html header? Might have a wrong reference. Does it do that on different pc's? It might be that the filetype is bound to the wrong reader.
          It is the same on a different PC.
          Can you please try it on from link ?
          Add a new pdf document ?

          http://www.scriptcase.net/scriptcase...ct-management/

          Comment


          • #6
            Could you describe what to do to reproduce? It's refering to a demo of scriptcase. I guess that they will not allow us to upload anything at all...
            Albert Drent
            aducom software netherlands
            scriptcase partner, reseller, support and (turn-key) development
            www.scriptcase.eu / www.scriptcase.nl

            Comment


            • #7
              Originally posted by aducom View Post
              Could you describe what to do to reproduce? It's refering to a demo of scriptcase. I guess that they will not allow us to upload anything at all...
              In this demo application, please logon as an admin.
              From the menu select Document Library... Add Document...
              Upload a pdf file as an document.
              After posting the record, find the document using the same menu.
              Try to view the pdf document attached with the record.
              You can see the error .

              This occurs only with pdf files.

              Comment


              • #8
                I try it creating the same demo application on my server.
                The result is the same.

                Comment


                • #9
                  Originally posted by aducom View Post
                  I guess that they will not allow us to upload anything at all...
                  Exact ... Upload failed with any file.
                  Best regards: - Reinhard -

                  I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                  Comment


                  • #10
                    If you have the app running locally, did you apply the allowed filetypes? The samples are *exactly* the once on their site, so that's the reason why it won't work I think.
                    Albert Drent
                    aducom software netherlands
                    scriptcase partner, reseller, support and (turn-key) development
                    www.scriptcase.eu / www.scriptcase.nl

                    Comment


                    • #11
                      Originally posted by aducom View Post
                      If you have the app running locally, did you apply the allowed filetypes? The samples are *exactly* the once on their site, so that's the reason why it won't work I think.
                      I'm using it on a webserver provided by a hosting firm (hoo.st ).
                      I create the sample application on my server. Also I did an application myself using the Document Field Type.
                      The result is the same.

                      There is a problem with ONLY pdf files. Other file types are OK.
                      I couldn't find so far a reasonable cause for this error!

                      Comment

                      Working...
                      X