Abbington Mega Template [Support Thread]

**g2ktcf** · 22 May 2013, 03:57 PM

Originally Posted by g2ktcf

Nope...that did not do it...still looking. I am now comparing the sql patch file to what is actually in my dbase

From what I can tell...I cannot find any anomalies in the database. I have followed the SQL line by line, entry by entry and they are all in the database.

Any thoughts on where to look now? The admin file was installed in the correct place.

**g2ktcf** · 22 May 2013, 04:10 PM

Originally Posted by g2ktcf

From what I can tell...I cannot find any anomalies in the database. I have followed the SQL line by line, entry by entry and they are all in the database.

Any thoughts on where to look now? The admin file was installed in the correct place.

All files are loaded in the right places.
Database appears to have ALL the correct entries as loaded by the sql file
There are NO logs being filed as php errors......

I am now officially stumped

**g2ktcf** · 22 May 2013, 04:18 PM

Originally Posted by g2ktcf

All files are loaded in the right places.
Database appears to have ALL the correct entries as loaded by the sql file
There are NO logs being filed as php errors......

I am now officially stumped

The joys of trying to do this multiple times.....I got some entries with a configuration_id of 31 and some with a configuration_id of 36. Once I combed through ALL the entries and made this all 36...it worked.....

**DivaVocals** · 22 May 2013, 06:06 PM

There is an issue with the install SQL in this template module that could cause issues in other parts of Zen Cart.. The issue is very well documented here:

http://www.zen-cart.com/showthread.p...178#post993178

This post reads as follows:

Originally Posted by swguy

Here's the root cause. Some mods which have SQL scripts that create new configuration groups will do an initial cleanup like this: (this example is taken from Printable Price List)

SELECT @pricelistid:=configuration_group_id
FROM configuration_group WHERE configuration_group_title="Printable Price-list";

DELETE FROM configuration WHERE configuration_group_id=@pricelistid;
DELETE FROM configuration_group WHERE configuration_group_id=@pricelistid;

This works and does not cause problems. However, other mods set an initial value for the variable. This causes the problem. The example below is taken from Fual Slimbox:

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Fual Slimbox';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

If you run this sql, and you have not previously installed Fual Slimbox, you will delete the 2 prefix and product options type select values which are in group 0.

Again, I believe the proper way to resolve this is to change the Zen Cart sql to put these items in a non-zero group.

I did a quick check of some mods I have downloaded (not an exhaustive list), and the following mods have this bug:

FAQ Manager
Google Analytics
SimpleSEOURL
Fual Slimbox
Super Orders
Integrated COWOA
Google Sitemap Admin
Autoresponder+
Return Authorization
Recover Cart Sales
CaptchaTTF and Hide Phone
Amazon Exporter
Fast and Easy Checkout
Testimonial Manager
Ty Package Tracker

Lines 1-7 of the SQL file in this package contains this kind of incorrectly formated code.

For those having issues, the following SQL should work:

Code:

