[wp-trac] [WordPress Trac] #32315: $wpdb->insert fails without error msg

WordPress Trac noreply at wordpress.org
Thu Mar 17 03:15:40 UTC 2022

#32315: $wpdb->insert fails without error msg
 Reporter:  dlt101                           |       Owner:  hellofromTonya
     Type:  defect (bug)                     |      Status:  closed
 Priority:  normal                           |   Milestone:  5.9
Component:  Database                         |     Version:  4.2.1
 Severity:  normal                           |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests commit  |     Focuses:

Comment (by psufan):

 I can confirm 5.9.2 produces the new error message. Not really happy about
 it however haha. Had a user enter a string with ampersand which silently
 failed and now produces this error. Is ampersand a mysql reserved
 character? 5.9.2 will not insert() a string with an ampersand in it. What
 other characters are not allowed with insert()? We didn't agree to
 truncate the data and insert anyway?

 WordPress database error: Processing the value for the following field
 failed: [COLUMN]. The supplied value may be too long or contains invalid

Ticket URL: <https://core.trac.wordpress.org/ticket/32315#comment:97>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list