ZCA Bootstrap 4 Template [Support Thread]

Thank you much for this! Have it working on v1.5.7c with bootstrap 3.1.4 Good work
Cindy!! Still trying to figure out where to control some of the styles ie the background color of the containers.
But your contribution saved me because Ceon URI killed my previous slide show.

I'm trying the Ajax search from the latest version and I don't see any results until I press enter - what am I doing wrong?

Oh LOL I should have looked at the logs. There's a log produced by ajax search this on MySQL installations that don't have ONLY_FULL_GROUP_BY turned off.

--> PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'demo_157c.p.products_sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: SELECT DISTINCT p.products_image, p.products_id, pd.products_name, p.master_categories_id, p.products_model FROM products p
INNER JOIN products_description pd
ON pd.products_id = p.products_id
AND pd.language_id = 1
WHERE p.products_status = 1
AND ((pd.products_name LIKE '%speed%' OR p.products_model LIKE '%speed%') ) ORDER BY p.products_sort_order, pd.products_name LIMIT 8 ==> (as called by) /Users/scott/Sites/demo_157c/includes/classes/ajax/zcAjaxBootstrapSearch.php on line 61 <== in /Users/scott/Sites/demo_157c/includes/classes/db/mysql/query_factory.php on line 170.

Workaround is to add to includes/configure.php

define('DB_MYSQL_MODE','NO_ENGINE_SUBSTITUTION');

swguy:

Oh LOL I should have looked at the logs. There's a log produced by ajax search this on MySQL installations that don't have ONLY_FULL_GROUP_BY turned off.

--> PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'demo_157c.p.products_sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: SELECT DISTINCT p.products_image, p.products_id, pd.products_name, p.master_categories_id, p.products_model FROM products p
INNER JOIN products_description pd
ON pd.products_id = p.products_id
AND pd.language_id = 1
WHERE p.products_status = 1
AND ((pd.products_name LIKE '%speed%' OR p.products_model LIKE '%speed%') ) ORDER BY p.products_sort_order, pd.products_name LIMIT 8 ==> (as called by) /Users/scott/Sites/demo_157c/includes/classes/ajax/zcAjaxBootstrapSearch.php on line 61 <== in /Users/scott/Sites/demo_157c/includes/classes/db/mysql/query_factory.php on line 170.

Workaround is to add to includes/configure.php

define('DB_MYSQL_MODE','NO_ENGINE_SUBSTITUTION');
That's weird, I always run with ONLY_FULL_GROUP_BY on my test sites. What version of MySql is in use?

lat9:

That's weird, I always run with ONLY_FULL_GROUP_BY on my test sites. What version of MySql is in use?
Here's what I use to override the MYSQL_MODE, still puzzled:

define('DB_MYSQL_MODE', 'ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION');

MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

Database Engine: MySQL 5.7.34

PHP Version 7.4.21

A code fix rather than changing configure.php would be just to add p.products_sort_order to the query in includes/classes/ajax/zcAjaxBootstrapSearch.php line 57

BTW thanks for adding this feature - and the UI you built is amazing! Another win for the Bootstrap template.

swguy:

A code fix rather than changing configure.php would be just to add p.products_sort_order to the query in includes/classes/ajax/zcAjaxBootstrapSearch.php line 57
Yep, got that staged, just need to create a GitHub issue.

Issue created: https://github.com/lat9/one_page_checkout/issues/307

lat9:

Yep, got that staged, just need to create a GitHub issue.

Issue created: https://github.com/lat9/one_page_checkout/issues/307
I'm having a bad day/month/year: https://github.com/lat9/ZCA-Bootstrap-Template/issues/110

swguy:

BTW thanks for adding this feature - and the UI you built is amazing! Another win for the Bootstrap template.
Can't take credit for the UI. The modal search was based on the AJAX search contribution by @balihr.

Ajax search is a brilliant addition.

I have a slight issue which must be due to configuration or permission on my sites. The Ajax search works perfectly most of the time.

