Responsive Avonlee Contempo

I just tried installing the Responsive Avonlee Contempo template on a test site which also has the Winchester Responsive template installed. This template (Responsive Avonlee Contempo) uses a few SQL files during the install. All of them worked fine except for the middle command in the responsive.sql file, which reads.

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 
(NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');

That line wouldn't run, and the site is blank now. If I switch back to Winchester the site reappears. All other steps in the install have been followed except the Layout Settings from Step 7, which depend on that SQL command running.

This is particularly odd because the Winchester template doesn't use SQL install steps, so I can't see how anything could be in the db to conflict with this one.

Any ideas? (The test site is at www.horsemansshop.com.au/NewZC2/)

Rob

rstevenson:

I just tried installing the Responsive Avonlee Contempo template on a test site which also has the Winchester Responsive template installed. This template (Responsive Avonlee Contempo) uses a few SQL files during the install. All of them worked fine except for the middle command in the responsive.sql file, which reads.

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
(NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2', '3'),');

> 
> That line wouldn't run, and the site is blank now. If I switch back to Winchester the site reappears. All other steps in the install have been followed except the Layout Settings from Step 7, which depend on that SQL command running.
> 
> This is particularly odd because the Winchester template doesn't use SQL install steps, so I can't see how anything could be in the db to conflict with this one.
> 
> Any ideas? (The test site is at [www.horsemansshop.com.au/NewZC2/](http://www.horsemansshop.com.au/NewZC2/))
> 
> Rob
Hi
What exactly happened when you tried to run the SQL?
L

Sorry, I should have been more specific. When I ran that sql file all at once, I got a blank screen in admin. So I backed up and ran the first statement in it successfully, then the second gave me a blank screen again, then the third statement ran successfully. So it's definitely that second statement, which I quoted above, that wouldn't run. And after all the other sql files were run, all successfully, and the other install steps were performed, the site front end wouldn't load, giving me a blank screen. Reverting to the Winchester template restores the test site. No other edits - of files or admin settings - have been performed yet.

Checking the logs, I see...

[11-Oct-2015 01:49:13 UTC] PHP Fatal error:  1048:Column 'configuration_group_id' cannot be null :: 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 (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),'); ==> (as called by) /home/horseman/public_html/NewZC2/[admin folder]/sqlpatch.php on line 304 <== in /home/horseman/public_html/NewZC2/includes/classes/db/mysql/query_factory.php on line 155 

Rob

rstevenson:

Sorry, I should have been more specific. When I ran that sql file all at once, I got a blank screen in admin. So I backed up and ran the first statement in it successfully, then the second gave me a blank screen again, then the third statement ran successfully. So it's definitely that second statement, which I quoted above, that wouldn't run. And after all the other sql files were run, all successfully, and the other install steps were performed, the site front end wouldn't load, giving me a blank screen. Reverting to the Winchester template restores the test site. No other edits - of files or admin settings - have been performed yet.

Checking the logs, I see...

[11-Oct-2015 01:49:13 UTC] PHP Fatal error: 1048:Column 'configuration_group_id' cannot be null :: 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 (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2', '3'),'); ==> (as called by) /home/horseman/public_html/NewZC2/[admin folder]/sqlpatch.php on line 304 <== in /home/horseman/public_html/NewZC2/includes/classes/db/mysql/query_factory.php on line 155

> 
> Rob

If it is the sql for the column layout grid plugin, you do not need to run it again since it was already installed with the Winchester Responsive install.

Thanks,

Anne

If it is the sql for the column layout grid plugin, you do not need to run it again since it was already installed with the Winchester Responsive install.
The one that didn't run is the INSERT INTO line from the responsive.sql file, not the clg_install.sql.

Was the Winchester template able to install sql patches by itself, behind the scenes as it were? That would be a cool thing, considering how often sql patches are problematic for one reason or another. I ask because there were no sql patch files in the Winchester download, which I have here, untouched, as a backup.

In any case, the issue is what to do now, since if I switch to the Avonlee template, I get a blank front end to the site. Something is wrong in the db, I'm guessing. This is a pretty clean install, as befits a test site. It's a new ZC 1.5.4 with a backup of the current site's db (and absolutely none of the old site's php files, of course) on which only Winchester and Avonlee templates have been installed.

So far no core files have been touched by me; any edits were either done in admin or in the Winchester files as we were discussing on its thread. There might well be bits left in the db from earlier add-ons, but none of those add-ons have been re-installed yet, so none are active. Ah! That rings a bell... the old site had Single Listing Template installed, which now that I look at my backups did install the column layout grid as part of its install. So that was in the db already. Can you suggest which table or row to delete from the db so the required INSERT INTO from your responsive.sql patch will run? I'm comfortable editing dbs with PHPMyAdmin.

Rob

rstevenson:

The one that didn't run is the INSERT INTO line from the responsive.sql file, not the clg_install.sql.

Was the Winchester template able to install sql patches by itself, behind the scenes as it were? That would be a cool thing, considering how often sql patches are problematic for one reason or another. I ask because there were no sql patch files in the Winchester download, which I have here, untouched, as a backup.

In any case, the issue is what to do now, since if I switch to the Avonlee template, I get a blank front end to the site. Something is wrong in the db, I'm guessing. This is a pretty clean install, as befits a test site. It's a new ZC 1.5.4 with a backup of the current site's db (and absolutely none of the old site's php files, of course) on which only Winchester and Avonlee templates have been installed.

So far no core files have been touched by me; any edits were either done in admin or in the Winchester files as we were discussing on its thread. There might well be bits left in the db from earlier add-ons, but none of those add-ons have been re-installed yet, so none are active. Ah! That rings a bell... the old site had Single Listing Template installed, which now that I look at my backups did install the column layout grid as part of its install. So that was in the db already. Can you suggest which table or row to delete from the db so the required INSERT INTO from your responsive.sql patch will run? I'm comfortable editing dbs with PHPMyAdmin.

Rob

The Winchester Responsive has already uploaded the responsive.sql

If you get a blank page, check your logs folder for errors.

Thanks,

Anne

picaflor-azul:

If you get a blank page, check your logs folder for errors.

See post #183 above for the most recent logged error. There is one before that, likely from my first stab at loading that sql file which reads...

[11-Oct-2015 01:17:31 UTC] PHP Fatal error:  1062:Duplicate entry 'COLUMN_WIDTH' for key 'unq_config_key_zen' :: 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 (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),'); ==> (as called by) /home/horseman/public_html/NewZC2/[my admin folder]/sqlpatch.php on line 304 <== in /home/horseman/public_html/NewZC2/includes/classes/db/mysql/query_factory.php on line 155

Do either of these suggest something I can do? If necessary I can just redo the install completely, but I'd rather fix this one if possible.

Thanks,

Rob

That error looks like it came from the SQL install. If you just run the program, where you get the blank screen, do you get any error files in your log folder?

l

rstevenson:

See post #183 above for the most recent logged error. There is one before that, likely from my first stab at loading that sql file which reads...

[11-Oct-2015 01:17:31 UTC] PHP Fatal error: 1062:Duplicate entry 'COLUMN_WIDTH' for key 'unq_config_key_zen' :: 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 (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2', '3'),'); ==> (as called by) /home/horseman/public_html/NewZC2/[my admin folder]/sqlpatch.php on line 304 <== in /home/horseman/public_html/NewZC2/includes/classes/db/mysql/query_factory.php on line 155

> 
> Do either of these suggest something I can do? If necessary I can just redo the install completely, but I'd rather fix this one if possible.
> 
> Thanks,
> 
> Rob

This error is related to the sql patch.  There should be a different error for the blank page.

Thanks,

Anne

lruskauff:

That error looks like it came from the SQL install. If you just run the program, where you get the blank screen, do you get any error files in your log folder?

Yes...

[11-Oct-2015 01:51:44 UTC] PHP Parse error:  syntax error, unexpected 's' (T_STRING) in /home/horseman/public_html/NewZC2/includes/languages/english/responsive_avonlee_contempo/header.php on line 26

Rob

I fixed the blank front end with your hint to look at the other log files lruskauff. Thank you. There was a stray apostrophe in the site's HEADER_ALT_TEXT define, which was line 26 in that error. Who knew an apostrophe could be so destructive! (It's now an HTML entity.)

