Blob type images and remote db

  • Hi,
    I use plugin WP Data Access in order to be able to edit my remote database. On this db, I use the longblob and blob types for photos and icons, respectively. However, the photos and icons in Data Explorer do not display their contents. I tried to add the type ‘image’ to the Column Type option, but pressing Save Column Settings sent the following error message to the console: Uncaught Error: Syntax error, unrecognized expression: #column_media _ ## _ old at Function.se.error etc. It is known that could i go ahead so i can view the images and add new ones or remove existing ones? Thank you.`

Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @kyriakik,

    Sorry for responding so late! It was a very busy week.

    WP Data Access does not support blob data types at this time. The plugin does not support storing images directly in the database yet. This is planned but not yet implemented. Sorry!

    There are two alternatives to use images:
    (1) With WordPress media library integration : column type = Image
    (2) Add the full URL : column type = ImageURL

    See: https://wpdataaccess.com/docs/documentation/data-explorer/table-and-view-settings/#column-settings

    Please read this part:

    The plugin supports multiple as well as single media columns:
    NUMBER columns are handled as single media columns
    VARCHAR columns are handled as multiple media columns
    Single media columns can only save only one media id. Multiple media columns can save as many media id’s as you like. The width of your char column determines the maximum number of id’s that can be stored. Make sure your column is wide enough!

    For alternative (1) just change your colummn type to use single or multiple media columns. For alternative (2) varchar(255) is usually enough to store a full URL.

    Hope this helps,
    Peter

Viewing 1 replies (of 1 total)
  • The topic ‘Blob type images and remote db’ is closed to new replies.