Sheffield Blue Template Support Thread

This is the about_us.sql that came with the package.

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
('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''),');

I checked my database and performed a search for the "Define About Us Status' in the zen_configuration table and it is not there?

I got a green bar at the top of the page when I ran the patch so I don't know why the db didn't get updated.

I do have a "zen_" prefix on all of my tables. Could that be the problem for it not installing?

If the values above are correct, I'll manually insert them into zen_configuration. But, I need to know if they are correct.

Suggestions?

I manually added the 'about_us.sql' to zen_configuration and it is showing up in admin.

I manually inserted the "about_us.sql" into zen_configuration and it appears to be functioning...db changes when I make changes in admin.

As suspected...apparently, none of the patches installed. Although, I did get a green bar and the number of commands processed when I ran them in the SQL patch app in admin.

I checked the first 4 "delete" functions in clg_install.sql against the db and those commands did not delete what they were supposed to.

There is nothing in your instructions about not running the patches if a prefix on the table names exist...unless I missed something.

Now, what are my options?

Manually process all of the .sql patches?

Change all the .sql patches table names to have a "zen_" prefix?

Either way, it's going to be a lot of work unless you have a link to ready made .sql patches with a zen_ prefix on the tables.

mikeel100:

As suspected...apparently, none of the patches installed. Although, I did get a green bar and the number of commands processed when I ran them in the SQL patch app in admin.

I checked the first 4 "delete" functions in clg_install.sql against the db and those commands did not delete what they were supposed to.

There is nothing in your instructions about not running the patches if a prefix on the table names exist...unless I missed something.

Now, what are my options?

Manually process all of the .sql patches?

Change all the .sql patches table names to have a "zen_" prefix?

Either way, it's going to be a lot of work unless you have a link to ready made .sql patches with a zen_ prefix on the tables.

If the patches are run through the admin's->tools->instal sql patches, then the table prefixes are added automatically. Isuming by the description ofall the "checking" you did, that you were in myphpadmin.

This is also partially why the install package used from this site,suggests to install with no table prefix as the packages are designed to exclude a prefix and allow "universal" installation.

My apologiies... I assumed the patches didn't install after checking the clg_install.sql delete functions against the database.

The INSERTS below the DELETES in clg_install.sql put the same KEY names back into the db.

Yes, I'm leery about proceeding since the "about_us.sql" failed to install.

mc12345678:

If the patches are run through the admin's->tools->instal sql patches, then the table prefixes are added automatically. Isuming by the description ofall the "checking" you did, that you were in myphpadmin.

This is also partially why the install package used from this site,suggests to install with no table prefix as the packages are designed to exclude a prefix and allow "universal" installation.

The GoDaddy installation doesn't give the option leave the prefix off during installation...

I didn't use the prefix when I manually installed ZC on my local machine because I do remember reading somewhere that ZC recommends not using it.

I shall not proceed with uploading the Sheffield Blue files until I manually verify that all of the actions required by the patch .sql files have been implemented into the DB.

mikeel100:

My apologiies... I assumed the patches didn't install after checking the clg_install.sql delete functions against the database.

The INSERTS below the DELETES in clg_install.sql put the same KEY names back into the db.

Yes, I'm leery about proceeding since the "about_us.sql" failed to install.

So, a couple of quick things. 1) anne writes mmany templates and often zenners install more than one template on their system. At the first sqlerror the forums are populated. So, to prevent issues with either running the sql several timmes or to help with "upgrading" a sql group, sometimes a delete is done to clear the house. Now, as for the slate.

Also, please review the forum, I believe there is a "fix" to the issue of the about us option not appearing. Some of which is that there needs to be an about us file in the applicable html_include folder base, then one in the override folder.

Appreciate the insight...I'll search the forum for the "About Us" issue.

I've never installed any of Anne's projects before...I've been following and reading a lot of her stuff but never tried implementing any of it.

"Classic Green" and my own templates are the only templates I've ever used.

This was the first attempt at installing a plug-in template from someone else.

I tried doing a step by step (very carefully) tonight on my live shop and way too many things went haywire for my liking. Needless to say, I dumped the whole project and restored to my original site.

I'll have to play around with this thing a lot more in my test shop before I attempt to use it on the live shop again.

Problems I ran into:

