Newport Eco Template Support Thread

evindr:

Hi,

I've just installed this template onto Zen Cart 1.3.9. When I try to patch the database, I get the following error.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE zen_zen_upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help would be greatly appreciated.
Thanks
Steve

You need to replace the:

TYPE=MyISAM

width:

ENGINE=MyISAM

Thanks,

Anne

patyork:

Hi,

First off, great template as always.

Secondly, I was wondering what the simplest way would be to increase the maximum Logo size. Without getting to deep into the code, it looks like the maximum Logo width should actually be about 730 px w/o interfering with the Search div.

Thanks for any replies. If I figure it out, I will edit this post.
Pat

The max width of the template is 980px so if you want to make the logo this size you might need to reposition the search box and promo ad.

Thanks,

Anne

picaflor-azul:

You need to replace the:

TYPE=MyISAM

> 
> width:
> 
> ```
ENGINE=MyISAM

Thanks,

Anne

Nowhere in the patch code is there ```
TYPE=MyISAM

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', 'rows', 'Select the layout style:
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?
0= Link ON, Define Text OFF
1= Link ON, Define Text ON
2= Link OFF, Define Text ON
3= Link OFF, Define Text OFF', 25, 59, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

Thanks
Steve

evindr:

Nowhere in the patch code is there ```
TYPE=MyISAM

> 
> ```
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', 'rows', 'Select the layout style:
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?
0= Link ON, Define Text OFF
1= Link ON, Define Text ON
2= Link OFF, Define Text ON
3= Link OFF, Define Text OFF', 25, 59, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),'); 

Thanks
Steve

That is strange that it is not in the code and you would get an error for it? Maybe you were trying to add a different patch and got that error.

Thanks,

Anne

picaflor-azul:

That is strange that it is not in the code and you would get an error for it? Maybe you were trying to add a different patch and got that error.

Thanks,

Anne

Nope, direct copy and paste from the readme.html file supplied with the template. Also tried using the .sql file supplied to patch as well, same thing.
Thanks
Steve

evindr:

Nope, direct copy and paste from the readme.html file supplied with the template. Also tried using the .sql file supplied to patch as well, same thing.
Thanks
Steve

I just checked both the sql patch and sql code in the readme file and neither have the TYPE=MyISAM. I have no idea why you would have gotten the error with the patch or readme code.

Thanks,

Anne

Very nice template.. just working my way through it..
a couple of things..
I would like to change the overall color scheme.. are all the site colors located in the stylesheet.css file?

and I would like to show a grid of products in the main body of the index page, in the location where the zen ad and the text is now.. is there an easy to pull that off?
thanks

When I post a link in facebook it places "Newport Eco" before the product description. Where is it getting this from and how can I remove it?

Thanks.

kharmachanic:

Very nice template.. just working my way through it..
a couple of things..
I would like to change the overall color scheme.. are all the site colors located in the stylesheet.css file?

and I would like to show a grid of products in the main body of the index page, in the location where the zen ad and the text is now.. is there an easy to pull that off?
thanks

You can find all of the stylesheets in the includes/templates/newport_eco/css directory.

What products do you want to show? New products, products from one category?

Thanks,

Anne

bizzybetty:

When I post a link in facebook it places "Newport Eco" before the product description. Where is it getting this from and how can I remove it?

Thanks.

My guess is that you have not yet changed your site title in includes/languages/english/newport_eco/meta_tags.php

Thanks,

Anne

Howdy,

I've got your template mostly running the way I like it on my local machine but I can't seem to suppress the "Connect With Us" and "Customer Service" menu items. I've added the following to the mega menu stylesheet:

/Don't Show These!/
.aboutus-image{display:none;}
.quicklinks-li{display:none;}
.manufacturers-li{display:none;}
.customer_service-li{display:none;}
.contactus-li{display:none;}
.aboutus-li{display:none;}
.hfacebook{display:none;}
.htwitter{display:none;}
.hyoutube{display:none;}
.hpinterest{display:none;}
.hgoogle{display:none;}
.hblog{display:none;}

But they still show up. I've also tried:
.customerservice-li{display:none;} and .customer-service-li{display:none;} with no luck.

Any ideas?

Thanks for your work on the free templates and support!

erix:

Howdy,

I've got your template mostly running the way I like it on my local machine but I can't seem to suppress the "Connect With Us" and "Customer Service" menu items. I've added the following to the mega menu stylesheet:

