GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

wav files are not getting uploaded into the BLOB

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • wav files are not getting uploaded into the BLOB

    Hello

    We have an application where we register some audio files which we want to be uploaded into the database.
    We are running a database query to upload the file into the db, but however everything seams to be fine but we after we query the db for the results it always shows NULL.

    the column where we want to store the wav file has MEDIUMBLOB type

    Please provide any suggestion to be able to fix this issue.

    thanks

  • #2
    do you commit the transaction?

    Comment


    • #3
      I am not sure. How can I make sure that I commit the transaction?

      Comment


      • #4
        this is the command I am using to upload the wav file into the database:

        UPDATE pbx_cdrs SET recording=LOAD_FILE('/path/to/file/file_name.wav') where uid='1341774724.3312';

        thanks for the help

        Comment


        • #5
          please confirm the function LOAD_FILE(file_name).

          Comment


          • #6
            please confirm the function LOAD_FILE(file_name).

            LOAD_FILE(file_name)
            Reads the file and returns the file contents as a string.
            it's string , not blob.

            Comment


            • #7
              Hi,

              The command is runing by the application on the system where the recordings are. The application has full privileges on the files meaning they are readable.

              Comment


              • #8
                Hi,

                As we are can read the sound file from php file read, can we put that content into database and will it put file into database.

                Thanks
                Vikas Kumar

                Comment

                Working...
                X