1- The "About Us" not loading during the sql patch process...
2- Descriptions failed to show (found a fix in a different post for this)
3- After logging in, the search box in the top blue menu bar goes to the center of the page and covers up some of the menu items. It's happening on the demo site too, so this may be intentional for mobile devices...
4- Center boxes went to the bottom of the page after I changed my logo or updated the social plug-ins...not sure which one caused it.
5- My website failed to display in the browser tab after updating the header.php.
6- IH4 mouse over image enlargement quits working after installing Sheffield Blue (even after re-installing the IH4 files).
7- The Wish List link disappeared from the top of my page
8- I'm sure I left a couple out...

Do I need to delete my original template "CUSTOM_FOLDERS" to keep conflicts from occurring? My understanding is that their can be multiple "CUSTOM_FOLDERS" located within the file structure as long as they don't contain the same name for different templates...please correct me if I'm wrong.

Thanks.

mikeel100:

Appreciate the insight...I'll search the forum for the "About Us" issue.

I've never installed any of Anne's projects before...I've been following and reading a lot of her stuff but never tried implementing any of it.

"Classic Green" and my own templates are the only templates I've ever used.

This was the first attempt at installing a plug-in template from someone else.

I tried doing a step by step (very carefully) tonight on my live shop and way too many things went haywire for my liking. Needless to say, I dumped the whole project and restored to my original site.

I'll have to play around with this thing a lot more in my test shop before I attempt to use it on the live shop again.

Problems I ran into:

1- The "About Us" not loading during the sql patch process...
2- Descriptions failed to show (found a fix in a different post for this)
3- After logging in, the search box in the top blue menu bar goes to the center of the page and covers up some of the menu items. It's happening on the demo site too, so this may be intentional for mobile devices...
4- Center boxes went to the bottom of the page after I changed my logo or updated the social plug-ins...not sure which one caused it.
5- My website failed to display in the browser tab after updating the header.php.
6- IH4 mouse over image enlargement quits working after installing Sheffield Blue (even after re-installing the IH4 files).
7- The Wish List link disappeared from the top of my page
8- I'm sure I left a couple out...

Do I need to delete my original template "CUSTOM_FOLDERS" to keep conflicts from occurring? My understanding is that their can be multiple "CUSTOM_FOLDERS" located within the file structure as long as they don't contain the same name for different templates...please correct me if I'm wrong.

Thanks.

Are you sure that you are in the correct thread for the product that you are trying to install? You are not using the responsive sheffield blue template are you? If so, that's a different thread.

So, regarding templates wwhich was basically the last question/statement and may be causing some of your issues. You can have as many template override directories as you wish/are allowed by system resources. The thing is any modifications made to files in folders that get overriden without an equivalently named file in the override folder will act as the default file and therefore may produce undesireable/unintentional results.

Essentially, for a store that has only had template modifications without core changes/hypothetically ideal situation, if the store was compared to a fresh install the only differences expected would be the addition of the files for the template, there would be no changed files or the changes made would have no effect on the store other than to permit additional functionality (the column grid addin works even if the sql is not used to add/modify the optiony.

So, "using the classic green" and your own templates could have lead to system changes not overridden (because in a default store there is no need to override the file(s)) by the template where those changes affect the template being nstalled.

Also, yes there are a few things in thhe downloaded package that require "fixing", but they are covered in the forum and are expected to be corrected when next uploaded. That is why it is important to read through the forum before installing any plugin.

Reguarding if in the correct forum, this template installs in the sheffield_blue directories. If that is not the override. Directory seen in your system, then this is the wrong thread.

mikeel100:

As suspected...apparently, none of the patches installed. Although, I did get a green bar and the number of commands processed when I ran them in the SQL patch app in admin.

I checked the first 4 "delete" functions in clg_install.sql against the db and those commands did not delete what they were supposed to.

There is nothing in your instructions about not running the patches if a prefix on the table names exist...unless I missed something.

Now, what are my options?

Manually process all of the .sql patches?

Change all the .sql patches table names to have a "zen_" prefix?

Either way, it's going to be a lot of work unless you have a link to ready made .sql patches with a zen_ prefix on the tables.

You shouldn't have to do anything with your database prefix if your zen cart is set up correctly. The zen cart admin--tools--install sql patches utility automatically deals with any database prefixes when you run patches from it.

Thanks,

Anne

Thanks Anne.

Sorry for posting my issues in the wrong forum...I am trying to upgrade to "Responsive"

The about_us.sql patch does not install with Responsive Sheffield Blue.

I've installed several times now in a freshly installed zen_cart without any plugins or templates installed, on my test shop with mimimal plug-ins and my own template installed, and on my live shop with several plug-ins and my own template installed.

Each time I tried to install Responsive Sheffield Blue, I had to manually install the about_us.sql patch into the database. On one of the installs, the patch did insert the new records but all of the columns were one position off to the left.

I have disabled the floating screen per your spec's in this forum but am confused what the name of that area is in order to make adjustments. My site is cheapsheetmusic.com and I'd like to move the picture & text over to the left. Is that the centerboxwrapper ? Thx for any direction/advice. MC

picaflor-azul:

You shouldn't have to do anything with your database prefix if your zen cart is set up correctly. The zen cart admin--tools--install sql patches utility automatically deals with any database prefixes when you run patches from it.

Thanks,

Anne

Thanks Anne.

Sorry for posting my issues in the wrong forum...I am trying to upgrade to "Responsive"

The about_us.sql patch does not install with Responsive Sheffield Blue.

I've installed several times now in a freshly installed zen_cart without any plugins or templates installed, on my test shop with mimimal plug-ins and my own template installed, and on my live shop with several plug-ins and my own template installed.

Each time I tried to install Responsive Sheffield Blue, I had to manually install the about_us.sql patch into the database. On one of the installs, the patch did insert the new records but all of the columns were one position off to the left.

Here is the code that came with the package. There are 10 elements to the INSERT INTO, one being the configuration_id (which I assume is automatically assigned during the INSERT). There are 10 elements in the VALUES and*** none represent the configuration_id***.

The number of elements in the INSERT AND VALUES don't add up. If the ID is assigned automatically, then there should be 11 elements in the INSERT.

last_modified is missing in the INSERT INTO.

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
('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''),');

So the thread to post issues related to responsive sheffield blue (which reportedly is the template being installed) is found at: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue

A search of that thread identifies that on Dec 23, 2013, the issue was addressed with alternate sql. Link is: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue&p=1231044#post1231044

Please continue discussion/questions at the above thread, instead of here.

mikeel100:

Thanks Anne.

Sorry for posting my issues in the wrong forum...I am trying to upgrade to "Responsive"

The about_us.sql patch does not install with Responsive Sheffield Blue.

I've installed several times now in a freshly installed zen_cart without any plugins or templates installed, on my test shop with mimimal plug-ins and my own template installed, and on my live shop with several plug-ins and my own template installed.

Each time I tried to install Responsive Sheffield Blue, I had to manually install the about_us.sql patch into the database. On one of the installs, the patch did insert the new records but all of the columns were one position off to the left.

I have posted a different patch for the about us page a few times to the forum. If you do a search of the forum you should find the code.

Thanks,

Anne

mrcastle:

I have disabled the floating screen per your spec's in this forum but am confused what the name of that area is in order to make adjustments. My site is cheapsheetmusic.com and I'd like to move the picture & text over to the left. Is that the centerboxwrapper ? Thx for any direction/advice. MC

If you want the left or right hand column disabled, you can do this in admin--configuration--layout settings.

Thanks,

Anne

mc12345678:

So the thread to post issues related to responsive sheffield blue (which reportedly is the template being installed) is found at: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue

A search of that thread identifies that on Dec 23, 2013, the issue was addressed with alternate sql. Link is: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue&p=1231044#post1231044

Please continue discussion/questions at the above thread, instead of here.

Thank you so much for posting all the details and links ;)

Thanks,

Anne

mc12345678:

So the thread to post issues related to responsive sheffield blue (which reportedly is the template being installed) is found at: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue

A search of that thread identifies that on Dec 23, 2013, the issue was addressed with alternate sql. Link is: http://www.zen-cart.com/showthread.php?210062-Responsive-Sheffield-Blue&p=1231044#post1231044

Please continue discussion/questions at the above thread, instead of here.

Thanks, I will.

picaflor-azul:

I have posted a different patch for the about us page a few times to the forum. If you do a search of the forum you should find the code.

Thanks,

Anne

Well, I've searched the forums numerous times over the last 6 days on a variety of issues and only found answers to a couple of them. That's why I email you directly. I'll just uninstall Responsive for now and wait for it to be developed a little more. A lot of these changes in the forum are way out of my league...appreciate the attempt at helping.