Zen Cart Logo
Forums / Addon Templates / Abbington Mega Template [Support Thread]

Abbington Mega Template [Support Thread]

Views: 147,380

Results 601 to 620 of 1,017
22 May 2013, 2:36 PM
#601
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Abbington Mega Template [Support Thread]

g2ktcf:

I am guilty of not searching this thread completely. I do have a table prefix...I will see if I can fix that.

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

22 May 2013, 2:57 PM
#602
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

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.

22 May 2013, 3:10 PM
#603
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

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

22 May 2013, 3:18 PM
#604
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

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.....

22 May 2013, 5:06 PM
#605
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Abbington Mega Template [Support Thread]

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:

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:

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';
23 May 2013, 1:44 AM
#606
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

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

SELECT * FROM configuration WHERE configuration_group_id =0 

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

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?

23 May 2013, 1:59 PM
#607
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

djohanaa:

My website is https://www.creativewallquotes.com

I went to the link but do not see a zen cart.

Thanks,

Anne

23 May 2013, 1:59 PM
#608
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

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

23 May 2013, 2:05 PM
#609
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

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:

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
23 May 2013, 2:14 PM
#610
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

picaflor-azul:

What version of zen cart are you running?

Thanks,

Anne

Anne,

I found the problem when I found different group ids for the template. This was done is 1.5.1. I do I still have the issue that DivaVocals pointed out so I just want to understand what I need to do to fix that.

Thanks
Chris

23 May 2013, 4:09 PM
#611
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Abbington Mega Template [Support Thread]

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..:smile: I thought that it might help g2ktcf.

23 May 2013, 5:29 PM
#612
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

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.

23 May 2013, 5:46 PM
#613
afterhour avatar

afterhour

Zen Follower

Join Date:
Dec 2007
Posts:
92
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

Hi

I'm getting a w3 validation error on my front page, it's been a long day and I was hoping a fresh pair of eyes could help

validation Output: 1 Error

Error Line 356, Column 21: end tag for "ul" which is not finished

		      		      </ul>

✉

Most likely, you nested tags and closed them in the wrong order. For example <p><em>...</p> is not acceptable, as <em> must be closed before <p>. Acceptable nesting is: <p><em>...</em></p>

Another possibility is that you used an element which requires a child element that you did not include. Hence the parent element is "not finished", not complete. For instance, in HTML the <head> element must contain a <title> child element, lists require appropriate list items (<ul> and <ol> require <li>; <dl> requires <dt> and <dd>), and so on.

	<div class="col_1">
                 <h3>Customers</h3>
                 <ul>
		                	<li><a href="https://www.allgoodideas.co.uk/Log_In">Log In</a></li>
            	<li><a href="https://www.allgoodideas.co.uk/index.php?main_page=create_account">Create Account</a></li>
            	                    	<li><a href="http://www.allgoodideas.co.uk/Contact_Us">Contact Us</a></li>
                                    	<li><a href="http://www.allgoodideas.co.uk/Shipping_Shopping_And_Returns">Shipping & Returns</a></li>
                                                            	<li><a href="http://www.allgoodideas.co.uk/Privacy_And_Payments">Privacy Notice</a></li>
                                                            	<li><a href="http://www.allgoodideas.co.uk/Conditions_Of_Use">Conditions of Use</a></li>
                                         </ul>   
             </div>

        	 <div class="col_1">
                  <h3>Useful Links</h3>
	      <ul> 
	      		      </ul>
        	 </div>
       </div>

</li><!-- eof information -->

which I presume is from tpl_mega_menu.php line 235 onwards

        	 <div class="col_1">
                  <h3><?php echo TITLE_EZ_PAGES; ?></h3>
	      <ul> 
	      <?php require(DIR_WS_MODULES . 'sideboxes/' . $template_dir . '/' . 'ezpages_drop_menu.php'); ?>
	      </ul>
        	 </div>
       </div>

</li><!-- eof information -->

I just can't see what is producing the error though??? any constructive help much appreciated.

Simon Goodall
https://www.allgoodideas.co.uk

