Go Back   vb.org Archive > Community Discussions > Forum and Server Management
  #1  
Old 04-18-2010, 06:10 AM
KDawg08 KDawg08 is offline
 
Join Date: Nov 2008
Location: Washington State
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default DB Error? Help please.

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>1271479245;

MySQL Error : Out of memory (Needed 1048548 bytes)
Error Number : 5
Request Date : Saturday, April 17th 2010 @ 01:10:45 AM
Error Date : Saturday, April 17th 2010 @ 01:10:47 AM
Script : http://MYSITELINK.net/misc.php?show=ccbmessages
Referrer : http://MYSITELINK.net/index.php
User : Justin

How do I fix this? LOL... I am getting TONS of emails saying this... Any suggestions?
This is happening with more than one user: showing up. for example Justin, -Noodle Squad- etc.



here is the recent info from my error log file:

[13-Apr-2010 04:05:16] PHP Fatal error: Out of memory (allocated 6291456) (tried to allocate 19456 bytes) in /home/twistede/public_html/includes/functions_user.php on line 677
[13-Apr-2010 04:05:16] PHP Fatal error: Out of memory (allocated 6553600) (tried to allocate 311296 bytes) in /home/twistede/public_html/infernoshout/engine/inferno_shout.php on line 491
[13-Apr-2010 04:05:16] PHP Fatal error: Out of memory (allocated 2621440) (tried to allocate 16 bytes) in /home/twistede/public_html/includes/class_core.php on line 1335
[13-Apr-2010 14:51:09] PHP Fatal error: Out of memory (allocated 786432) (tried to allocate 311296 bytes) in /home/twistede/public_html/includes/init.php on line 505
[15-Apr-2010 19:29:46] PHP Fatal error: Out of memory (allocated 5242880) (tried to allocate 57 bytes) in /home/twistede/public_html/includes/functions.php on line 5266
[16-Apr-2010 05:00:21] PHP Fatal error: Out of memory (allocated 6291456) (tried to allocate 311296 bytes) in /home/twistede/public_html/global.php(607) : eval()'d code on line 322
Reply With Quote
  #2  
Old 04-18-2010, 08:16 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Increase the amount of memory allocated to PHP. You might need to ask yout host.
Reply With Quote
  #3  
Old 04-18-2010, 08:54 AM
metalguy639 metalguy639 is offline
 
Join Date: Dec 2008
Posts: 501
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you have access to your php.ini you can change the amount of memory in there. Look for this or something similar in yuor php.ini file.

Code:
memory_limit = 32M  ;
Then you can increase it to 64 or 128 usually is what most people do. So it would look like this:

Code:
memory_limit = 64M  ;
Or this


Code:
memory_limit = 128M  ;
Then save your php.ini file and upload it back where you found it overwriting the old one. Some hosts will not allow you to edit your php.ini file, so as he said you will have to ask them. Some will charge you to update your account to more memory so be prepared for that possibility.
Reply With Quote
  #4  
Old 04-18-2010, 10:36 AM
Infopro Infopro is offline
 
Join Date: May 2003
Location: Pennsylvania
Posts: 267
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Kill the crappy shoutbox (or whatever it is causing the problems).
https://vborg.vbsupport.ru/showthread.php?t=182292
http://www.vbulletin.com/forum/showt...with-No-reason

Many more here:
http://www.google.com/search?hl=en&s...&q=ccbmessages

Throwing more memory at this is a waste of time and resources, IMHO.
Reply With Quote
  #5  
Old 04-22-2010, 02:31 AM
KDawg08 KDawg08 is offline
 
Join Date: Nov 2008
Location: Washington State
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks all, i appreciate it. And it is on the "CYB CHATBOX" because i have 2 running, one for general public chat etc, and one for staff shoutbox.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:51 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04089 seconds
  • Memory Usage 2,195KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete