HomeUnityBlogs
 
 
sunnyone341

A Constant Error Message

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

bad
0
good
 
 

Comments

dadniel
dadniel 154 days agocomment permalink
 
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
 
bad
0
good
 
 
VictorT
VictorT 151 days agocomment permalink
 
dadniel is right.

Please contact your hosting to allocate more memory for MySQL.

That should do.
 
bad
0
good
 
 
sunnyone341
sunnyone341 127 days agocomment permalink
 
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.
 
bad
0
good
 
 
sunny2008
sunny2008 104 days agocomment permalink
 
Did you fix the problem? If yes how?
thanks
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
sunnyone341 Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.507890939713