Welcome Visitor, Please Login or Register Now Tuesday, April 30, 2024 12:42 AM 
Forums Index > Mewsoft Products > Auctionawy > Problems with expanded search
New Topic   New Reply
Search for:
Author Message
poldy poldy's personal page
Registered Member
Posts: 90 Display member's posts
Joined: 04-30-24 12:42 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Problems with expanded search Edit Delete Reply with quote Quote
First Post Posted on: 12-09-08 09:24 AM next post first post
Hi,\ I have a problem with expanded search.\ It works ok in English, but when I switch to hebrew I get the following error code when searching by keyword.\ \ SQL Error: Unknown column 'Country' in 'where clause'\ Query: \ SELECT ID FROM Items WHERE ((Title LIKE '%visor%' ) OR (Description LIKE '%visor%' )) AND (Status=1 AND Item_Language='English' AND Country='Israel') ORDER BY Sponser DESC, Price DESC, End_Time DESC\ Line 618, File Q:/pumbit.com/www/cgi-bin/auction/AdvancedSearch.pm.\ \ \ please take a look at:\ \ http://pumbit.com/cgi-bin/auction/auction.cgi?action=AdvancedSearch&Cat_ID=0&Lang=Hebrew\ \ the search button is on the left same line as the form field. \ please also click the field next to keyword search tips to search in description. \ \ search word should be "visor"\ \ thanks for any help you might be able to offer\ \ poldy
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-30-24 12:42 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems with expanded search Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 12-10-08 06:24 AM next post previous post
You need to remove any language you created and not used, you may still have the English language directory exit. Also from the admin->Language manager click the link prepare avaliable languages.

Mewsoft Support
www.mewsoft.com
poldy poldy's personal page
Registered Member
Posts: 90 Display member's posts
Joined: 04-30-24 12:42 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Problems with expanded search Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 12-13-08 11:10 AM next post previous post
Hi I think I found the problem.\ \ SELECT ID FROM Items WHERE ((Title LIKE '%visor%' ) OR (Description LIKE '%visor%' )) AND (Status=1 AND Item_Language='English' AND Country='Israel') ORDER BY Sponser DESC, Price DESC, End_Time DESC\ \ If I run the same SQL script without reference to country it works fine:\ SELECT ID FROM Items WHERE ((Title LIKE '%visor%' ) OR (Description LIKE '%visor%' )) AND (Status=1 AND Item_Language='English' ) ORDER BY Sponser DESC, Price DESC, End_Time DESC\ \ How do I change the search procedure not to include COUNTRY in the SQL.\ \ Thanks\ \ Poldy
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-30-24 12:42 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems with expanded search Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 12-14-08 01:53 AM last post previous post

There is no countery on the advanced search page, it seems you have old template which used a countery selection menu.


Mewsoft Support
www.mewsoft.com
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.0970 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation