Thread: error message

Once logged into the site, I perform a search and then want to email one of the profiles, I click on free email and the following message comes up:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/exec2tod/public_html/inc/db.inc.php on line 121

On the page it says:

Contact information not sent


Profile is not available.



Why is that and I how do I solve that?


many thanks

In admin section the anonymous mode is that ticked or unticked.
Do all other functions work like can users log in register and can send emails etc.
Can you send email via the contact button.
have done any changes to the script.
more question than answers but look into these ...................

Thank you for replying.

anonymous mode is unticked (if ticked then members cannot email each other, right?).
yes people can register,
If i hit contact - then the compose.php page comes up and I can send messages.
If I hit free email, then the error message comes up. But with previous ones I have tried i can see in the that their emails have come up under contacted for free members.

Can you send email via the contact button. - sorry don't know what you mean.

have done any changes to the script. No wouldn't know how to.

Does that help? any more ideas?

annonymous mode.................it is better to have your site in annonymous mode, to do that made sure that box is ticked. If the site is not in annonymous mode and a logged in user clicks on FREE EMAIL than that users email is email to the user who click on free email. And absolute gold rush for spammers. Unless yours is a paying site than keep it in annoymous mode. Set it to annonymous mode will only disable this feature users will still be able to contact each other by clicking on the contact button or kiss or IM or pm etc etc.

FREE EMAIL automatically sends you the email address of what users profile you click on.

If you want to send message to the user click on the "contact" button.

It is a paying and so have now switched to annonymous mode. Thank you for th info.

When I click on Open window (IM i believe) a new windo opens but nothing happens. Why might that be?

One other question, do you how to change the date format across the whole site (not Date of Birth) but Login info etc. I want it in dd/mm/yyyy. I have removed the time (which I wante dto do) but cannot change the date around. I have done as suggested on the this site but that did not work.

Do you much about the extended search forms?

Many thanks

It is a paying and so have now switched to annonymous mode. Thank you for th info.

When I click on Open window (IM i believe) a new windo opens but nothing happens. Why might that be?

One other question, do you how to change the date format across the whole site (not Date of Birth) but Login info etc. I want it in dd/mm/yyyy. I have removed the time (which I wante dto do) but cannot change the date around. I have done as suggested on the this site but that did not work.

Do you much about the extended search forms?

Many thanks

where have you set up the script on your home computer or a server.......................wondering if it is on you home comptuer whether you need to install a mail server argosoft mail server is good and free.

Also do you have any emails ie registered users who are active for the system to get the emails from. if no active user I presume you would get that error.

google this = mysql_fetch_array supplied argument is not a valid MySQL result resource you should find quiet a few options.

you will find step by step instruction in the FAQ HOW TO section of this forum or the aedating user support forum. find the answer there a very commonly asked question

here goes pasted it for you

How to change the Date of Birth to DD/MM/YYYY format?

Since you need to switch the DD and YYYY attributes, only they will be affected in the database.
This is what you should do:
- assign new value to the Order field of the DateOfBirth,YearOfBirth requisite
- assign new value to the Order field of the DateOfBirth,DayOfBirth requisite
- move the "_Date of birth" value of the Namedisp field from the DateOfBirth,YearOfBirth requisite to the DateOfBirth,DayOfBirth requisite
- set the "group_mark" field of the DateOfBirth,YearOfBirth requisite to be "e" (end)
- set the "group_mark" field the DateOfBirth,DayOfBirth requisite to be "b" (beginning)
- move the " - " value of the "group_text_a" field from the DateOfBirth,YearOfBirth requisite to the DateOfBirth,DayOfBirth requisite (this sets the "-" sign between the fields in the form).

When I click on Open window (IM i believe) a new windo opens but nothing happens. Why might that be?..........................

instant messenger just like yahoo instant messenger...............................a user needs to have add you to his friends list and you would have to add that user for them to show up on the IM. if both of you have added each other than you can instant message just like yahoo.


not much to extended forum did not understand what you meant