• Resolved donbowman

    (@donbowman)


    i’m seeing this error on updates to any page (ones that have no “TEC” on them, e.g. standard pages). They worked on create, but on update I get a 500 error.

    wp 5.7.1, ubuntu 20.04, php 8.0

    This is the error, it comes from

    POST https://www.agilicus.com/wp-json/wp/v2/pages/117?_locale=user 500

    the error is

    code: "rest_meta_database_error", message: "Could not delete meta value from database.",…}
    code: "rest_meta_database_error"
    data: {key: "_EventOrganizerID", status: 500}
    message: "Could not delete meta value from database."
    +------------------------------------------+----------+------------------------------+---------+
    | name                                     | status   | update                       | version |
    +------------------------------------------+----------+------------------------------+---------+
    | akismet                                  | active   | none                         | 4.1.9   |
    | allow-webp-image                         | active   | none                         | 1.0.0   |
    | powerpress                               | active   | none                         | 8.5.3   |
    | cc-child-pages                           | active   | none                         | 1.39    |
    | code-syntax-block                        | active   | none                         | 2.0.2   |
    | yikes-inc-easy-mailchimp-extender        | active   | none                         | 6.8.3   |
    | yikes-inc-easy-mailchimp-popup-extension | active   | none                         | 1.3.3   |
    | event-tickets                            | active   | none                         | 5.1.1   |
    | fast-velocity-minify                     | active   | none                         | 3.1.4   |
    | featured-images-for-rss-feeds            | active   | none                         | 1.5.7   |
    | gutenberg                                | active   | none                         | 10.2.1  |
    | illustrations                            | active   | none                         | 1.0.2   |
    | jsonfeed                                 | active   | none                         | 1.4.1   |
    | lazy-load-for-videos                     | active   | none                         | 2.13.0  |
    | wp-nested-pages                          | active   | none                         | 3.1.13  |
    | neve-pro-addon                           | active   | none                         | 1.4.3   |
    | post-to-google-my-business               | active   | none                         | 2.2.34  |
    | redirection                              | active   | none                         | 5.0.1   |
    | wp-scheduled-posts                       | active   | none                         | 4.0.2   |
    | slb-handler-video                        | inactive | none                         | 0.2.1   |
    | simply-gallery-block                     | active   | available                    | 2.0.0   |
    | google-site-kit                          | active   | none                         | 1.28.0  |
    | smtp-mailer                              | active   | none                         | 1.1.1   |
    | super-progressive-web-apps               | active   | none                         | 2.1.8   |
    | svg-support                              | active   | version higher than expected | 3.0.0   |
    | the-events-calendar                      | active   | none                         | 5.4.0.2 |
    | the-paste                                | active   | none                         | 1.0.7   |
    | ultimate-addons-for-gutenberg            | active   | none                         | 1.21.1  |
    | webpushr-web-push-notifications          | active   | none                         | 4.23.0  |
    | wp-agilicus-login                        | active   | none                         | 3.5.0   |
    | wp-polls                                 | active   | none                         | 2.75.6  |
    | wp-stateless                             | active   | none                         | 3.1.1   |
    | wpcal                                    | active   | none                         | 0.9.4.4 |
    | wp-post-series                           | active   | none                         | 2.0.0   |
    | wp-super-cache                           | active   | none                         | 1.7.2   |
    | wp-to-twitter                            | active   | none                         | 3.5.2   |
    | duplicate-post                           | active   | none                         | 4.1.1   |
    | wordpress-seo                            | active   | none                         | 16.0.2  |
    | wordpress-seo-premium                    | active   | none                         | 16.0.2  |
    | advanced-cache.php                       | dropin   | none                         |         |
    +------------------------------------------+----------+------------------------------+---------+
