I am receiving the following database error:
Database error in Cuckold For Me
Query:
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
WHERE 1 AND `Profiles`.`Status` = ‘Active’ AND `Profiles`.`LastNavTime` > SUBDATE(NOW(), INTERVAL 30 MINUTE)
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
Mysql error:
Out of memory; restart server and try again (needed 65528 bytes)
Found error in file /var/www/cck/search_result.php
at line 575. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /var/www/cck/search_result.php
[line] => 575
[function] => db_res
[args] => Array
(
[0] =>
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
WHERE 1 AND `Profiles`.`Status` = ‘Active’ AND `Profiles`.`LastNavTime` > SUBDATE(NOW(), INTERVAL 30 MINUTE)
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
)
)
)
Called script: /search_result.php
Request parameters:
Array
(
[online_only] => 1
)
Any help in solving the error? Thank you.



Make Meaning Or Die
We need to know MySQL server settings on your server.
Actually, the value of “max_allowed_packet” option. Can you find out it by yourself or with the help of your hosting company?
Also we would like to know what hosting plan you are using.
My MySQL version is 5.0.24. The max_allowed_packet is 1,047,552. Character set is UTF-8- Unicode. I am using Jumpline’s virtual server - but I have all access to MySQL and PHP options.