Now I just need to find the problem with the admin not being fully functional for this template. The admin problem shows up when I'm trying to follow step 7 in the install instructions, where you have to "Click on "ACTIVATE Responsive Template by selecting Column Widths" ...". There is no such choice under Layout Settings in admin, because the install sql patch that should have set that up is the one that won't run. There is "Activate Responsive Settings", but the choices available there are not correct. That must have come from the Winchester template.

Any ideas on how to fix that one?

Rob

Glad you got that one fixed, I get that screen quite often, lol.

Is there an " uninstall for the SQL that you could run, then rerun the install?

rstevenson:

I fixed the blank front end with your hint to look at the other log files lruskauff. Thank you. There was a stray apostrophe in the site's HEADER_ALT_TEXT define, which was line 26 in that error. Who knew an apostrophe could be so destructive! (It's now an HTML entity.)

Now I just need to find the problem with the admin not being fully functional for this template. The admin problem shows up when I'm trying to follow step 7 in the install instructions, where you have to "Click on "ACTIVATE Responsive Template by selecting Column Widths" ...". There is no such choice under Layout Settings in admin, because the install sql patch that should have set that up is the one that won't run. There is "Activate Responsive Settings", but the choices available there are not correct. That must have come from the Winchester template.

Any ideas on how to fix that one?

