Changeset 12403 for trunk/wp-includes/functions.php

Timestamp:

12/15/2009 04:00:23 PM (15 years ago)

Author:

ryan

Message:

Use ON DUPLICATE KEY UPDATE when inserting options to avoid duplicate entry errors. fixes #11437

File:

• trunk/wp-includes/functions.php (modified) (1 diff)

trunk/wp-includes/functions.php

@@ -601 +601 @@
     }
 
-    $wpdb->insert($wpdb->options, array('option_name' => $name, 'option_value' => $value, 'autoload' => $autoload) );
+    $wpdb->query( $wpdb->prepare( "INSERT INTO `$wpdb->options` (`option_name`, `option_value`, `autoload`) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)", $name, $value, $autoload ) );
 
     do_action( "add_option_{$name}", $name, $value );