Viewing 15 replies - 1 through 15 (of 16 total)
  • I see a similar error. Looking at the request it has

    meta._EventOrganizerID: []

    But from here, it is supposed to be an id

    https://theeventscalendar.com/knowledgebase/k/events-calendar-pro-wordpress-post-meta-data/

    I got exactly the same error after I updated all plugins to their latest versions and updated WordPress to 5.7 on my testing environment on my home PC.
    I thought it was caused after I added a new user role, assisgned that role to a new user and trying to assign that user as an author to a page. But I didn’t check whether the issues was already there right after updating the plugins and WordPress.
    On my production website everything seems to run stil fine.

    Firefox network console answer:

    code	"rest_meta_database_error"
    message	"Kon metawaarde niet verwijderen uit de database."
    data	Object { key: "_EventOrganizerID", status: 500 }
    key	"_EventOrganizerID"
    status	500

    Raw:
    {"code":"rest_meta_database_error","message":"Kon metawaarde niet verwijderen uit de database.","data":{"key":"_EventOrganizerID","status":500}}

    Edit:
    I can confirm changing meta._EventOrganizerID: [] in the request to meta._EventOrganizerID: "" and manually send that request resolves the issue. But it is undoable to do that by hand.

    I guess I’ll have to deactivate the The Event Organizer plugin untill there is an update for this issue… ??

    Today I discovered version 5.5.0 was released.
    I was happy to see this in the changelog:

    Fix – Saving on Blocks editor without Organizer is working as expected again [TEC-3788]

    I was very disappointed to see that the issues of this thread still exists in exact the same way. So it is actually not really fixed… I feel very frustrated now as this happens right before I wanted to release a website with calendar for my village.

    I reference this topic as that user got exactly the same error messages: https://www.ads-software.com/support/topic/the-events-calendar-breaks-kadence-theme/

    Plugin Support Deblyn Prado

    (@deblynprado)

    Hi there @joennuh @mrwaim @donbowman

    I’m sorry that you’re still facing this issue even after our recent release.
    Would you be able to share a screen recording demonstrating exactly what you’re doing when the error happens?

    This will help our team to better identify which field tis causing the problem.

    Thank you all for the reports and collaboration on it

    Plugin Support Deblyn Prado

    (@deblynprado)

    Our developers just did a quick video demonstrating how to get the info that we need.

    Please take a look and let me know once you have this data https://i.bordoni.me/8LubyAEG

    Cheers,

    @deblynprado Sorry for the late reply. Had some busy days.

    Here is my recording: https://youtu.be/PFG3LRlg5co

    Some people thought it occurs when changing theme specific options like disabling headers, footers or titles. So during the recording I left all such options on the Neve theme I use untouched. Sometimes it succeeds when you don’t change theme specific options but mostly it fails. It always fails when you change such settings.

    As it happen with different themes it doesn’t seem to be theme specific.

    The issue is also specific to The Events Calendar due the fact the issue disappears when disabling the The Events Calendar plugin.

    Here is the request data:

    {
    	"content": "<!-- wp:paragraph -->\n<p>This is a testpage without modifying Neve theme options.</p>\n<!-- /wp:paragraph -->",
    	"id": 1119,
    	"meta": {
    		"_EventAllDay": false,
    		"_EventCost": "",
    		"_EventCostDescription": "",
    		"_EventCurrencyPosition": "",
    		"_EventCurrencySymbol": "",
    		"_EventDateTimeSeparator": "",
    		"_EventEndDate": "",
    		"_EventEndDateUTC": "",
    		"_EventOrganizerID": [],
    		"_EventShowMap": false,
    		"_EventShowMapLink": false,
    		"_EventStartDate": "",
    		"_EventStartDateUTC": "",
    		"_EventTimeRangeSeparator": "",
    		"_EventTimezone": "",
    		"_EventURL": "",
    		"_EventVenueID": 0,
    		"_non_existing_meta": true,
    		"_OrganizerEmail": "",
    		"_OrganizerPhone": "",
    		"_OrganizerWebsite": "",
    		"_VenueAddress": "",
    		"_VenueCity": "",
    		"_VenueCountry": "",
    		"_VenueLat": "",
    		"_VenueLng": "",
    		"_VenuePhone": "",
    		"_VenueProvince": "",
    		"_VenueStateProvince": "",
    		"_VenueURL": "",
    		"_VenueZip": "",
    		"neve_meta_author_avatar": "",
    		"neve_meta_container": "",
    		"neve_meta_content_width": 100,
    		"neve_meta_disable_footer": "",
    		"neve_meta_disable_header": "",
    		"neve_meta_disable_title": "",
    		"neve_meta_enable_content_width": "on",
    		"neve_meta_sidebar": "full-width",
    		"neve_meta_title_alignment": "",
    		"neve_post_elements_order": "",
    		"qubely_global_settings": "",
    		"qubely_interactions": ""
    	},
    	"status": "publish",
    	"title": "Testpage March 3rd, 2021 - 10:44 AM"
    }

    Please pay attention to the line
    "_EventOrganizerID": [],
    When I edit the line at the request into
    "_EventOrganizerID": "",
    and resend the request manually everything saves in the correct manner.

    The response data to above request without editing the request is:

    {
    	"code": "rest_meta_database_error",
    	"message": "Kon metawaarde niet verwijderen uit de database.",
    	"data": {
    		"key": "_EventOrganizerID",
    		"status": 500
    	}
    }

    @joennuh thank you so much for your invaluable contribution. It’s truly appreciated!

    After digging deeper, so fare we are able to identify 2 use cases where this issue is happening:

    1. When using “ugly” permalinks (changing to something like Postname fixes it)
    2. With certain themes when Block editor and our plugin are activated

    In both cases, this is a result of code that was updated in WordPress 5.7
    We’ll issue a fix as soon as possible!

    In the meantime, the only quick workaround would be to downgrade to WP 5.6.2 (which is far from awesome) but would buy you some time.

    We would like to thank everyone in this thread for bringing this to our attention and we are terribly sorry for the inconvenience.

    cc: @mrwaim @donbowman

    @geoffbel You’re welcome.

    I have chosen to create a static page with a calendar. In my case the amount of items for a few months is doable. I don’t like to downgrade WordPress.

    I don’t understand case 1:

    When using “ugly” permalinks (changing to something like Postname fixes it)

    but I guess that case doesn’t apply to my situation. My case specifically seems to be an incompatibility with my Neve theme.

    Hope to see the fix soon. Keep up the good work! ??

    @joennuh

    You are 100% right, the first use case doesn’t apply to your situation ??
    There are a handful of themes where this is happening and we are definitely fixing this ASAP.

    Stay tuned!
    Geoff

    Plugin Support Jaime

    (@jaimemarchwinski)

    Hi @joennuh @mrwaim @donbowman

    We are releasing a fix for this issue in our upcoming release!

    In the meantime, the following extension should resolve the issue:
    https://d.pr/f/kwJtTc

    Let us know if that helps!

    Thanks,
    Jaime

    @jaimemarchwinski Sorry for the late reply. Was quite busy at the past week.
    I tried your hotfix at my testing environment and it seems to work correctly.
    I hope the complete fix will be released soon in order to be able to remove the seperate hotfix.

    Plugin Support Jaime

    (@jaimemarchwinski)

    Hi @joennuh

    Glad to hear that worked for you! The complete fix will be released next week, in which case you can remove that hotfix.

    Have a wonderful day!

    Thanks,
    Jaime

    @jaimemarchwinski Thank you for the update of the progress. As the hotfix works nice and I’d like to use The Events Calendar as soon as possible at the production website I’ll install it on the production website too for the time being.

    @joennuh @mrwaim @donbowman

    Hi!

    I just wanted to let you all know that we’ve recently pushed an update that should resolve your issue regarding the block editor.

    Please update all your plugins and test to see if your issue is indeed resolved.

    If it’s not, let us know!

    Thanks!

    -James

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘500 error on page updates’ is closed to new replies.