[wp-trac] [WordPress Trac] #4780: $table_prefix should not be encoded in table_names.

WordPress Trac wp-trac at lists.automattic.com
Sun Jun 26 20:51:41 UTC 2011


#4780: $table_prefix should not be encoded in table_names.
----------------------------+------------------------
 Reporter:  docwhat         |       Owner:  anonymous
     Type:  defect (bug)    |      Status:  closed
 Priority:  normal          |   Milestone:
Component:  Administration  |     Version:
 Severity:  normal          |  Resolution:  invalid
 Keywords:                  |
----------------------------+------------------------

Comment (by nacin):

 That's a disaster waiting to happen. If you actually want to run
 production and development running off two databases, you're going to want
 to actually run them off two databases. Otherwise database-wide operations
 like SHOW TABLES or repair maintenance might affect both installs.

 WordPress keys numerous things off the table prefix that it then stores in
 usermeta or options. You found one -- dashboard_quick_press_last_post_id,
 which uses the user options API to do so. There's also important ones like
 {$prefix}capabilities in the options table.

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


More information about the wp-trac mailing list