Zen Cart Logo
Forums / All Other Contributions/Addons / Table 'newsletter_subscribers' doesn't exist

Table 'newsletter_subscribers' doesn't exist

Views: 872

Results 1 to 3 of 3
17 Jun 2013, 10:52 PM
#1
romy avatar

romy

New Zenner

Join Date:
May 2007
Location:
york, pa
Posts:
98
Plugin Contributions:
0

Table 'newsletter_subscribers' doesn't exist

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

17 Jun 2013, 10:59 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Table 'newsletter_subscribers' doesn't exist

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.

18 Jun 2013, 12:42 AM
#3
romy avatar

romy

New Zenner

Join Date:
May 2007
Location:
york, pa
Posts:
98
Plugin Contributions:
0

Re: Table 'newsletter_subscribers' doesn't exist

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');