SELECT @AbbingtonMegaconfig:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Abbington Mega'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @AbbingtonMegaconfig;
DELETE FROM configuration_group WHERE configuration_group_id = @AbbingtonMegaconfig;
INSERT INTO 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 @AbbingtonMegaconfig=last_insert_id();
UPDATE configuration_group SET sort_order = @AbbingtonMegaconfig WHERE configuration_group_id = @AbbingtonMegaconfig;
INSERT INTO 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', @AbbingtonMegaconfig, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, ' Effect', 'SLIDE_JS_EFFECT', 'slide', 'Effect used for image transition', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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.', @AbbingtonMegaconfig, 66, NOW(), NULL, NULL),
(NULL, 'Mega Menu Status', 'MENU_STATUS', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 88, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Mega Menu Categories', 'MENU_CATEGORIES', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 122, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Mega Menu Information', 'MENU_INFORMATION', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 155, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Footer Telephone Number', 'FOOTER_TELEPHONE_NUMBER', '555-555-5555', 'Footer Telephone Number', @AbbingtonMegaconfig, 166, NOW(), NULL, NULL),
(NULL, 'Footer Telephone Number Status', 'FOOTER_TELEPHONE_NUMBER_STATUS', 'true', 'Footer Telephone Number Status', @AbbingtonMegaconfig, 177, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Banner Display Groups - Slide1', 'SHOW_BANNERS_GROUP_SET9', 'slide1', 'Slide 1', @AbbingtonMegaconfig, 200, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide2', 'SHOW_BANNERS_GROUP_SET10', 'slide2', 'Slide 2', @AbbingtonMegaconfig, 201, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide3', 'SHOW_BANNERS_GROUP_SET11', 'slide3', 'Slide 3', @AbbingtonMegaconfig, 202, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide4', 'SHOW_BANNERS_GROUP_SET12', 'slide4', 'Slide 4', @AbbingtonMegaconfig, 203, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide5', 'SHOW_BANNERS_GROUP_SET13', 'slide5', 'Slide 5', @AbbingtonMegaconfig, 204, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderPayments', 'SHOW_BANNERS_GROUP_SET16', 'headerpayments', 'Header Payments', @AbbingtonMegaconfig, 206, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderAboutUs', 'SHOW_BANNERS_GROUP_SET14', 'headeraboutus', 'Header About Us', @AbbingtonMegaconfig, 214, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterBlog', 'SHOW_BANNERS_GROUP_SET17', 'footerblog', 'Footer Blog', @AbbingtonMegaconfig, 215, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterGoogle', 'SHOW_BANNERS_GROUP_SET18', 'footergoogle', 'Footer Google', @AbbingtonMegaconfig, 216, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPinterest', 'SHOW_BANNERS_GROUP_SET19', 'footerpinterest', 'Footer Pinterest', @AbbingtonMegaconfig, 217, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterYoutube', 'SHOW_BANNERS_GROUP_SET20', 'footeryoutube', 'Footer Youtube', @AbbingtonMegaconfig, 218, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterTwitter', 'SHOW_BANNERS_GROUP_SET21', 'footertwitter', 'Footer Twitter', @AbbingtonMegaconfig, 219, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterFacebook', 'SHOW_BANNERS_GROUP_SET22', 'footerfacebook', 'Footer Facebook', @AbbingtonMegaconfig, 220, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPayments', 'SHOW_BANNERS_GROUP_SET23', 'footerpayments', 'Footer Payments', @AbbingtonMegaconfig, 221, NOW(), NULL, NULL);
# Register the configuration page for Admin Access Control
INSERT IGNORE INTO 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=',@AbbingtonMegaconfig),'configuration','Y',@AbbingtonMegaconfig);
INSERT INTO `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 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 - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'columns', 
               'Select the layout style:<br />Each product can be listed in its own row (rows option)
                or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, 
                now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');
INSERT INTO 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 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 configuration SET configuration_value = 100 WHERE configuration_key = 'IMAGE_SHOPPING_CART_WIDTH';
UPDATE configuration SET configuration_value = 200 WHERE configuration_key = 'IMAGE_SHOPPING_CART_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_LEFT_STATUS';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_RIGHT_STATUS';
UPDATE configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_RIGHT';
UPDATE configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_RIGHT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'CATEGORIES_TABS_STATUS';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'DEFINE_BREADCRUMB_STATUS';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_CUSTOMER_GREETING';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_FOOTER_IP';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_ALPHA_SORTER';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS_TOP';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_DESCRIPTION';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_FILTER';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'PRODUCT_INFO_CATEGORIES_IMAGE_STATUS';
UPDATE configuration SET configuration_value = true WHERE configuration_key = 'USE_SPLIT_LOGIN_MODE';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'EZPAGES_STATUS_HEADER';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'EZPAGES_STATUS_FOOTER';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_SHOPPING_CART_UPDATE';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_SHOPPING_CART_DELETE';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_NEW_PRODUCTS';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS';
UPDATE configuration SET configuration_value = 3 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_UPCOMING';

**g2ktcf** · 23 May 2013, 02:44 AM

okay...the sql listed above looks like a replacement for the installation SQL. I have verified that my local installation has this problem as

Code:

SELECT * FROM configuration WHERE configuration_group_id =0

gives me an empty set. So do I run this...?

Code:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

Then run the new code in the previous post?

**picaflor-azul** · 23 May 2013, 03:05 PM

Originally Posted by DivaVocals

There is an issue with the install SQL in this template module that could cause issues in other parts of Zen Cart.. The issue is very well documented here:

http://www.zen-cart.com/showthread.p...178#post993178

This post reads as follows:

Lines 1-7 of the SQL file in this package contains this kind of incorrectly formated code.

For those having issues, the following SQL should work:

Code:

SELECT @AbbingtonMegaconfig:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Abbington Mega'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @AbbingtonMegaconfig;
DELETE FROM configuration_group WHERE configuration_group_id = @AbbingtonMegaconfig;
INSERT INTO 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 @AbbingtonMegaconfig=last_insert_id();
UPDATE configuration_group SET sort_order = @AbbingtonMegaconfig WHERE configuration_group_id = @AbbingtonMegaconfig;
INSERT INTO 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', @AbbingtonMegaconfig, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, ' Effect', 'SLIDE_JS_EFFECT', 'slide', 'Effect used for image transition', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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.', @AbbingtonMegaconfig, 66, NOW(), NULL, NULL),
(NULL, 'Mega Menu Status', 'MENU_STATUS', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 88, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Mega Menu Categories', 'MENU_CATEGORIES', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 122, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Mega Menu Information', 'MENU_INFORMATION', 'true', 'True to show, False to hide', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 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', @AbbingtonMegaconfig, 155, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Footer Telephone Number', 'FOOTER_TELEPHONE_NUMBER', '555-555-5555', 'Footer Telephone Number', @AbbingtonMegaconfig, 166, NOW(), NULL, NULL),
(NULL, 'Footer Telephone Number Status', 'FOOTER_TELEPHONE_NUMBER_STATUS', 'true', 'Footer Telephone Number Status', @AbbingtonMegaconfig, 177, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Banner Display Groups - Slide1', 'SHOW_BANNERS_GROUP_SET9', 'slide1', 'Slide 1', @AbbingtonMegaconfig, 200, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide2', 'SHOW_BANNERS_GROUP_SET10', 'slide2', 'Slide 2', @AbbingtonMegaconfig, 201, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide3', 'SHOW_BANNERS_GROUP_SET11', 'slide3', 'Slide 3', @AbbingtonMegaconfig, 202, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide4', 'SHOW_BANNERS_GROUP_SET12', 'slide4', 'Slide 4', @AbbingtonMegaconfig, 203, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - Slide5', 'SHOW_BANNERS_GROUP_SET13', 'slide5', 'Slide 5', @AbbingtonMegaconfig, 204, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderPayments', 'SHOW_BANNERS_GROUP_SET16', 'headerpayments', 'Header Payments', @AbbingtonMegaconfig, 206, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - HeaderAboutUs', 'SHOW_BANNERS_GROUP_SET14', 'headeraboutus', 'Header About Us', @AbbingtonMegaconfig, 214, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterBlog', 'SHOW_BANNERS_GROUP_SET17', 'footerblog', 'Footer Blog', @AbbingtonMegaconfig, 215, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterGoogle', 'SHOW_BANNERS_GROUP_SET18', 'footergoogle', 'Footer Google', @AbbingtonMegaconfig, 216, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPinterest', 'SHOW_BANNERS_GROUP_SET19', 'footerpinterest', 'Footer Pinterest', @AbbingtonMegaconfig, 217, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterYoutube', 'SHOW_BANNERS_GROUP_SET20', 'footeryoutube', 'Footer Youtube', @AbbingtonMegaconfig, 218, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterTwitter', 'SHOW_BANNERS_GROUP_SET21', 'footertwitter', 'Footer Twitter', @AbbingtonMegaconfig, 219, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterFacebook', 'SHOW_BANNERS_GROUP_SET22', 'footerfacebook', 'Footer Facebook', @AbbingtonMegaconfig, 220, NOW(), NULL, NULL),
(NULL, 'Banner Display Groups - FooterPayments', 'SHOW_BANNERS_GROUP_SET23', 'footerpayments', 'Footer Payments', @AbbingtonMegaconfig, 221, NOW(), NULL, NULL);
# Register the configuration page for Admin Access Control
INSERT IGNORE INTO 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=',@AbbingtonMegaconfig),'configuration','Y',@AbbingtonMegaconfig);
INSERT INTO `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 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 - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'columns', 
               'Select the layout style:<br />Each product can be listed in its own row (rows option)
                or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, 
                now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');
INSERT INTO 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 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 configuration SET configuration_value = 100 WHERE configuration_key = 'IMAGE_SHOPPING_CART_WIDTH';
UPDATE configuration SET configuration_value = 200 WHERE configuration_key = 'IMAGE_SHOPPING_CART_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_NEW_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'CATEGORY_ICON_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_TOP_WIDTH';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 150 WHERE configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_LEFT_STATUS';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'COLUMN_RIGHT_STATUS';
UPDATE configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '185px' WHERE configuration_key = 'COLUMN_WIDTH_RIGHT';
UPDATE configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '180px' WHERE configuration_key = 'BOX_WIDTH_RIGHT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'CATEGORIES_TABS_STATUS';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'DEFINE_BREADCRUMB_STATUS';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_CUSTOMER_GREETING';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_FOOTER_IP';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_ALPHA_SORTER';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS';
UPDATE configuration SET configuration_value = false WHERE configuration_key = 'PRODUCT_LIST_CATEGORIES_IMAGE_STATUS_TOP';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_DESCRIPTION';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'PRODUCT_LIST_FILTER';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'PRODUCT_INFO_CATEGORIES_IMAGE_STATUS';
UPDATE configuration SET configuration_value = true WHERE configuration_key = 'USE_SPLIT_LOGIN_MODE';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'EZPAGES_STATUS_HEADER';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'EZPAGES_STATUS_FOOTER';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_SHOPPING_CART_UPDATE';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_SHOPPING_CART_DELETE';
UPDATE configuration SET configuration_value = 1 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_NEW_PRODUCTS';
UPDATE configuration SET configuration_value = 2 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS';
UPDATE configuration SET configuration_value = 3 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS';
UPDATE configuration SET configuration_value = 0 WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_UPCOMING';

When I submitted the module, the sofware guy fixed the sql patch to include a check against configuration group id 0. Is this what you are referring to?

Thanks,

Anne

**DivaVocals** · 23 May 2013, 05:09 PM

Originally Posted by picaflor-azul

When I submitted the module, the sofware guy fixed the sql patch to include a check against configuration group id 0. Is this what you are referring to?

Thanks,

Anne

It's line 1 in the SQL is what is being pointed out as being and issue in the post I referenced:

SET @configuration_group_id=0;SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Abbington Mega'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

Ever since being made aware that this is an issue, I am always on the lookout for similar SQL in any mod I use and change accordingly.. The modified SQL is what I ran.. Hope I didn't mis-step by sharing it..

I thought that it might help g2ktcf.

**g2ktcf** · 23 May 2013, 06:29 PM

well it certainly showed me other issues I do have. My problem was more like trying to install Abbington Mega 1.1...then 3.1 without first cleaning out 1.1 properly...at least that is what I think. I actually had four full sets of records in the banners table from Abbington Mega so you can see how messed up it was. Luckily I do know my way around databases and was able to locate the problem in the data. Once I made all the configuration IDs the same, everything worked like a charm.

**picaflor-azul** · 24 May 2013, 02:39 PM

Originally Posted by DivaVocals

It's line 1 in the SQL is what is being pointed out as being and issue in the post I referenced:

Ever since being made aware that this is an issue, I am always on the lookout for similar SQL in any mod I use and change accordingly.. The modified SQL is what I ran.. Hope I didn't mis-step by sharing it..

I thought that it might help g2ktcf.

No, thank you very much for pointing this out. I do want to correct any problems in the templates. I just need to do some research and understand the problem so that I can submit a fixed update ;)

Thanks,

Anne

**picaflor-azul** · 23 May 2013, 02:59 PM

Originally Posted by g2ktcf

From what I can tell...I cannot find any anomalies in the database. I have followed the SQL line by line, entry by entry and they are all in the database.

Any thoughts on where to look now? The admin file was installed in the correct place.

What version of zen cart are you running?

Thanks,

Anne

Thread: Abbington Mega Template [Support Thread]

Thread Tools

Search Thread

Display

Hybrid View

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Re: Abbington Mega Template Support Thread

Similar Threads

Lavender Template Support Thread

v154 Abbington Mega 5.3 template not displaying properly

Rustic Template Support Thread

Turpy Template Support Thread

DigitalShop Template Support Thread

Posting Permissions