Ok Here is the issue.
Script is webdate by webscribble.com. I moved it to my new server which is a secure server. I can control globals with a [url removed, login to view] file they let me do that.
I reinstalled the script and all works fine except.
featured members not showing.
if you search between 2 ages all profiles show those with and those without photos, however if you select to search for only profiles with pics no results at all show.
I have spent three days battling both webscribble and my host and have got no where.
My host says its a script issue and i can enable what I need using [url removed, login to view] Webscribble say it is a mysql misconfig.
This is what webscribble say:
"The reason your featured profiles and photo search is not working is due to a MySQL issue with your server. Below is the error messages being returned:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
You will need to contact your host to have these settings changed. "
This is what my host said
"You can create your own [url removed, login to view] file inside whatever sub-directory your script is in. You can then determine the exact behaviour for your PHP scripts yourself.
Have a look at [url removed, login to view] you'll find all the information you need there. The [url removed, login to view] file you create takes precidence over the global one for all scripts in the same folder as the php.ini."
Can this actually be fixed using [url removed, login to view] does anyone out there know? It's not a major job but I have $25 to offer for it.