Query to find events where cost is not a number so can fix Warning: number_forma

[Craig]

Our websites are having the same issue as a lot of other folks, I would like you to provide an SQL query so I can find any events that have a cost that is not a number, so I can fix all of them. I see some folks are typing in FREE I have thousands of events to comb through and the query would save hours if not days.

Thanks in advance.

[Andras]

Hello Craig,

Thanks for reaching out and I’m really sorry about this issue.

This query will list you the Event Costs for all the events.

SELECT * FROM wp_postmeta WHERE meta_key="_EventCost"

You can do easy database updates if you have one or two phrases repeating (e.x. donation), like this:

UPDATE wp_postmeta SET meta_value="0" WHERE  meta_key="_EventCost" AND meta_value="donation";

Good news is that a fix has been developed for this and if all goes well then it should be released later this week.

If you need a workaround solution – other than the database – until then, then downgrading to the previous version is the best solution at the moment.

Hang in there, fix is on its way.

I am going to set the status of this ticket to “pending fix” and we will update it once the fix is released. If you have ticked the “notify” checkbox, then you’ll get an email about it.

Cheers,
Andras

[Courtney]

Hey there Craig

We’ve just released an update that should fix this bug. You can read more about it at http://m.tri.be/19tp. Please update your plugins and let us know if you are still experiencing this or if we can close out this ticket.

Note: We suggest testing updates on a staging server (https://theeventscalendar.com/knowledgebase/creating-using-wordpress-staging-site/).

Thanks
Courtney 🙂

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts