Sheffield Blue Template Support Thread

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

Quote:

---

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.