Dbase Error Snapshot - Hostgator or D7 issue?

The error Dump is 3MB so I'll just paste the first few paragraphs. But DINO did experience and outtage last week which I mentioned in another post. But I'll still getting intermittant DB connect issues. Does this help anyput point me towards an overload or code issue?

Database error in

Query:

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 47 AND `` = 'female'

Mysql error: Unknown column '' in 'where clause'

Found error in the file '/home/cityofme/public_html/inc/match.inc.php' at line 57.
Called 'getAllWithKey' function with erroneous argument #0.

syde,

you see where your query is asking the database to produce something that it cant find? in the where clause and that is why the error is being thrown at you.

WHERE 'Status' = 'Active' AND 'ID' !=47 AND `` = 'female'

what is the `` that is supposed to be female, if the ID is 47, then what is it looking for ?

Regards,

DosDawg

can you paste line 57 of that file? is this is custom mod that you just loaded?

Regards,

DosDawg

I get a big error report in the 3mb range sometimes. Most of the time in my case it's because mysql is down, restarting or rebooting. Once it is back up and no more error reports.

The thing that I find that uses a lot of resources is ffmpeg.exe, and secondly it is the member menu profiler bar. Ffmpeg puts a large strain on the server, but generally it's brief while the video is converting.

The member menu profiler bar seems to almost constantly slow things down. I am getting to the point that I don't even bother installing or enabling the module on most shared hosting environments.

Dolphin 7 is very near too much for shared hosting. If they do not optimize this thing much more, or should newer versions of Dolphin consume even more resources in the future shared hosting wouldn't even be an option for d7.

Other than that possibly turn off persistent connections. Try increasing mysql connection timeout slightly. You can see about increasing the max connections, but you wont be able to increase this on shared hosting.

There is almost no way one could have 2 average dolphin 7 sites on 1 shared hosting account. Unless both have absolutely no traffic or members and were for testing or something. Most people look for cheap shared hosting, which is totally understandable. When they can't get it to work right on cheap shared hosting or too many resources are being consumed they are not very likely to spend more in the $20-$50 per month category for fear that it will not work either. I probably wouldn't either.

Anyway good luck with it. I know it can be frustrating.