BOONEX.COM BOONEX BLOG BOONEX DEVZONE



Database Error

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.

2 Responses to “Database Error”


  1. 1 Victor T.

    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.

  2. 2 sunnyone

    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.

Leave a Reply

You must login to post a comment.