In production, select the magnifying glass, enter a search term, and the items display in the drop down. If I click the "View All" button the products are displayed whereas if I press enter none of the products are displayed.

In my test environment I can partly reproduce it as the first search does not display results but a subsequent search using a different search word will.

There are no error log files created.

Has anyone seen something like this?

environment:
PRODUCTION: Zen Cart 157c; Apache 2.4.41; PHP 7.4.3; MySQL 8.0.27; Ubuntu 5.4.0
Dev: Zen Cart 157c; Apache 2.4.46; PHP 7.4.13; MySQL 5.5.5 -10.4.17-MariaDB; XAMPP v3.2.4; Windows 10 build 19041

OldNGrey:

Ajax search is a brilliant addition.

I have a slight issue which must be due to configuration or permission on my sites. The Ajax search works perfectly most of the time.

In production, select the magnifying glass, enter a search term, and the items display in the drop down. If I click the "View All" button the products are displayed whereas if I press enter none of the products are displayed.

In my test environment I can partly reproduce it as the first search does not display results but a subsequent search using a different search word will.

There are no error log files created.

Has anyone seen something like this?

environment:
PRODUCTION: Zen Cart 157c; Apache 2.4.41; PHP 7.4.3; MySQL 8.0.27; Ubuntu 5.4.0
Dev: Zen Cart 157c; Apache 2.4.46; PHP 7.4.13; MySQL 5.5.5 -10.4.17-MariaDB; XAMPP v3.2.4; Windows 10 build 19041
Hmm, I'm not able to reproduce this. On a test setup with the demo products, I entered **j **as the search term (which brought up 7 items in the modal display). Pressing Enter resulted in the Advanced Search page being displayed and showing those same 7 items.

I have loaded Bootstrap onto a vanilla version of zc157c and am still getting inconsistent results. Pressing the "Show All" button always works and displays the products retrieved via the AJAX search.
Pressing the enter key only works sometimes. In most cases I land back on the Home Page.
It is as if the full URL associated with the "Show All" button is not being fired when the Enter key is pressed.

Deleted

After extensive testing my conclusion is the ```
window.location.replace(searchLink);

By adding ```
return false;
``` immediately after that line the results are always returned when the enter key is pressed.

I tried to minify the file as well but my minified result does not work. I assume minify requires libraries to be added.

zc157c ; ZCA Bootstrap-4

HI May I get some help on Attribute Image Swatch? I have read dozens of documents & watched Youtube tutorials but none seem to have covered adding image to the Swatch. I tried all ways but the image is not showing. I have also noted that Attributes of option type Read Only cannot have images associated & even if defined will not be displayed. So over the last days I have tested all types but just can't have the attribute image shown . I present a case scenario here with some screenshots. In this case I have a Artistic Wire 18g in 3 colours, I would like to show the colors with attribute image. As you can see the options are shown just no way of getting the images up. The attribute image folder has permission code 755 at top level & 644 for files. If someone can please provide some guidance or is this function not available in the ZCA Bootstrap-4 template?
Appreciate any guidance!

I'm gonna take a stab in the dark here. Try changing the Silver.jpg to silver.jpg

Sometimes, beginning a filename with a capital letter can be a problem.

Newbie or beginner at bootstrap question:

What s the best way to turn right column off?

i switched setting to 0 instead of 3.

Then per instructions, increase center column to 9 to maintain the 12 total requirement.

However, when i do this right column is off but whatever box that were there are getting slammed under the left column!

I know i can fix it by turning the unneeded right boxes off.

The question is: is it normal behavior? or Am i missing something?

Thank you for your time

nicksab:

Newbie or beginner at bootstrap question:

What s the best way to turn right column off?

i switched setting to 0 instead of 3.

Then per instructions, increase center column to 9 to maintain the 12 total requirement.

However, when i do this right column is off but whatever box that were there are getting slammed under the left column!

I know i can fix it by turning the unneeded right boxes off.

The question is: is it normal behavior? or Am i missing something?

Thank you for your time

My laziness. Fix for this has been provided on Github if anyone else looking