Viewing 16 posts - 1 through 16 (of 16 total)
  • Author
    Posts
  • #1220850

    Thme Enfold version 4.5.7
    WordPress 5.3.3
    The site starts to go slow and then the entire server is down due to the database overuse , I have checked that he WP table wp_postmeta has grown exponentially in the last month from 200 MB to 900 MB and the grown is in the wp_postmeta table, that appears to repeat information with a lot of rows apparently redundant :

    meta_id post_id meta_key meta_value
    3896043 16407 _av_el_mgr_version 1.0
    3896042 16407 _avia_sc_parser_state check_only
    3896039 16405 _edit_last 2
    3896037 16406 _wp_attachment_metadata a:5:{s:5:”width”;i:321;s:6:”height”;i:204;s:4:”file”;s:21:”2020/06/05.06-e-1.png”;s:5:”sizes”;a:5:{s:9:”thumbnail”;a:4:{s:4:”file”;s:19:”05.06-e-1-80×51.png”;s:5:”width”;i:80;s:6:”height”;i:51;s:9:”mime-type”;s:9:”image/png”;}s:6:”widget”;a:4:{s:4:”file”;s:19:”05.06-e-1-36×36.png”;s:5:”width”;i:36;s:6:”height”;i:36;s:9:”mime-type”;s:9:”image/png”;}s:6:”square”;a:4:{s:4:”file”;s:21:”05.06-e-1-180×180.png”;s:5:”width”;i:180;s:6:”height”;i:180;s:9:”mime-type”;s:9:”image/png”;}s:15:”portfolio_small”;a:4:{s:4:”file”;s:21:”05.06-e-1-260×185.png”;s:5:”width”;i:260;s:6:”height”;i:185;s:9:”mime-type”;s:9:”image/png”;}s:14:”shop_thumbnail”;a:4:{s:4:”file”;s:21:”05.06-e-1-120×120.png”;s:5:”width”;i:120;s:6:”height”;i:120;s:9:”mime-type”;s:9:”image/png”;}}s:10:”image_meta”;a:12:{s:8:”aperture”;s:1:”0″;s:6:”credit”;s:0:””;s:6:”camera”;s:0:””;s:7:”caption”;s:0:””;s:17:”created_timestamp”;s:1:”0″;s:9:”copyright”;s:0:””;s:12:”focal_length”;s:1:”0″;s:3:”iso”;s:1:”0″;s:13:”shutter_speed”;s:1:”0″;s:5:”title”;s:0:””;s:11:”orientation”;s:1:”0″;s:8:”keywords”;a:0:{}}}
    3896036 16406 _wp_attached_file 2020/06/05.06-e-1.png
    3896035 16405 _dp_original 16395
    3896032 16405 _thumbnail_id 16406
    3896031 16405 _wp_old_date 2020-05-15
    3896030 16405 _wp_old_date 2020-05-15
    3896029 16405 _wp_old_date 2020-05-15
    3896028 16405 _wp_old_date 2020-05-15
    3896027 16405 _wp_old_date 2020-05-15
    3896026 16405 _wp_old_date 2020-05-15
    3896025 16405 _wp_old_date 2020-05-15
    3896024 16405 _wp_old_date 2020-05-15
    3896023 16405 _wp_old_date 2020-05-15
    3896022 16405 _wp_old_date 2020-05-15
    3896021 16405 _wp_old_date 2020-05-15
    3896020 16405 _wp_old_date 2020-05-15
    3896019 16405 _wp_old_date 2020-05-15
    3896018 16405 _wp_old_date 2020-05-15
    3896017 16405 _wp_old_date 2020-05-15
    3896016 16405 _wp_old_date 2020-05-15
    3896015 16405 _wp_old_date 2020-05-15
    3896014 16405 _wp_old_date 2020-05-15
    3896013 16405 _wp_old_date 2020-05-15
    3896012 16405 _wp_old_date 2020-05-15
    3896011 16405 _wp_old_date 2020-05-15
    3896010 16405 _wp_old_date 2020-05-15
    3896009 16405 _wp_old_date 2020-05-15
    3896008 16405 _wp_old_date 2020-05-15
    3896007 16405 _wp_old_date 2020-05-15
    3896006 16405 _wp_old_date 2020-05-15
    3896005 16405 _wp_old_date 2020-05-15
    3896004 16405 _wp_old_date 2020-05-15
    3896003 16405 _wp_old_date 2020-05-15
    3896002 16405 _wp_old_date 2020-05-15
    3896001 16405 _wp_old_date 2020-05-15
    3896000 16405 _wp_old_date 2020-05-15
    3895999 16405 _wp_old_date 2020-05-15
    3895998 16405 _wp_old_date 2020-05-15
    3895997 16405 _wp_old_date 2020-05-15
    3895996 16405 _wp_old_date 2020-05-15
    3895995 16405 _wp_old_date 2020-05-15
    3895994 16405 _wp_old_date 2020-05-15
    3895993 16405 _wp_old_date 2020-05-15
    3895992 16405 _wp_old_date 2020-05-15
    3895991 16405 _wp_old_date 2020-05-15
    ….
    I cand send you the hole table if you want

    Any fix ?
    And any suggestion to decrease the wp_postmeta removing unnecesary rows?

    Thanks!

    #1220869

    Hey,

    Thanks for contacting us!

    Have you enabled CSS and JS file merging and compression in Enfold theme options > Performance tab? If so, please refer to this post – https://kriesi.at/documentation/enfold/optimization/#troubleshoot and choose to disable unique timestamps.

    You are currently using an older version of the theme which does not has this feature, therefore you would firstly need to update Enfold to the latest version 4.7.5 – https://kriesi.at/documentation/enfold/theme-update/

    Best regards,
    Yigit

    #1220882

    Yes I’ll do that , but how can I remove redundant rows form wp_postmeta so it decreases?

    #1221384

    Hi jasonkruger,

    Please have a look at this article:

    If you need further assistance please let us know.
    Best regards,
    Victoria

    #1221612

    The information of the article is useless for the case, the article points how to get rid of postmeta refering deleted posts , but the case with the bug of your Enfold theme is that there are a lot of postmeta (repeated a lot of times with the same data) refering to existing posts.

    The SQL sentence useful in this case is :

    DELETE FROM wp_postmeta WHERE meta_id NOT IN (SELECT * FROM (SELECT MAX(pm.meta_id) FROM wp_postmeta pm GROUP BY pm.post_id, pm.meta_key) x)

    This sentence removes repeated postmeta for the same postid and meta_key, remaining only the last introduced.
    I found this sentence in other place, but I put it here, in case any of your customers need it.

    #1221783

    Hi jasonkruger,

    Glad you got it working for you and thank you for sharing! :)

    If you need further assistance please let us know.

    Best regards,
    Victoria

    #1226544

    It has happened again , another server crash ,with another database size growing out of control of the wp_postmeta table , But this time we already had disabled the CSS and JS compresión and merging , so it seems this is not the problem.
    Any clue where the problem could be ?

    Thanks.

    #1227093

    Hi,

    Thanks for the update and sorry for the problem. Please send us a temporary WordPress admin login and login URL so that we can have a closer look. You can post the details in the Private Content section of your reply.

    Best regards,
    Rikard

    #1227192
    This reply has been marked as private.
    #1227378

    Hi,

    Thanks for the update. It might not be necessary to access your site, could you try installing the beta version in private to see if that helps please?

    Best regards,
    Rikard

    #1227408

    Since this beta version is not installed from the update option of the teme, could you please explain detailed steps to install this beta version without losing customizations made to the teheme (colours,settings,etc…)

    Thanks.

    #1227451

    Hi,

    Please use this plugin – https://wordpress.org/plugins/update-theme-and-plugins-from-zip-file/ and try installing it as a new theme :)

    Best regards,
    Yigit

    #1227479
    This reply has been marked as private.
    #1227485

    Hi,

    Please refer to this post – https://kriesi.at/documentation/enfold/theme-update/#update-via-ftp and try updating the theme via FTP.
    Then go to Enfold theme options > Performance and enable “Show advanced options”, then choose “Fix WP bug, disable unique timestamps” options and save theme options.

    Regards,
    Yigit

    #1227507
    This reply has been marked as private.
    #1227551

    Hi,

    Because it is the beta version of upcoming version which includes the fixes listed here – https://kriesi.at/support/topic/enfold-upcoming-fixes/

    Yes, it includes this fix as well. The options I mentioned in my previous post is not available in 4.7.5

    Then go to Enfold theme options > Performance and enable “Show advanced options”, then choose “Fix WP bug, disable unique timestamps” options and save theme options.

    Best regards,
    Yigit

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