picaflor-azul:
Try adding the prefix to the table names in the sql patch:
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM V_configuration_group
WHERE configuration_group_title= 'Abbington Mega'
LIMIT 1;
DELETE FROM v_configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM v_configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
INSERT INTO v_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Abbington Mega', 'Set Abbington Mega Template Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE v_configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO v_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Slides JS Slideshow', 'SLIDES_JS_STATUS', 'true', 'Activate Slides JS Slideshow', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, ' Effect', 'SLIDE_JS_EFFECT', 'slide', 'Effect used for image transition', @configuration_group_id, 22, NOW(), NULL, 'zen_cfg_select_option(array('slide', 'fade'),'),
(NULL, 'Play', 'SLIDES_JS_PLAY', '5000', 'Autoplay slideshow, a positive number will set to true and be the time between slide animation in milliseconds', @configuration_group_id, 55, NOW(), NULL, NULL),
(NULL, 'Pause', 'SLIDES_JS_PAUSE', '5000', 'Pause slideshow on click of next/prev or pagination. A positive number will set to true and be the time of pause in milliseconds.', @configuration_group_id, 66, NOW(), NULL, NULL),
(NULL, 'Mega Menu Status', 'MENU_STATUS', 'true', 'True to show, False to hide', @configuration_group_id, 77, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Quick Links', 'MENU_QUICK_LINKS_STATUS', 'true', 'True to show, False to hide', @configuration_group_id, 88, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Categories', 'MENU_CATEGORIES', 'true', 'True to show, False to hide', @configuration_group_id, 99, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Shop by Brand', 'MENU_SHOP_BY_BRAND', 'true', 'True to show, False to hide', @configuration_group_id, 111, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu About Us', 'MENU_ABOUT_US', 'true', 'True to show, False to hide', @configuration_group_id, 122, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Information', 'MENU_INFORMATION', 'true', 'True to show, False to hide', @configuration_group_id, 133, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Contact Us', 'MENU_CONTACT_US', 'true', 'True to show, False to hide', @configuration_group_id, 144, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Mega Menu Customer Service', 'MENU_CUSTOMER_SERVICE', 'true', 'True to show, False to hide', @configuration_group_id, 155, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Footer Telephone Number', 'FOOTER_TELEPHONE_NUMBER', '555-555-5555', 'Footer Telephone Number', @configuration_group_id, 166, NOW(), NULL, NULL),
(NULL, 'Footer Telephone Number Status', 'FOOTER_TELEPHONE_NUMBER_STATUS', 'true', 'Footer Telephone Number Status', @configuration_group_id, 177, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Banner Display Groups - Slide1', 'SHOW_BANNERS_GROUP_SET9', 'slide1', 'Slide 1', @configuration_group_id, 200, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide2', 'SHOW_BANNERS_GROUP_SET10', 'slide2', 'Slide 2', @configuration_group_id, 201, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide3', 'SHOW_BANNERS_GROUP_SET11', 'slide3', 'Slide 3', @configuration_group_id, 202, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide4', 'SHOW_BANNERS_GROUP_SET12', 'slide4', 'Slide 4', @configuration_group_id, 203, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide5', 'SHOW_BANNERS_GROUP_SET13', 'slide5', 'Slide 5', @configuration_group_id, 204, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderPayments', 'SHOW_BANNERS_GROUP_SET16', 'headerpayments', 'Header Payments', @configuration_group_id, 206, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderAboutUs', 'SHOW_BANNERS_GROUP_SET14', 'headeraboutus', 'Header About Us', @configuration_group_id, 214, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterBlog', 'SHOW_BANNERS_GROUP_SET17', 'footerblog', 'Footer Blog', @configuration_group_id, 215, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterGoogle', 'SHOW_BANNERS_GROUP_SET18', 'footergoogle', 'Footer Google', @configuration_group_id, 216, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPinterest', 'SHOW_BANNERS_GROUP_SET19', 'footerpinterest', 'Footer Pinterest', @configuration_group_id, 217, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterYoutube', 'SHOW_BANNERS_GROUP_SET20', 'footeryoutube', 'Footer Youtube', @configuration_group_id, 218, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterTwitter', 'SHOW_BANNERS_GROUP_SET21', 'footertwitter', 'Footer Twitter', @configuration_group_id, 219, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterFacebook', 'SHOW_BANNERS_GROUP_SET22', 'footerfacebook', 'Footer Facebook', @configuration_group_id, 220, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPayments', 'SHOW_BANNERS_GROUP_SET23', 'footerpayments', 'Footer Payments', @configuration_group_id, 221, NOW(), NULL, NULL);
Register the configuration page for Admin Access Control
INSERT IGNORE INTO v_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('abbingtonmega','BOX_CONFIGURATION_ABBINGTON_MEGA','FILENAME_CONFIGURATION',CONCAT('gID=',@configuration_group_id),'configuration','Y',@configuration_group_id);
INSERT INTO v_banners (banners_id, banners_title, banners_url, banners_image, banners_group, banners_html_text, expires_impressions, expires_date, date_scheduled, date_added, date_status_change, status, banners_open_new_windows, banners_on_ssl, banners_sort_order) VALUES
('', 'Slide 1', 'http://www.picaflor-azul.com/index.php?main_page=index&cPath=32', 'banners/slide1.jpg', 'slide1', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '11'),
('', 'Slide 2', 'http://www.picaflor-azul.com/index.php?main_page=page&id=43', 'banners/slide2.jpg', 'slide2', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '22'),
('', 'Slide 3', 'http://www.facebook.com/Custom.Zen.Cart.Design', 'banners/slide3.jpg', 'slide3', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '33'),
('', 'Slide 4', 'http://www.picaflor-azul.com/index.php?main_page=product_free_shipping_info&cPath=159&products_id=14857', 'banners/slide4.jpg', 'slide4', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '44'),
('', 'Slide 5', 'http://www.picaflor-azul.com/support', 'banners/slide5.jpg', 'slide5', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '55'),
('', 'Header Payments Image', '', 'banners/payments.png', 'headerpayments', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '0', '1', '66'),
('', 'Header About Us Image', 'index.php?main_page=about_us', 'banners/aboutus.png', 'headeraboutus', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '0', '1', '77'),
('', 'Footer Blog Icon', 'http://www.picaflor-azul.com/blog/', 'banners/blog.png', 'footerblog', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '88'),
('', 'Footer Google Plus Icon', 'https://plus.google.com/113609090217058276980/posts', 'banners/google.png', 'footergoogle', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '99'),
('', 'Footer Pinterest Icon', 'http://pinterest.com/picaflorazul/', 'banners/pinterest.png', 'footerpinterest', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '111'),
('', 'Footer Youtube Icon', 'http://www.youtube.com/user/ZenCartEasyHelp', 'banners/youtube.png', 'footeryoutube', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '122'),
('', 'Footer Twitter Icon', 'https://twitter.com/picaflorazul', 'banners/twitter.png', 'footertwitter', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '133'),
('', 'Footer Facebook Icon', 'https://www.facebook.com/Custom.Zen.Cart.Design', 'banners/facebook.png', 'footerfacebook', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '144'),
('', 'Footer-Payments Image', '', 'banners/paypal.png', 'footerpayments', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '0', '1', '155');
The following is used only to remove the column layout grid module:
#delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');
INSERT INTO v_configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Product Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3',
'Select the number of columns of products to show in each row in the product listing.
The default setting is 3.', '8', '41', NULL, now(), NULL, NULL);
INSERT INTO v_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('Define About Us Status', 'DEFINE_ABOUT_US_STATUS', '1', 'Enable the Defined About Us Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 59, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
UPDATE v_configuration SET configuration_value = 100 WHERE configuration_key = 'IMAGE_SHOPPING_CART_WIDTH';
UPDATE v_configuration SET configuration_value = 200 WHERE configuration_key = 'IMAGE_SHOPPING_CART_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE v_configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_LEFT_STATUS';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_RIGHT_STATUS';
UPDATE v_configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_LEFT';
UPDATE v_configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_RIGHT';
UPDATE v_configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_LEFT';
UPDATE v_configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_RIGHT';
UPDATE v_configuration SET configuration_value = '0' WHERE configuration_key = 'CATEGORIES_TABS_STATUS';
UPDATE v_configuration SET configuration_value = 2 WHERE configuration_key = 'DEFINE_BREADCRUMB_STATUS';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_CUSTOMER_GREETING';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_FOOTER_IP';
UPDATE v_configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_ALPHA_SORTER';
UPDATE v_configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS';
UPDATE v_configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS_TOP';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_DESCRIPTION';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_FILTER';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'PRODUCT_INFO_CATEGORIES_IMAGE_STATUS';
UPDATE v_configuration SET configuration_value = true WHERE configuration_key = 'USE_SPLIT_LOGIN_MODE';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'EZPAGES_STATUS_HEADER';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'EZPAGES_STATUS_FOOTER';
UPDATE v_configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_SHOPPING_CART_UPDATE';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_SHOPPING_CART_DELETE';
UPDATE v_configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_NEW_PRODUCTS';
UPDATE v_configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS';
UPDATE v_configuration SET configuration_value = 3 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS';
UPDATE v_configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_UPCOMING';
>
> Thanks,
>
> Anne
I tried this, it's still blank. :(
