Screen Options are per blog in 3.0

[ryan]

In 3.0 meta box state is saved to usermeta keys of the form wp_trunk_closedpostboxes_dashboard and wp_trunk_meta-box-hidden_dashboard. In 2.9 these are closedpostboxes_dashboard and metaboxhidden_dashboard. This causes preference loss when upgrading to 3.0 and makes screen options per blog.

[ryan]

Note the dashes are now present in meta-box-hidden.

[ryan]

closed-postboxes in admin-ajax.php switched from update_usermeta() to update_user_option() without adding the global flag.

[ryan]

(In [14112]) Make post box states a global user preference. see #13032

[ryan]

(In [14113]) Change meta-box-hidden to metaboxhidden to adjust for new key sanitization rules and maintain the same key name as 2.9. fixes #13032

[wpmuguru]

Since the metabox options were saved in the options table during the beta 1, we should clear those out because they override the settings in the usermeta.

[wpmuguru]

(In [14212]) remove alpha-beta1 metabox preferences from options table, see #13032

[wpmuguru]

(In [14213]) remove from usermeta table in r14212, see #13032

[jamescollins]

Replying to wpmuguru:

(In [14213]) remove from usermeta table in r14212, see #13032

In a MySQL like query, the _ character is similar to the % character (except it matches any single character). Ref: ​http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

A while ago in WPMU, a like query that used $wpdb->base_prefix caused lots of trouble (​http://trac.mu.wordpress.org/ticket/727).

I think we're ok in this case, but I'm just wanting to make sure a similar problem doesn't exist here.

[dd32]

(In [14218]) Fix DB upgrade kickoff for removal of usermeta fields. See r14212, r14213, see #13032

[nacin]

Replying to jamescollins:

In a MySQL like query, the _ character is similar to the % character (except it matches any single character).

A while ago in WPMU, a like query that used $wpdb->base_prefix caused lots of trouble (​http://trac.mu.wordpress.org/ticket/727).

Looks like wpmuguru caught that in #13099, [14215].

[ryan]

(In [14235]) Fix back compat for hidden columns and layout screen options. Change meta baox order to be per user, rather than per blog. This breaks back compat for box order but the previous behavior was wrong. see #13032

[ryan]

These other ones also need to be cleaned during upgrade.

[scribu]

Related: #13152

[scribu]

Currently, metabox order is not respected on the post editing screen.

[scribu]

Also related: #12439

[ryan]

Cleaning the bad options during upgrade should fix metabox order no being respected. Marking bad option removal as a blocker.

[ryan]

(In [14596]) Delete more bad screen options from usermeta. like_escape() blog prefix. fixes #13032