Script Debug 2

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.

and

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.

Kỹ năng: PHP

Xem thêm: photo job search, works global, check new messages, showing issue, says, say, said, rows, php debug, members directory, html script, got, globals, determine, behaviour, returned, need option script, pending script, select option, sub script, global error, know got, look offer, script html, examine

Mã Dự Án: #18146