Thread: error message

I am getting this after installation

can someone help me

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 Picture = '1' AND (LookingFor = 'female' OR LookingFor = 'both') AND (IF('male'='both' or 'male'='couple',1,Sex='male')) AND (IF('male'='couple',ProfileType='couple',ProfileTy pe!='couple')) ORDER BY Priority DESC, Priority DESC, Profiles.LastLoggedIn DESC LIMIT -10, 10Error
Database access error

I have seen this before.... if you have no users in your database - and if I am not mistaken, they need to be "active" - you will get this error on search, when you do a fresh install.

Smoge

it still does it

any other idea

Is this a fresh install, or an upgrade from a previous release (updated database)?

Smoge

Its a fresh install

This is what it tells me in the DB. The x's is my info. I just xed them so they can not be seen



$db['host'] = 'localhost';
$db['sock'] = '';
$db['port'] = '';
$db['user'] = 'xxxxxx_xxxxx;
$db['passwd'] = 'XXXXXXXX';
$db['db'] = 'XXXXXXX_XXXXXXX';

Error in /search_result.php: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1
Query: '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 = 'female' OR LookingFor = 'both') AND (IF('male'='both' or 'male'='couple',1,Sex='male')) AND (IF('male'='couple',ProfileType='couple',ProfileTy pe!='couple')) AND (TO_DAYS(DateOfBirth) BETWEEN TO_DAYS('1964-12-13') AND (TO_DAYS('1987-12-13')+1)) ORDER BY Priority DESC, Priority DESC, Profiles.LastLoggedIn DESC LIMIT -10, 10'

The last time I asked them to do something for me. They uploaded my stuff without asking me causing me to lose my lang file. I just spent 2 days fixing. Stupid me didnt back it up.

I would perfer to get my answers here because it seems that these people in here have a better head on their shoulders the AEHating do.

Thanks

Hi,

IM5150 asked me to look at this - and while I did not fix the query itself in the PHP at this point - the problem does "go away" with a "active" male and female (and perhaps you would want a valid couple) profile in the database - who are looking for the opposite sex ...

The problem is - if no results are returned by search - it "pukes" - with some valid "active" members - it's OK.

Smoge