ZCA Bootstrap 4 Template [Support Thread]

[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]

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.

[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

[lat9]

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.

[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