Newport Eco Template Support Thread

[picaflor-azul]

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

[picaflor-azul]

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

[evindr]

You need to replace the:

TYPE=MyISAM

width:

ENGINE=MyISAM

Thanks,

Anne

Nowhere in the patch code is there

TYPE=MyISAM

to change. I've simply copy and pasted the patch from the readme file that came with the template. Which is:

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

[picaflor-azul]

Nowhere in the patch code is there

TYPE=MyISAM

to change. I've simply copy and pasted the patch from the readme file that came with the template. Which is:

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

[evindr]

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

[picaflor-azul]

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

[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

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

[picaflor-azul]

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

[picaflor-azul]

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