I am working on a plugin. And I want to create a table via the plugin. So I am trying execute following SQL Query.
global $wpdb; $createSQL = " CREATE TABLE `". $wpdb->prefix ."_book_ratings` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `book_id` bigint(20) UNSIGNED NOT NULL, `rating` float(3.1) UNSIGNED NOT NULL, `user_ip` varchar(32) NOT NULL ) ENGINE=InnoDB" . $wpdb->get_charset_collate() . " AUTO_INCREMENT=1; "; require( ABSPATH . '/wp-admin/includes/upgrade.php' ); dbDelta( $createSQL );
When I deactivate the plugin and when re-activating the plugin I am getting following error.
The plugin generated 464 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.
Please let me know where I am wrong.