ZCA Bootstrap 4 Template [Support Thread]

[Bruce1952]

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.4

CKEditor version 5

Image Handler version 5

I am wanting to know how to get the search to start working as you type a number or letters into search box which I have two of. One is the magnifying glass and the other is in a side box (because people don't seem to know what the magnifying glass picture is for).

Is there an option in the configuration settings to adjust this or do I need to change a file and if a file change is needed which file etc.

Once again any assistance is a great help as I am slowly getting through the dev site correcting things (and then updating the live site) that were done in the past by other people (not from here) that lied that they new zencart software.

[lat9]

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.4

CKEditor version 5

Image Handler version 5

I am wanting to know how to get the search to start working as you type a number or letters into search box which I have two of. One is the magnifying glass and the other is in a side box (because people don't seem to know what the magnifying glass picture is for).

Is there an option in the configuration settings to adjust this or do I need to change a file and if a file change is needed which file etc.

Once again any assistance is a great help as I am slowly getting through the dev site correcting things (and then updating the live site) that were done in the past by other people (not from here) that lied that they new zencart software.

The "magnifying glass" (when clicked) brings up a modal that uses an AJAX search, returning the found products as they're found; the search sidebox requires that the full search string be entered prior to the product search.

[Bruce1952]

The "magnifying glass" (when clicked) brings up a modal that uses an AJAX search, returning the found products as they're found; the search sidebox requires that the full search string be entered prior to the product search.

You are telling me that when you type in using the magnifying glass products should come up would that be correct?

If so why do I have to press enter to start it or is it my laptop with the issue not showing the product up?

[lat9]

You are telling me that when you type in using the magnifying glass products should come up would that be correct?

If so why do I have to press enter to start it or is it my laptop with the issue not showing the product up?

I'm guessing that the number of products on the site is causing a delay in the response. As I started to write this response, I'd typed li into the search box and once I got to writing the 2nd sentence the list started populating.

[Bruce1952]

I'm guessing that the number of products on the site is causing a delay in the response. As I started to write this response, I'd typed li into the search box and once I got to writing the 2nd sentence the list started populating.

So does zencart have a way to speed up the search options because I have thousands of product to list on the site and don't want to loose customers because of slow responses.

Is there a better search module?

[lat9]

So does zencart have a way to speed up the search options because I have thousands of product to list on the site and don't want to loose customers because of slow responses.

Is there a better search module?

That's a good question to ask in the "General" thread.

[brian70809]

How many items are on your website? I have 17,000 and mine is instant..
I just tried your website and it's really slow. You may have a server problem or database locking issue.

Also, when I select different options on your header, it's opening a new tab. Not sure why you have it doing that?

I'd contact your host about database issue.

[Bruce1952]

How many items are on your website? I have 17,000 and mine is instant..
I just tried your website and it's really slow. You may have a server problem or database locking issue.

Also, when I select different options on your header, it's opening a new tab. Not sure why you have it doing that?

I'd contact your host about database issue.

We have a lot of data that gets searched because we have different suppliers selling the same part with different part numbers. That is why you would see a few item show for the same part number or description.

Our search also is searching for model numbers as well as SKU and information in the description box. We have done it that way to make it easier for the customer to find things.

[Jeff_Mash]

We have a lot of data that gets searched because we have different suppliers selling the same part with different part numbers. That is why you would see a few item show for the same part number or description.

Our search also is searching for model numbers as well as SKU and information in the description box. We have done it that way to make it easier for the customer to find things.

There definitely seems like something is wrong with your server configuration. The issue seems to stem from the amount of time your database is taking to return search results. For example, on my site, I used my Ajax Search to type in a very generic term (Playing Cards, which we have over 1200 listings) and the Ajax window popped up within seconds.

I noticed on your site that the query takes FOREVER. In other words, I do get your Ajax Search to pop up results, but you have to sit there and wait for it. For example, I typed in the word "Throttle" and it took forever, but it finally popped up. I then went back to your home page, hit the search again, and typed "Throttle" again, and they pop up almost instantly (probably because the results are cached to reload the same content, I imagine). But if you put in a new search (for "Redback"), it takes forever again. But after, it loads the same search just fine.

I don't know who your web host is, but I'd be curious what kind of system resources you have (RAM, Core Processors, etc). The problem doesn't seem to be the Ajax Search, but your database / server speed in general.

If you turn off the Ajax Search in the Bootstrap Settings, I'm guessing you will still see slow results (but not quite as slow since it's not Ajax). Just a guess.

Has your site always had a slow response time?

Also, are you able to see if your database has any OVERHEAD and the option to OPTIMIZE those tables? I use MySQL and it will tell me which tables can be optimized or cleaned up to reduce overhead.

[Bruce1952]

There definitely seems like something is wrong with your server configuration. The issue seems to stem from the amount of time your database is taking to return search results. For example, on my site, I used my Ajax Search to type in a very generic term (Playing Cards, which we have over 1200 listings) and the Ajax window popped up within seconds.

I noticed on your site that the query takes FOREVER. In other words, I do get your Ajax Search to pop up results, but you have to sit there and wait for it. For example, I typed in the word "Throttle" and it took forever, but it finally popped up. I then went back to your home page, hit the search again, and typed "Throttle" again, and they pop up almost instantly (probably because the results are cached to reload the same content, I imagine). But if you put in a new search (for "Redback"), it takes forever again. But after, it loads the same search just fine.

I don't know who your web host is, but I'd be curious what kind of system resources you have (RAM, Core Processors, etc). The problem doesn't seem to be the Ajax Search, but your database / server speed in general.

If you turn off the Ajax Search in the Bootstrap Settings, I'm guessing you will still see slow results (but not quite as slow since it's not Ajax). Just a guess.

Has your site always had a slow response time?

Also, are you able to see if your database has any OVERHEAD and the option to OPTIMIZE those tables? I use MySQL and it will tell me which tables can be optimized or cleaned up to reduce overhead.

Hi Jeff,

I did as you said and run optimmize the tables and this is what I got in return after completion.

outdoorking_dev.ceon_umm_category_mapping_templates
outdoorking_dev.ceon_umm_configs
outdoorking_dev.ceon_umm_other_pages
outdoorking_dev.ceon_umm_page_mapping_templates
outdoorking_dev.ceon_umm_product_mapping_templates
outdoorking_dev.ceon_uri_mappings
outdoorking_dev.ceon_uri_mapping_configs
outdoorking_dev.ceon_uri_mapping_prp_uri_parts
outdoorking_dev.customers_to_groups
outdoorking_dev.customer_groups
outdoorking_dev.ceon_uri_mapping_prp_uri_parts
outdoorking_dev.stripe

Table does not support optimize, doing recreate + analyze instead

It appears that ceonurl mapping module might be causing most of the issues because in the past the search worked reasonable well until I decided to cleanup the site because of people that worked on left a lot of files on the site that should not be there.

At present I am testing on my dev site first and when something is woirking correctly I update the live site and then move on to the next module and check if that has issues as well.

Slowly, slowly so I don't make errors with the live site.

Should I run the command that is suggested for the files that have issues?

Also as I don't use the stripe module should I remove it from the site to fix that issue?

I forgot to say that I am using bootstrap version 3.6.2 which I am going to update today to the same as the live site.