Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • October 10, 2018 at 6:17 pm #1020030
    rockyrockshow

    Avia Layout Builder is based on shortcodes. These are stored to the database. I tried to replace specific image elements, but the change doesn’t seem to take effect.
    For example, I activated the Debug Mode of ALB. After that, I looked for the shortcode of said element. To replace it, I’m running this MySQL statement:

    UPDATE wp_posts SET post_content = replace(post_content, "[av_image src='http://localhost/wp-content/uploads/2018/02/application_banner-e1537270610390.png' attachment='521' attachment_size='full' align='center' styling='' hover='' link='manually,https://www.f6s.com/spinlab-thehhlaccelerator8thclass' target='_blank' caption='' font_size='' appearance='' overlay_opacity='0.4' overlay_color='#000000' overlay_text_color='#ffffff' copyright='' animation='no-animation' av_uid='av-9ts9qf' admin_preview_bg=''][/av_image]", "[av_image src='http://localhost/wp-content/uploads/2018/09/APPLY_NOW_FEATURED.png' attachment='521' attachment_size='full' align='center' styling='' hover='' link='manually,https://www.nein.com' target='_blank' caption='' font_size='' appearance='' overlay_opacity='0.4' overlay_color='#000000' overlay_text_color='#ffffff' copyright='' animation='no-animation' av_uid='av-9ts9qf' admin_preview_bg=''][/av_image]");

    The only thing I change is the URL of the image. The MySQL statement takes changes the affected rows, but the website still looks the same. When I look at the page with the ALB Debug Mode again, it still shows the old shortcode element in place.
    Is it not possible to do something like this?

    October 11, 2018 at 10:45 pm #1020510
    Basilis

    Hey rockyrockshow,

    Unfortunately, it would require quite some time and customization of the theme to achieve this, so I am sorry to tell you that this is not covered by our support. However, if it’s really important for you to get this done, you can always hire a freelancer to do the job for you :)

    Best regards,
    Basilis

    August 21, 2019 at 6:53 pm #1129696
    JoeLovell

    I had the same issue and no time to use a freelancer. It doesn’t require customisation of the theme.

    For anyone looking for this in future, you can change the ALB content by replacing on the _aviaLayoutBuilderCleanData meta_key in the postmeta table, instead or as well as post_content in the posts table.

    So instead of (or as well as):

    UPDATE wp_posts SET post_content = REPLACE (post_content, 'oldstring', 'newstring')

    You can use:

    UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'oldstring', 'newstring') WHERE meta_key = '_aviaLayoutBuilderCleanData'

    PS You’re directly editing values in the database so take a back up and take care.

    • This reply was modified 5 years, 3 months ago by JoeLovell.
    August 21, 2019 at 9:37 pm #1129770
    Victoria

    Hi JoeLovell,

    Thanks for sharing :)

    Best regards,
    Victoria

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.