144 replies to this topic

[bargainbox]

Gosh, just posted itself..so to conclude...

anyway

All a search returns now, is an blank page with :

"No input file specified."

I went through the install again and same result, so would be grateful of an idea of where to start looking for conflict, missing line, missing php file...anything to be going on would be appreciated.

Many Thanks

Martyn

[Jack_mcs]

bargainbox, on 16 March 2011 - 03:38 AM, said:

Gosh, just posted itself..so to conclude...

anyway

All a search returns now, is an blank page with :

"No input file specified."

I went through the install again and same result, so would be grateful of an idea of where to start looking for conflict, missing line, missing php file...anything to be going on would be appreciated.

That's not a message coming from this contribution. It looks more like a php error saying some file is missing. You're host may have error reporting turned off so you may want to ask them what the real error is.

[bargainbox]

The Golden Rule is.........Don't Panic........

The upshot was all about looking too close and missing the big picture.

It all came down to neglecting to put advanced_search_result.php at the top of the tree.

No surprise that there was nothing to find when the essential reference was missing !!

Many thanks for your speedy reply, as ever.

This contrib opens up such a wealth of opportunity for customers to really dig around and actually find items that are often described in great detail, but whose title does not include the search term they use, I cannot thank you enough.

Kind Regards

Martyn

[Jack_mcs]

You're welcome. I'm glad it helps.

[saupe31]

i added this to my site but if i do a search then scroll down the products to the back button i get this error
1054 - Unknown column 'pv.products_options_values_id' in 'on clause'

select pv.products_options_values_id as id, pv.products_options_values_name as text from products_options_values pv, products_options po join products_options_values_to_products_options popv on (pv.products_options_values_id = popv.products_options_values_id) where popv.products_options_id = po.products_options_id and popv.products_options_id =2 and po.language_id =1 group by pv.products_options_values_id, products_options_values_name

[TEP STOP]

also the search doesnt seem to find the right products all the time

[Jack_mcs]

saupe31, on 26 September 2011 - 06:58 PM, said:

i added this to my site but if i do a search then scroll down the products to the back button i get this error
1054 - Unknown column 'pv.products_options_values_id' in 'on clause'

select pv.products_options_values_id as id, pv.products_options_values_name as text from products_options_values pv, products_options po join products_options_values_to_products_options popv on (pv.products_options_values_id = popv.products_options_values_id) where popv.products_options_id = po.products_options_id and popv.products_options_id =2 and po.language_id =1 group by pv.products_options_values_id, products_options_values_name

[TEP STOP]

also the search doesnt seem to find the right products all the time

You made a mistake with the installation. The field that gets added is pov.products_options_values_id, not pv.products_options_values_id.

[saupe31]

i checked the installation the only bit i find with pov is
REPLACE WITH

  /************** BEGIN SITESEARCH CHANGE ******************/
  $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on p.products_id = pa.products_id left join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on pa.options_values_id = pov.products_options_values_id ";
  /************** END SITESEARCH CHANGE ******************/
and i have checked the file and it is there

[Jack_mcs]

saupe31, on 27 September 2011 - 09:53 PM, said:

i checked the installation the only bit i find with pov is
REPLACE WITH

  /************** BEGIN SITESEARCH CHANGE ******************/
  $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on p.products_id = pa.products_id left join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on pa.options_values_id = pov.products_options_values_id ";
  /************** END SITESEARCH CHANGE ******************/
and i have checked the file and it is there

I did a search for pv.products_options_values in a basic shop and doesn't show up at all. So it has to be something specific to your shop, which I can't help with.

[saupe31]

i have fixed it now did a google search for pv.products and found the answer

[saupe31]

can you tell me how i can stop it searching descriptions as it is throwing in some bad results

[Jack_mcs]

In the boxes/ search.php file, find and remove this code

tep_draw_hidden_field('search_in_description','1') .

Note: the trailing period, as shown, must be deleted.

[saupe31]

deleted that but the results still the same, but if i click back and use the search what shows there and untick search descriptions it works fine so is there anywhere else i need to delete

[Freeman]

Hi Guys,
anyone is using the contribution with Qty pro and integrated to check stock x attribute? that'll be a nice feature, i'm willing to help out if someone is interested!
Basically it could check attributes with stock (if using qty pro).
regards

[Jack_mcs]

The code's not setup to work with QTPro. I'll add to the list for the next revision but that could be quite a ways off.

[Freeman]

Thanks Jack, if i can be of any help with testing and coding gimme a shout and i'll be more than happy to collaborate [img]http://forums.oscommerce.com//public/style_emoticons/default/smile.png[/img]
I think it's not an easy task since QTY Pro is using a "proprietary" and different way to calculate stock by attribute, but you never know [img]http://forums.oscommerce.com//public/style_emoticons/default/smile.png[/img]

[Jack_mcs]

OK, thanks. I thought the same thing myself, which is why I didn't try a quick code change. I'm not sure the search can be done in one command but, if it can be, the mysql will probably be quite involved.

[Freeman]

Yes, won't be an easy one, Here i'm in case

[dlcmpls]

Hi Jack.  I have an odd situation with the Contribution.

I am currently receiving notification emails stating that a customer ran a search, but the search came up empty.  However, I know that the searched-on products do exist and I can even find the products if I duplicate the search myself.

Here's an example of an email I received from my site that demonstrates the issue:


##############################

From: "Art Glass" <owner@site.com>

Date: November 20, 2011 2:48:43 PM CST

To: owner@site.com

Subject: Request for product information



A visitor who's email address is  could not find the following products using the search function:

------------------------------------------------------
b2137-30f
------------------------------------------------------

Additional Comments:

###############################


Note that no email address is included in the body of the email.

If I go and manually run that same search:

b2137-30f

I get 3 products.

So the search should be valid, and products should be found and shown to the user, but instead I get emails that say no products were found.

Any thoughts?

[Jack_mcs]

No, I don't know what that might be. It's always difficult to fix a problem that can't be duplicated so I can't even suggest a way to test it..

[kelagedart]

I sell books.

Somehow I got the Advanced Search results to display the below fields.

However - Publisher (Manufacturer) is missing.

And everything at binding and below is missing data or it is inaccurate.

I know i probably need to connect those fields to the database. I just need some basic leads as to where those boxes are coming from and and where to connect the data.

For example, Binding has been added to the database. Directly, and not through the admin panel. Say as Pruduct_Binding. It is not a normal OSC 'attribute'. How would I get the code to interact and search Product_Binding. Or any other database field, for that matter.

I'm not a programmer, though have done extensive mods to my 2.2rca site.

For a clue as to what i mean, you can do a search at millpondshoppe.com


Categories: Include Subcategories [img]http://millpondshoppe.com/images/pixel_trans.gif[/img] Authors: [img]http://millpondshoppe.com/images/pixel_trans.gif[/img] Price From: Price To: [img]http://millpondshoppe.com/images/pixel_trans.gif[/img] Date From: Date To: Binding Size Edition Year Location Weight Illustrator Jacket Condition Condition Keywords Catalogs