SQL Update – Website URL

  • Resolved adambeaumont1

    (@adambeaumont1)


    8 years, 3 months ago

    I am trying to update all directory listings directly in the database to save time (rather than go through each listing individually. )

    When I update the Website URL in the post_meta table it doesn’t save in the in the listing.

    Example:

    a:2:{i:0;s:53:"http://www.example.com/website/10";i:1;s:42:"Football Club Fan site";}
When I change to
a:2:{i:0;s:53:"http://www.newwebsite.com/website/10";i:1;s:42:"Football Club Fan site";}

    It saves in the database but doesn’t appear in the listing, the field appears blank. Any ideas? For some reason if I enter the same amount of characters it does appear in the listings.

    https://wordpress.org/plugins/business-directory-plugin/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Business Directory Plugin

    (@businessdirectoryplugin)

    8 years, 3 months ago

    Hi adambeaumont1,

    We don’t recommend doing direct DB updates to manage the data in the tables unless you’re experienced with SQL and WP data formats in general. Doing so can have bad results.

    Are you running a cache plugin here? Would that be impacting the data you’re trying to change in some way? Cache plugins would prevent changes from showing in a live fashion.

    If you’re just trying to update the field, I’d suggest using the Directory->Directory area of your site. It’s much easier.

    Thread Starter adambeaumont1

    (@adambeaumont1)

    8 years, 3 months ago

    Thanks for the feedback. The main issue I have is that I have 5000 listings in the directory and need to change the URL on all of them, doing them individually would take some time.

    The site uses no cache plugin, very strange why it wouldn’t appear. I am assuming the post_meta table is the only table I need to be updating.

    I will look at using the import feature of the plugin, hopefully I can get figured.

    Thanks.

    Plugin Author Business Directory Plugin

    (@businessdirectoryplugin)

    8 years, 3 months ago

    You might have a better time doing bulk updates like that doing a CSV export with the sequence ID enabled, edit the CSV file and then do a bulk CSV import afterward. That might be easier, quicker and safer.

    Docs on that here:
    http://businessdirectoryplugin.com/docs/#admin-export

    And here:
    http://businessdirectoryplugin.com/docs/#admin-import

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Update – Website URL’ is closed to new replies.

Tags