| poldy |
First Post Posted on: 12-09-08 09:24 AM |
| Problems with expanded search |
|
| 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 |
Reply #: 1 Posted on: 12-10-08 06:24 AM |
| Re: Problems with expanded search |
|
| 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 |
Reply #: 2 Posted on: 12-13-08 11:10 AM |
| Re: Problems with expanded search |
|
| 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 |
Reply #: 3 Posted on: 12-14-08 01:53 AM |
| Re: Problems with expanded search |
|
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
|
|
|
|
|
|