Support

February 28, 2022 at 6:48 pm

Reporting a bug to the Event Espresso Technical Support Team.

The cause of the error

Event Espresso title of event:

3/4 Blacklight “Tree of Life Paint Party!” Class-6:30pm $36

The issue

It seems you may not be escaping the quotes or converting smart quotes to html entities in the Event Espresso titles causing a issue with the database.

The recreation

The issue likely stems from copying the quotes from a Microsoft Word document or website in which the quotes are already “smart quotes”. Regular quotes themselves may or may not be an issue but have not fully tested this.

The error

Notice: WPDB Error “WordPress database error: Processing the value for the following field failed: LOG_message. The supplied value may be too long or contains invalid data.” while running wpdb method “insert” with arguments [“wp_esp_log”,{“LOG_time”:”2022-02-28 18:49:14″,”OBJ_ID”:”13261″,”OBJ_type”:”Transaction”,”LOG_type”:”gateway”,”LOG_message”:”a:2:{s:26:\”Payment page token request\”;a:6:{s:7:\”headers\”;O:42:\”Requests_Utility_CaseInsensitiveDictionary\”:1:{s:7:\”\u0000*\u0000data\”;a:14:{s:13:\”cache-control\”;s:29:\”no-cache, no-store, max-age=0\”;s:6:\”pragma\”;s:8:\”no-cache\”;s:12:\”content-type\”;s:31:\”application\/json; charset=utf-8\”;s:7:\”expires\”;s:2:\”-1\”;s:25:\”x-opnet-transaction-trace\”;s:51:\”b580216a-2963-4b4f-8ca3-333735a43ed3-12736-44330409\”;s:32:\”access-control-allow-credentials\”;s:4:\”true\”;s:28:\”access-control-allow-headers\”;s:68:\”x-requested-with,cache-control,content-type,origin,method,SOAPAction\”;s:28:\”access-control-allow-methods\”;s:20:\”PUT,OPTIONS,POST in /[redacted].com/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 2400

Notice: WPDB AGAIN: Error “WordPress database error: Processing the value for the following field failed: LOG_message. The supplied value may be too long or contains invalid data.” while running the same method and arguments as before. Automatically attempting to fix EE Addons DB in /[redacted].com/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 2400

The display error

If you have a credit card method available, particularly for Authorize.net, it will display the error.

See this link for the screenshot:
https://my.bincdn.com/1117/smartquote-error-ee4.png

The solution

3/4 Blacklight Tree of Life Paint Party! Class-6:30pm $36~2

Removing the quotes solved the issue.

Knowing this, I’m sure the EE4 development team can implement a better solution for those who might want to use quotes or smart quotes.