A Constant Error Message

sunnyone341 posted 1st of February 2008 in Community Voice. 4 comments.
Hello:

I receive this error message every time someone does a search on my site.  I would be really happy if I could fix it.  Thanks! I have an Apache web server, PHP 5.2, MySQL 5+.  

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

 
Comments
·Oldest
·Top
Please login to post a comment.
dadniel
I believe the error is caused by memory allocation on the host.

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
VictorT
dadniel is right.

Please contact your hosting to allocate more memory for MySQL.

That should do.
sunnyone341
I can change the php ini file myself. What is the appropriate memory allocation that I should change it to? How exactly should I state it - I can place any changes to the phi ini file in a 99ini file.
sunny2008
Did you fix the problem? If yes how?
thanks
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.13443803787231