HomeNotesA Constant Error Message
1576 days ago in 
Tags: error, message
Reactions: 4 comments 0 points0 reports
 
 

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

Plussed by

 
 
 
 

Comments

Oldest First
|
Threaded
 
 
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
 
 
 
PET:0.052397012710571