Plugin generating unexpected output - on WP mysql dump import

Question

I am developing my plugin and I am getting this error:

The plugin generated 357954 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

Now my activation hook looks like this:

    function _activate() {
    global $wpdb;
    require_once(ABSPATH . 'wp-content/plugins/my-plugin/sql.php'); 
    require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); 
    dbDelta($sql); 
}

and sql.php which does import like this:

$sql .= $wpdb->query($wpdb->prepare("CREATE TABLE IF NOT EXISTS `wp_car_makes` (
  `makes_id` int(11) NOT NULL AUTO_INCREMENT,
  `makes_name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`makes_id`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=350170")); 
$sql .= $wpdb->query($wpdb->prepare("INSERT INTO `wp_car_makes`
(`makes_id`,`makes_name`) VALUES 
(1, 'Acura'), 
(2, 'Alfa Romeo'),
.... and it has a 300k+ inserts
(350169, 'Yugo');
"));

Now - everything is imported properly in DB, and plugin is working OK, it's just that this error is annoying - and I don't have white-spaces after opening/closing tags etc...

Any tips why is this happening ?

Best practice - don't load your plugin files with hard-coded paths. Use require_once( plugin_dir_path( __file__ ) . 'sql.php' ); — TheDeadMedic
– TheDeadMedic, Commented May 8, 2014 at 9:59

Chittaranjan · Accepted Answer · 2014-05-08 09:10:09Z

1

Its not that $wpdb->query does not need $wpdb->prepare(), it's because of not using $wpdb->prepare() in a correct manner. In your case $wpdb->prepare() never received any values which it must.

Please refer to the Codex for details about using $wpdb->prepare().

answered May 8, 2014 at 9:10

Chittaranjan

2,48423 silver badges18 bronze badges

Add a comment |

Peter · Accepted Answer · 2014-05-09 11:45:21Z

OK, sorry for this, but I wasn't reading codex properly.... Anyway for all of you who have same issue query really ~~doesn't need $wpdb->prepare() part as this is properly formatted mysql dump~~->[I wasn't using prepare() properly !], so query like this triggers no errors:

$sql .= $wpdb->query("CREATE TABLE IF NOT EXISTS `wp_car_makes` 
(`makes_id` int(11) NOT NULL AUTO_INCREMENT,
`makes_name` varchar(60) NOT NULL DEFAULT '',
PRIMARY KEY (`makes_id`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 
AUTO_INCREMENT=350170"); 

$sql .= $wpdb->query("INSERT INTO `wp_car_makes`
(`makes_id`,`makes_name`) VALUES 
(1, 'Acura'), 
(2, 'Alfa Romeo'),
.... and it has a 300k+ inserts
(350169, 'Yugo');
");

Stack Exchange Network

Plugin generating unexpected output - on WP mysql dump import

2 Answers 2

Your Answer

Hot Network Questions

Plugin generating unexpected output - on WP mysql dump import

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions