Abbington Mega Template [Support Thread]

[picaflor-azul]

I am a new Zen Cart user, I have just installed Zen Cart and have decided on a template to use. I have followed all the install tutorials and I am able to get template to display. My issue is although the template is showing, I dont see the template name in the configuration list in my Zen Cart admin console. I've tried to reinstall the template but still no luck. I am completely open to the fact that I may have done something wrong but for the life of me can't figure out what. Could someone help me out. Thanks!

Link to site is here: http://www.desotosystemsflags.com/index.php

Attachment 12510

above is a screen shop of the part of the tutorial I'm referring to, see how the Abbington Mega temp shows under "EZ pages", it's not in my Zen Cart. Specifically I'm trying to edit the "mega menu" on the page and according to the tutorial that button is how you do it. Other then that button I don't see any other way to modify that menu bar without changing the actual code. Hope this makes sense.

Did you upload the sql patch?

Thanks, Anne

[picaflor-azul]

My template configurations is showing up blank in admin. SOMEONE PLEASE HELP!

Sounds like you did not upload the sql patch completely.

Thanks,

Anne

[kkjoseph]

Ok I kinda figured but when I try to upload it again all I get it and error message.

"WARNING: An Error occurred, please refresh the page and try again."

So I tried it in PHPMyAdmin and its just giving me another error.

So can you give a step by step guide on how to fix this

[JW1212]

Did you upload the sql patch?

Thanks, Anne

Good question, I thought I did with no issues. I then tried following the install tutorial again and when I got to the upload sql patch part I get an error "WARNING: An Error occurred, please refresh the page and try again." I then pulled the log file and here is the log entry:

"[17-May-2013 09:22:10] PHP Fatal error: 1062uplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen' ::
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"),');
in /home4/desotosy/public_html/includes/classes/db/mysql/query_factory.php on line 120


Any idea where I went wrong. Thanks for the help I've been banging my head against the wall.

[shags38]

Hi Anne, - I have 7 sites now using this great template - am having a niggly issue with one though - the Meta Tags for Page Title / Site Tagline, so includes/languages/english/abbington_mega/meta_tags, whereby regardless of whether I put the whole Title in page title or only some then the rest in site tagline (as ZC standard does) it will only ever show up the first 3 words of the text (which happens to be the domain name) - I am trying to utilize the allowable 64 characters or close to.

This is using 1.5.1 - I launched 3 sites at the same time and there are no issues with the other two which are in fact copies of the site in question (different TLD's) which I then went into to change Meta info - no problems. Result is in browser when in ZC admin and in Google search the Mega Title I want will not show up (I can somewhat understand the Google Search Title as they can sometimes alter to suit themselves) but it should read what has been set in browser when in admin as it does with other sites. I even went to includes/languages/english/meta_tags and changed the standard ZC file to read the same as Abbington on the off chance - no effect.

Any ideas?

cheers,
Mike

site is www.sterlingsilverrings.com.au

[picaflor-azul]

Good question, I thought I did with no issues. I then tried following the install tutorial again and when I got to the upload sql patch part I get an error "WARNING: An Error occurred, please refresh the page and try again." I then pulled the log file and here is the log entry:

"[17-May-2013 09:22:10] PHP Fatal error: 1062uplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen' ::
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"),');
in /home4/desotosy/public_html/includes/classes/db/mysql/query_factory.php on line 120


Any idea where I went wrong. Thanks for the help I've been banging my head against the wall.

If you already have the product layout grid module installed and have run the sql patch for that module or any of our other templates installed, you will omit that part of the sql patch:

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

Thanks,

Anne

[picaflor-azul]

Hi Anne, - I have 7 sites now using this great template - am having a niggly issue with one though - the Meta Tags for Page Title / Site Tagline, so includes/languages/english/abbington_mega/meta_tags, whereby regardless of whether I put the whole Title in page title or only some then the rest in site tagline (as ZC standard does) it will only ever show up the first 3 words of the text (which happens to be the domain name) - I am trying to utilize the allowable 64 characters or close to.

This is using 1.5.1 - I launched 3 sites at the same time and there are no issues with the other two which are in fact copies of the site in question (different TLD's) which I then went into to change Meta info - no problems. Result is in browser when in ZC admin and in Google search the Mega Title I want will not show up (I can somewhat understand the Google Search Title as they can sometimes alter to suit themselves) but it should read what has been set in browser when in admin as it does with other sites. I even went to includes/languages/english/meta_tags and changed the standard ZC file to read the same as Abbington on the off chance - no effect.

Any ideas?

cheers,
Mike

site is www.sterlingsilverrings.com.au

This is not a template specific problem. I would recommend doing a search on the forum to see if there is already an answer to the question.

Thanks,

Anne

[JW1212]

If you already have the product layout grid module installed and have run the sql patch for that module or any of our other templates installed, you will omit that part of the sql patch:

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

Thanks,

Anne

Sorry Anne but I don't really understand your response. So, i must remove the column layout grid module with the code you provided and re-run patch?

-Jason

[picaflor-azul]

Sorry Anne but I don't really understand your response. So, i must remove the column layout grid module with the code you provided and re-run patch?

-Jason

No, remove the code I quoted from the sql patch for the template and then run the sql patch again.

Thanks,

Anne

[JW1212]

No, remove the code I quoted from the sql patch for the template and then run the sql patch again.

Thanks,

Anne

I removed the entries from the SQL patch and ran it again, this time it ran with no visible errors but alas still no access to Abbington Mega admin . I am nearing wits end with this, I have made most of the changes to the template that i need http://www.desotosystemsflags.com/index.php but I'm starting to think I absolutely need admin console to change footer and mega menu config/layout. I was even going to scrap it and load an older version of your template that did not use the admin console but could not find one. My head is going to explode and I've killed way to much time on this piece, seems like this should be really simple. If I were to email you for a quote would you be able to get the admin console to load for me? Thanks Anne.