/Don't Show These!/
.aboutus-image{display:none;}
.quicklinks-li{display:none;}
.manufacturers-li{display:none;}
.customer_service-li{display:none;}
.contactus-li{display:none;}
.aboutus-li{display:none;}
.hfacebook{display:none;}
.htwitter{display:none;}
.hyoutube{display:none;}
.hpinterest{display:none;}
.hgoogle{display:none;}
.hblog{display:none;}

But they still show up. I've also tried:
.customerservice-li{display:none;} and .customer-service-li{display:none;} with no luck.

Any ideas?

Thanks for your work on the free templates and support!

You need to add this to the bottom of your stylesheet_mega_menu.css file:

.customer_service, .connect-li{display:none;}

Thanks,

Anne

That did it! Thanks!

erix:

That did it! Thanks!

I am happy to hear that ;-)

Thanks,

Anne

Aloha,
I am using the Newport_eco template. and so far I have been able to find my way around most things.
Nice template .. Btw
one thing.. I am trying to remove the hyperlinks that are placed on each product in the Product list - and align the products to the left.

The cart I am working on is GroceriesAhead

I tried this (I tried changing it in both of the product_listing.php files):

I thought I had found it in the includes/modules/product_listing.php file (and in the includes/modules/newport_eco/product_listing.php) :

line 193: $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']) . '">' . $listing->fields['products_name'] . '</a></h3><div class="listingDescription">' . zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listi ng->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION) . '</div>';

Changed to :
line 193: $lc_text = '<h3 class="itemTitle"> ' . $listing->fields['products_name'] . '</h3><div class="listingDescription">' . zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listi ng->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION) . '</div>';

That did not seem to work
any ideas where to find this change?

as a side note:
This customer is requesting all elements of pricing, images, anything other than the product name and quantity order box. All those removed in the products, e-mails, cart, etc..
No standard shipping, just a single "drop off fee"
and total color and background changes with a mobile friendly version.
I am working slowly through all the other elements, (hoping I can get all the references gone - particularly Shipping and Price).

Thanks for any assistance you can offer
Kharmachanic out..

kharmachanic:

Aloha,
I am using the Newport_eco template. and so far I have been able to find my way around most things.
Nice template .. Btw
one thing.. I am trying to remove the hyperlinks that are placed on each product in the Product list - and align the products to the left.

The cart I am working on is GroceriesAhead

I tried this (I tried changing it in both of the product_listing.php files):

I thought I had found it in the includes/modules/product_listing.php file (and in the includes/modules/newport_eco/product_listing.php) :

line 193: $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']) . '">' . $listing->fields['products_name'] . '</a></h3><div class="listingDescription">' . zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listi ng->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION) . '</div>';

Changed to :
line 193: $lc_text = '<h3 class="itemTitle"> ' . $listing->fields['products_name'] . '</h3><div class="listingDescription">' . zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listi ng->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION) . '</div>';

That did not seem to work
any ideas where to find this change?

as a side note:
This customer is requesting all elements of pricing, images, anything other than the product name and quantity order box. All those removed in the products, e-mails, cart, etc..
No standard shipping, just a single "drop off fee"
and total color and background changes with a mobile friendly version.
I am working slowly through all the other elements, (hoping I can get all the references gone - particularly Shipping and Price).

Thanks for any assistance you can offer
Kharmachanic out..

This is not a template specific question. I can tell you that you should only be editing files in the template override directory.

Thanks,

Anne

Aloha
I posted the question in the regular area and the replys seemed indicate that the product_listing.php files was the one I needed to edit of which there is one in the newport_eco template. If I am looking in the wrong place, can you tell me which file actually creates this information, as the regular threads directed me to the template overrides.

Thanks for the reply..

kharmachanic:

Aloha
I posted the question in the regular area and the replys seemed indicate that the product_listing.php files was the one I needed to edit of which there is one in the newport_eco template. If I am looking in the wrong place, can you tell me which file actually creates this information, as the regular threads directed me to the template overrides.

Thanks for the reply..

Yes, that is the file that you will edit.

Thanks,

Anne

Hello,

Is this possible to add not only the url but also a description to the slider on the main page for example some kind of advertisement text.

BR
Artur

Arcicorci:

Hello,

Is this possible to add not only the url but also a description to the slider on the main page for example some kind of advertisement text.

BR
Artur

I would take a look at the javascript file to see if this is possible. You can also visit the sliders authors site for more information. Check the readme.html file for the credit linkl.

Thanks,

Anne