Thread: Advanced search error

Hi everyone have this problem aeDate 4.1IQ everything works searchs with single parameter searchs work ie ID Logon name but not advanced search this is what I get


SELECT Profiles.ID, Headline, Country, Occupation, City, Sex, Sex2, ProfileType, NickName, Children, MerchantPrice, LEFT( DescriptionMe, 180 ) AS DescriptionMe, LEFT( DescriptionYou, 100 ) AS DescriptionYou, DateOfBirth, DateOfBirth2, Pic_0_addon, Sound, (LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl FROM Profiles WHERE Status = 'Active' AND (LookingFor = 'male' OR LookingFor = 'both') AND (IF('female'='both' or 'female'='couple',1,Sex='female')) AND (IF('female'='couple',ProfileType='couple',Profile Type!='couple')) AND (TO_DAYS(DateOfBirth) BETWEEN TO_DAYS('1965-09-22') AND (TO_DAYS('1988-09-22')+1)) ORDER BY Priority DESC, Priority DESC, Profiles.LastLoggedIn DESC LIMIT -10, 10
Error
Database access error



will appreciate any help.

Thanx Logunn

Check this thread:
Search Results

Fixed for 4.1.0 search_result.php, not sure what version you are using, but fix is similar:

#Solution 1 Add this in line 486 (line number may differ in different patch releases)

Code:

if ( $real_first_p < 0 )
{
$real_first_p=0;
}

Thank Smoge pasted in and fixed the error but won, t bring up any search results just says

No results found. Start again and try to broaden your search. I did have the quick search working fine but that has stopped the onlu search that works in ID or user name search.

But thanks for your quick responce and help much appreciated

Logunn

do you have approved (active) users?

do their sex and lookingfor and lookingages match?

If you only have a couple test users - put in more - 20 is a good number.

Smoge

I have inserted more than 20 active users in database, however, I also get the same Error and the message is:

No results found. Start again and try to broaden your search.

Could you give me any idea?

Thanks a lot.

Ok - you should do this:

A) examine the URL that gets created by search.php (and calls search_results.php) for errors.

or

B) echo the SQL statement that does the searching to the screen - so you can see what query is being run on the database.

B is the most direct but it takes some php skill to get it to echo to the pages.

---

Also - double check that your users profiles match up - that is, ages and looking ages, sexes and looking for sex.

You can also try to do a search here on MMS for "search" and you will find several threads about this.

We can also help you if needed - please contact me via PM to make arrangements.

Rob