Forums / General Questions / Does the search feature query products_model?

Does the search feature query products_model?

Started by idc1 on 21 Jun 2016, 8:45 PM · Views: 624

Results 1 to 7 of 7
21 Jun 2016, 8:45 PM
#1
idc1 avatar

idc1

Zen Follower

Join Date:
Jul 2011
Posts:
139
Plugin Contributions:
0

Does the search feature query products_model?

I am upgrading from 1.3.9h in which using the search feature returns results based on a products_model search. I don't remember making any code change to achieve this. In 1.5.5, I'm not getting any results. It appears I should get results after looking at /includes/modules/pages/advanced_search_result/header_php.php

What could I be missing have 0 results? products_model is populated in the database.

Thanks

ZC 1.5.5
Add ons: - Column/Grid 1.3.8 - Dual pricing 1.7 - ImageHandler3

21 Jun 2016, 8:52 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Does the search feature query products_model?

Does the search feature query products_model?
Yes. As you can see on line 310 of advanced_search_result/header_php.php:

        $where_str .= "(pd.products_name LIKE '%:keywords%'
                                         OR p.products_model
                                         LIKE '%:keywords%'

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

21 Jun 2016, 8:56 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Does the search feature query products_model?

Do you have model turned off in your Admin?
Admin->Configuration->Product Listing->Display Product Model ... must be set to a non-zero number to display the model in the results. But this doesn't affect the actual search.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

22 Jun 2016, 1:33 PM
#4
idc1 avatar

idc1

Zen Follower

Join Date:
Jul 2011
Posts:
139
Plugin Contributions:
0

Re: Does the search feature query products_model?

Thank you for confirming DrByte. I do have Admin->Configuration->Product Listing->Display Product Model = 1 . The search feature does return results based on products_name but not products_model. Maybe there is a breakdown in the template being used, but I haven't stumbled across it yet.

ZC 1.5.5
Add ons: - Column/Grid 1.3.8 - Dual pricing 1.7 - ImageHandler3

22 Jun 2016, 8:44 PM
#5
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,893
Plugin Contributions:
20

Re: Does the search feature query products_model?

You're making a big jump starting at 1.3.9h. Are you using an "autoinstaller" or following https://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading
So-called auto-installers are not reliable.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

23 Jun 2016, 1:08 PM
#6
idc1 avatar

idc1

Zen Follower

Join Date:
Jul 2011
Posts:
139
Plugin Contributions:
0

Re: Does the search feature query products_model?

Thanks for the input dbltoe. I have someone that seems to contribute quite a bit on here and that I suspect you all would likely say is competent handling the upgrade therefore I don't know how they are going about it.

ZC 1.5.5
Add ons: - Column/Grid 1.3.8 - Dual pricing 1.7 - ImageHandler3

23 Jun 2016, 5:40 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Does the search feature query products_model?

idc1:

Thanks for the input dbltoe. I have someone that seems to contribute quite a bit on here and that I suspect you all would likely say is competent handling the upgrade therefore I don't know how they are going about it.
I'm sure that if they're stuck they can post more details about what's actually happening in the page, if they wish some additional assistance in sorting out why it's not working on your site for some unusual reason.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.