[wp-trac] [WordPress Trac] #20821: DB Restore

[WordPress Trac]

#20821: DB Restore
--------------------------+---------------------------
 Reporter:  Juggy69       |       Owner:  Stuart Giles
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  General       |     Version:  3.3.2
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |
--------------------------+---------------------------
Changes (by SergeyBiryukov):

 * status:  new => closed
 * resolution:   => invalid
 * severity:  critical => normal
 * milestone:  Awaiting Review =>


Comment:

 Looks like there's something wrong with your DB backup tool. Those values
 shouldn't be NULL indeed.

 The default value for those columns is an empty string: [[BR]]
 http://core.trac.wordpress.org/browser/tags/3.3.2/wp-
 admin/includes/schema.php#L112

 When I export `wp_links` table with phpMyAdmin, the query contains empty
 strings instead of NULL:
 {{{
 INSERT INTO `wp_links` VALUES
 (1, 'http://codex.wordpress.org/', 'Documentation', '', '', '', 'Y', 1, 0,
 '0000-00-00 00:00:00', '', '', ''),
 }}}

 Since it's clearly a support issue, please try the support forums:
 http://wordpress.org/support/

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