Which table are File Names stored?

  • Resolved ba95472

    (@ba95472)


    1 year ago

    When I uploaded the CSV, all the file names which contained spaces, for example, Sample Book.pdf appear now as SampleBook.pdf. Can you please tell me what table the file names are stored in? Thanks!

    • This topic was modified 1 year ago by ba95472.
    • This topic was modified 1 year ago by ba95472.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Mihai Joldis

    (@misulicus)

    Hi @ba95472

    Are you referring to the Downloadable files or the actual Download names?

    The files that the user downloads, are created as regular WordPress posts since they are uploaded with the post type of “attachment”. There is also an entry in the post meta table for that specific Download ID.

    Even with the WordPress Media uploader, spaces are replaced with -. This is good practice as downloading files with spaces in them might cause issues.

    If possible, use - or no spaces at all in your Download Files.

    Thread Starter ba95472

    (@ba95472)

    Hi Mihai!

    I’m referring to the Download Files section (below Download Details) in a product. The File Name has the spaces removed, which I’d actually like to keep. The same File Name is used in Name for the post, so I’d like to do a MySQL update to SET File_Name = Name if possible. Thanks again!

    Plugin Support Mihai Joldis

    (@misulicus)

    Hi.

    We have tested this and EDD does not remove the spaces during the import of the files. WordPress core itself replaces spaces with - if you upload a file from the Media library.

    It could be possible that the spaces are removed at the server level to avoid issues.

    The data is stored in a serialized array so a Mysql query will not work as it will change the length of the string which will require unserializing, and then re-searlizing it and saving it.

    You can try setting up a new site on a different hosting account(use a free service for temporary WordPress setups) and see if the files are also being stripped of the spaces.

    Thread Starter ba95472

    (@ba95472)

    Thanks so much Mihai for looking into this, much appreciated!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Which table are File Names stored?’ is closed to new replies.