23 May 2013, 8:10 PM
#614
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Abbington Mega Template [Support Thread]

okay, I want to add the SiteLock link to my page and I found an old thread that had some info. However, it advised to find tpl_footer_menu.php for the additions. But this file seems to have changed. Where can I add this link?

24 May 2013, 1:39 PM
#615
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

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..:smile: 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

24 May 2013, 1:40 PM
#616
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

g2ktcf:

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.

I am happy that you figured out the problem and posted your solution to help others.

Thanks,

Anne

24 May 2013, 1:43 PM
#617
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

AfterHouR:

Hi

I'm getting a w3 validation error on my front page, it's been a long day and I was hoping a fresh pair of eyes could help

validation Output: 1 Error

Error Line 356, Column 21: end tag for "ul" which is not finished

		      		      </ul>

✉

Most likely, you nested tags and closed them in the wrong order. For example <p><em>...</p> is not acceptable, as <em> must be closed before <p>. Acceptable nesting is: <p><em>...</em></p>

Another possibility is that you used an element which requires a child element that you did not include. Hence the parent element is "not finished", not complete. For instance, in HTML the <head> element must contain a <title> child element, lists require appropriate list items (<ul> and <ol> require <li>; <dl> requires <dt> and <dd>), and so on.

  <div class="col_1">
                 <h3>Customers</h3>
                 <ul>
  	                	<li><a href="https://www.allgoodideas.co.uk/Log_In">Log In</a></li>
            	<li><a href="https://www.allgoodideas.co.uk/index.php?main_page=create_account">Create Account</a></li>
            	                    	<li><a href="http://www.allgoodideas.co.uk/Contact_Us">Contact Us</a></li>
                                    	<li><a href="http://www.allgoodideas.co.uk/Shipping_Shopping_And_Returns">Shipping & Returns</a></li>
                                                            	<li><a href="http://www.allgoodideas.co.uk/Privacy_And_Payments">Privacy Notice</a></li>
                                                            	<li><a href="http://www.allgoodideas.co.uk/Conditions_Of_Use">Conditions of Use</a></li>
                                         </ul>   
             </div>

        	 <div class="col_1">
                  <h3>Useful Links</h3>
        <ul> 
        		      </ul>
        	 </div>
       </div>

  </li><!-- eof information -->

which I presume is from tpl_mega_menu.php line 235 onwards

        	 <div class="col_1">
                  <h3><?php echo TITLE_EZ_PAGES; ?></h3>
        <ul> 
        <?php require(DIR_WS_MODULES . 'sideboxes/' . $template_dir . '/' . 'ezpages_drop_menu.php'); ?>
        </ul>
        	 </div>
       </div>

  </li><!-- eof information -->

I just can't see what is producing the error though??? any constructive help much appreciated.

Simon Goodall
https://www.allgoodideas.co.uk

If you post a link to the site I can take a look.

Thanks,

Anne

24 May 2013, 1:43 PM
#618
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

g2ktcf:

okay, I want to add the SiteLock link to my page and I found an old thread that had some info. However, it advised to find tpl_footer_menu.php for the additions. But this file seems to have changed. Where can I add this link?

You can add it to that file or the tpl_footer.php file.

Thanks,

Anne

24 May 2013, 4:17 PM
#619
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Abbington Mega Template [Support Thread]

picaflor-azul:

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
Oh good.. I didn't want to step on your toes at all!!:smile:

Check out the suggested SQL I posted.. it should address the issue.. It's the SQL I ran when installing your template..

25 May 2013, 12:44 PM
#620
picaflor_azul avatar

picaflor_azul

Totally Zenned

Join Date:
Jul 2009
Location:
picaflor-azul.com
Posts:
6,940
Plugin Contributions:
28

Re: Abbington Mega Template [Support Thread]

DivaVocals:

Oh good.. I didn't want to step on your toes at all!!:smile:

Check out the suggested SQL I posted.. it should address the issue.. It's the SQL I ran when installing your template..

I will do it ;)

Thanks,

Anne