ZCA Bootstrap 4 Template [Support Thread]

[marketpress]

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.

[swguy]

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?

[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');

[lat9]

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

[swguy]

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

[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

[swguy]

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

[lat9]

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-Bootstra...ate/issues/110