vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Forum Messed up and saying datbase error plz help? (https://vborg.vbsupport.ru/showthread.php?t=288437)

MegaManSec 09-28-2012 06:37 PM
PM me what the error is please.
And yes, I can atleast load the website now. but database error.

Mark_Zuckerberg 09-28-2012 06:43 PM
pm sent to you please check

MegaManSec 09-28-2012 07:26 PM
Sorry I forgot about this.

edit your mysql config file and raise max_user_connections to something higher than it currently is.
You should probably check your logs and find out what is causing it..
Then you can block them from your website.

Mark_Zuckerberg 09-28-2012 07:30 PM
i am getting mails again and again the users are from same ip range and the site is giving database error

MegaManSec 09-28-2012 07:32 PM
what is the 'common' ip address? like the ip address that is most likely causing the problem?

Mark_Zuckerberg 09-28-2012 07:40 PM
lastly i have installed this mod will it be the reason or not

Code:
https://vborg.vbsupport.ru/showthread.php?t=267506
The ip is 180.76.5.89 and so on changes the last 2 digits

--------------- Added [DATE]1348864877[/DATE] at [TIME]1348864877[/TIME] ---------------

i have blocked the ips of china as this ip os from china

MegaManSec 09-28-2012 08:13 PM
That's baidu spider.. that shouldn't be a problem.
Are there any other 'common' ip address's?

Mark_Zuckerberg 09-28-2012 08:22 PM
hosting guy said

Quote:
It appears multiple connections are being made to the database and not being killed off, causing the database not to be able to service any new requests. The site is up at this time. I would advise to reach out to you web developer in regards to this issue.
--------------- Added [DATE]1348867922[/DATE] at [TIME]1348867922[/TIME] ---------------

he also send me some recommendations which are this

Quote:
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 32M)
join_buffer_size (> 1.0M, or always use indexes with joins)
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
what should i do know can you help me out?

CAG CheechDogg 09-28-2012 08:34 PM
Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.

Mark_Zuckerberg 09-28-2012 08:39 PM
Quote:
Originally Posted by CAG CheechDogg (Post 2369326)
Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.
how can i find that any path details?


All times are GMT. The time now is 05:14 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01016 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete