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
Forward the message to your support person at your hosting company. Ask that they increase the memory - as well as increase the setting for it (if required) in the php.ini file for MySQL memory allocation.
:) - May not be the prob.. just spittin out my opinion...
D
Please contact your hosting to allocate more memory for MySQL.
That should do.
thanks