[wp-trac] [WordPress Trac] #32314: Database error on update to 4.2.2 from 4.2.1

[WordPress Trac]

#32314: Database error on update to 4.2.2 from 4.2.1
--------------------------+------------------------------
 Reporter:  milleronic    |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.2.2
 Severity:  minor         |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by charlestonsw):

 [[http://www.storelocatorplus.com/wordpress-dbdelta-better-in-4-2-not-yet-
 perfect/|This dbDelta article]] I posted on my website tonight may help.

 I was running into key name issues as well after the 4.2 upgrade and
 various dbDelta() changes.   The short version, make sure you create your
 SQL statement EXACTLY as dbDelta wants it.   Double space after the
 keyword "PRIMARY KEY" and single space after each element of "KEY
 <key_name> (<column_name>);

--
Ticket URL: <https://core.trac.wordpress.org/ticket/32314#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform