Different place_detail table structures?

  • Resolved edward_plainview

    (@edward_plainview)


    8 years, 9 months ago

    Author of content sharing plugin Broadcast here.

    When Broadcast copies places between blogs in the network, it also copies the data from the place_detail database table, else the places won’t work properly.

    I see that the table structure is different on different blogs, I think from using different GD plugins. Since I use a mysql query to copy over the place_detail query to copy over the data, it fails if the table structure does not match.

    Do you have any suggestions as to how to handle the copying of the place_detail data?

    Inserting an empty row (except for the post ID and location ID) won’t work because other non-standard columns require default values.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Stiofan

    (@stiofansisland)

    8 years, 9 months ago

    Hi Edward,

    Yes the table depends on the fields the user adds and the addons he/she has installed.

    I would have thought you could just have added the basics and then looped through the columns to check if they exist before updating them.

    There are a few things you could do, like grab the user added columns info from the other table to figure out how to insert them.
    Or a rather “hacky” way might be to copy the last row info to create a new row with new post ID and then update the info you have.

    In an ideal world the two installs would have the same custom fields and addons active so all that would not be needed, maybe you could run a check for that and even copy custom fields?

    If you have any further questions just let me know.

    Thanks,

    Stiofan

    Thread Starter edward_plainview

    (@edward_plainview)

    8 years, 8 months ago

    Yeah. I figured that there wouldn’t be an easy way to solve this. 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Different place_detail table structures?’ is closed to new replies.

Tags