[wp-trac] [WordPress Trac] #11649: Upgrades Fail Because of [11883]

[WordPress Trac]

#11649: Upgrades Fail Because of [11883]
-----------------------------+----------------------------------------------
 Reporter:  miqrogroove      |        Owner:        
     Type:  defect (bug)     |       Status:  closed
 Priority:  normal           |    Milestone:  2.9.1 
Component:  Upgrade/Install  |      Version:  2.9   
 Severity:  blocker          |   Resolution:  fixed 
 Keywords:  has-patch        |  
-----------------------------+----------------------------------------------

Comment(by miqrogroove):

 > How does 11649-proper.patch preserve the option with the highest ID?

 That's what the WHERE condition is for.

 > Please tell that the admin

 No worries.  I was just distinguishing between a workaround and a full
 solution.

 > was it just guessed that the query is the cause of the problem

 Most PHP configurations have a memory limit around 32 MB, so a
 pre_schema_upgrade() design that tries to calculate the Cartesian product
 of every ID in the options table and convert them all to strings is only
 going to work on relatively small tables.

 > Patch fixes 11649-proper.patch

 Thanks, yeah I only got as far as testing with some quickie bogus column
 names.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/11649#comment:9>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software