Table 'newsletter_subscribers' doesn't exist

[romy]

help with this:
1146 Table 'che1022804243726.bsk_newsletter_subscribers' doesn't exist
in:
[select 'Dear' as customers_firstname, 'Subscriber' as customers_lastname, email as customers_email_address from bsk_newsletter_subscribers ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

on gv_mail.php
any way to fix this with upgrading. have version 1.3.9
Thanks

[DrByte]

Your system thinks it has the newsletter-subscribe plugin installed, but the table is missing.

So, either finish removing the plugin completely, or finish installing it completely.

[romy]

I installed this in my SQL and need a uninstall for this but not sure the correct way to write it.
the fist couple lines. I want it to read default...
should be define('DB_PREFIX', 'zen_'); f Im correct.

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


--
-- Database: `raindrop`
--


-- --------------------------------------------------------


--
-- Table structure for table `bsk_newsletter_subscribers`
--


DROP TABLE IF EXISTS `bsk_newsletter_subscribers`;


CREATE TABLE IF NOT EXISTS `bsk_newsletter_subscribers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(1000) NOT NULL COMMENT 'email of subscribers to newsletter from home page',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


--
-- Dumping data for table `query_builder`
--


INSERT IGNORE INTO `query_builder` (`query_category`, `query_name`, `query_description`, `query_string`, `query_keys_list`) VALUES
('email,newsletters', 'Subscribers from Home Page', 'Newsletter subscribers from Home Page', 'select ''Dear'' as customers_firstname, ''Subscriber'' as customers_lastname, email as customers_email_address from bsk_newsletter_subscribers', '');


--
-- create Theme Options under Back office > Tools
--


INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('bskThemeOptions', 'BOX_BSK_THEME_OPTIONS', 'FILENAME_BSK_THEME_OPTIONS_TPL', '', 'tools', 'Y', 200);


--
-- table for theme options
--


DROP TABLE IF EXISTS `bsk_theme_options`;


CREATE TABLE IF NOT EXISTS `bsk_theme_options` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(1000) NOT NULL,
`val` varchar(10000) NOT NULL,
`description` varchar(10000) DEFAULT NULL,
PRIMARY KEY (`id`)
);


INSERT INTO `bsk_theme_options` (`name`, `val`, `description`) VALUES ('bkgColor', 'rgba(0,0,0,0)', 'the background color'),
('bkgImg', '1', 'the background image, if value is 0 than use the root/images/raindrop/bkgimg.(jpg, png, gif) else use the file pattern{value}.png from root/includes/templates/raindrop/images/bkg/'),
('linksColor', '#08C', 'the color of general links'),
('priceColor', '#ff4848', 'color for displaying price'),
('add2CartBkgColor', '#167db2', 'background color for add to cart button'),
('add2CartTextColor', '#fff', 'text color for add to cart button'),
('btnImpBkgColor', '#167db2', 'background color for button important (.rdBtn)'),
('btnImpTextColor', '#fff', 'text color for button important (.rdBtn)'),
('fnbBkgColor', '#000', 'background color for first navigation bar'),
('fnbLinksColor', '#fff', 'links color for first navigation bar'),
('fnbLinksHoverColor', '#fff', 'links hover color for first navigation bar'),
('fnbShowLogo', '1', 'show logo on first navigation bar'),
('fnbShowSearch', '1', 'show search on first navigation bar'),
('snbBkgColor', '#fff', 'background color for secondary top navigation bar'),
('snbShowLogo', '0', 'show logo on secondary top navigation bar'),
('snbMenuLinksColor', '#167db2', 'menu links color'),
('snbLineHoverColor', '#ff4848', 'menu line hover color'),
('snbSubmenuBkgColor', '#fff', 'background color for submenu'),
('snbSubmenuBkgHoverColor', '#fff', 'background hover color for submenu'),
('snbSubmenuLinksColor', '#167db2', 'links color for submenu'),
('snbCartLinksColor', '#000', 'link color for cart in secondary top navigation bar'),
('sectionTabColor', '#000', 'title or tab color in content section'),
('sectionTabLineColor', '#000', 'bottom border for title or tab in content section'),
('footerDelimColor', '#000', 'top border for footer'),
('footerBkgColor', 'rgba(0,0,0,0.1)', 'footer background color'),
('footerTitleColor', '#000', 'title color for sections in footer'),
('footerTextColor', '#000', 'text color in footer'),
('footerLinksColor', '#0088cc', 'links color in footer'),
('footerLinksHoverColor', '#005580', 'links hover color in footer'),
('advBlocksEnable', '1', 'display adv blocks'),
('advLink1', '#', 'link for first adv block'),
('advLink1Tab', '0', 'open link for first adv block in new tab'),
('advLink2', '#', 'link for second adv block'),
('advLink2Tab', '0', 'open link for second adv block in new tab'),
('advLink3', '#', 'link for third adv block'),
('advLink3Tab', '0', 'open link for third adv block in new tab');


--
-- create Slider under Back office > Tools
--


INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('bskSlider', 'BOX_BSK_SLIDER', 'FILENAME_BSK_SLIDER_TPL', '', 'tools', 'Y', 210);


--
-- table for slider
--


DROP TABLE IF EXISTS `bsk_slides`;


CREATE TABLE IF NOT EXISTS `bsk_slides` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`img` varchar(1000) NOT NULL,
`text` varchar(1000) NOT NULL,
`link` varchar(10000) DEFAULT NULL,
PRIMARY KEY (`id`)
);


--
-- table for slider options
--


DROP TABLE IF EXISTS `bsk_slider_options`;


CREATE TABLE IF NOT EXISTS `bsk_slider_options` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(1000) NOT NULL,
`val` varchar(1000) NOT NULL,
`description` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
);


INSERT INTO `bsk_slider_options` (`name`, `val`) VALUES ('enableThumbs', '0');