Rob

That setting should already be there from the Winchester Responsive template package. If you have not made any other modifications to the template and you are set on using this template package (which is not as recently updated or advanced as the Winchester Responsive) then I would start from a fresh install and just upload this template package.

Thanks,

Anne

Following up on my previous issue about the popup product images, I discovered that if I resize the popup window on my desktop browser, the image grows to whatever dimensions I drag the window. Is there any way to specify the minimum image window size for the desktop display? This only happens if I have the responsive setting in Configuration >> Layout settings set to anything but zero (template default size/actual image size). See pics attached for example:

With Responsive set to 0:

With Responsive set to 3:

I want the popup window when responsive is enabled to show the image at a larger default size and, hopefully, only have the larger default size when on a desktop browser. As stated in my previous posting about the issue, on mobile devices, it shows fine.

I cannot seem to find where this would be set. Abbington Mega and other non responsive templates did not have this issue and I am thinking it is some sort of default responsive setting, but do not know if it is tied to the template or if this is something with Zen-cart itself.

Hopefully, you can provide some insight as this is really frustrating me as there is no way to know from the popup window that it can be resized and the image will grow with dragging the size of the popup window.

anklebiterwoodworks:

Following up on my previous issue about the popup product images, I discovered that if I resize the popup window on my desktop browser, the image grows to whatever dimensions I drag the window. Is there any way to specify the minimum image window size for the desktop display? This only happens if I have the responsive setting in Configuration >> Layout settings set to anything but zero (template default size/actual image size). See pics attached for example:

With Responsive set to 0:

With Responsive set to 3:

I want the popup window when responsive is enabled to show the image at a larger default size and, hopefully, only have the larger default size when on a desktop browser. As stated in my previous posting about the issue, on mobile devices, it shows fine.

I cannot seem to find where this would be set. Abbington Mega and other non responsive templates did not have this issue and I am thinking it is some sort of default responsive setting, but do not know if it is tied to the template or if this is something with Zen-cart itself.

Hopefully, you can provide some insight as this is really frustrating me as there is no way to know from the popup window that it can be resized and the image will grow with dragging the size of the popup window.

This question has been asked and answered many times already. Try this:

http://www.zen-cart.com/showthread.php?210386-Stirling-Grand-Responsive-Template&p=1244964#post1244964

Thanks,

Anne

Thank you vert much that fixed it. I did not know it was listed in another thread for a template I don't use.

anklebiterwoodworks:

Thank you vert much that fixed it. I did not know it was listed in another thread for a template I don't use.

It is always a good practice to search the forum when you have a question. The answer may be posted in another thread.

Thanks,

Anne

picaflor-azul:

This question has been asked and answered many times already. Try this:

http://www.zen-cart.com/showthread.php?210386-Stirling-Grand-Responsive-Template&p=1244964#post1244964

Thanks,

Anne

Anne,

I followed the thread I cannot find the code:

if (COLUMN_WIDTH == '0') {

located anywhere in the /includes/templates/responsive_avolee_contempo/common/html_header.php file and have been racking my brain for about 4 hours with this now. Am I missing something just really stupid here?

The URL is http://bettysbargainbin.com

Thank you,

Todd

bettysbargainbin:

Anne,

I followed the thread I cannot find the code:

if (COLUMN_WIDTH == '0') {

located anywhere in the /includes/templates/responsive_avolee_contempo/common/html_header.php file and have been racking my brain for about 4 hours with this now. Am I missing something just really stupid here?

The URL is http://bettysbargainbin.com

Thank you,

Todd

Try looking at the html_header.php file from the template package. My guess is that you have changed the file and this is why you cant't find the link.

Thanks,

Anne

Can someone tell which file this code should be in? It only shows up when the page is in a responsive mode.

Thanks in advance