vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   more than 1000 database errors daily (https://vborg.vbsupport.ru/showthread.php?t=184313)

elbacha 07-03-2008 07:42 PM

more than 1000 database errors daily
 
1 Attachment(s)
Hello all :)

all members in my forum are suffering and don?t have ( from time to time ) access since the upgrade to the version 3.7.
we are often facing this problem in our vBulletin forum andI am receiving many database errors and here an example on location _http://www.marahibsat.com/forum

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, session.lastactivity,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid,
IF(user.options & 512, 1, 0) AS invisible
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1215032688
ORDER BY username ASC, lastactivity DESC;

MySQL Error : Out of memory (Needed 13421600 bytes)
Error Number : 5
Request Date : Wednesday, July 2nd 2008 @ 06:04:48 PM
Error Date : Wednesday, July 2nd 2008 @ 06:05:02 PM
Script : http://www.marahibsat.com/forum/show...=16742&page=25
Referrer : http://www.marahibsat.com/forum/forumdisplay.php?f=186
IP Address : xx.149.93.xxx
Username : saed
Classname : vB_Database
MySQL Version : 5.0.45
please tell me what is wrong ? :confused:

Thank you in advance.

Michael Morris 07-03-2008 07:46 PM

You're out of memory. You'll need to adjust the config to reduce the number of connections most likely to bring it back in line.

elbacha 07-03-2008 07:50 PM

Quote:

Originally Posted by Michael Morris (Post 1566127)
You're out of memory. You'll need to adjust the config to reduce the number of connections most likely to bring it back in line.

thank you for your reply , but this happen with only 30 members ....
in the past was no problem with more than 300 members in the same time.

MarahibSat 07-03-2008 08:37 PM

1 Attachment(s)
Quote:

Originally Posted by Michael Morris (Post 1566127)
You're out of memory. You'll need to adjust the config to reduce the number of connections most likely to bring it back in line.

So in your opinion, adjust config must be done by the host server?
Also, please note that in admcp > maintenance > Repair / Optimize Tables didn't solve the problem
Thios is annoying for our board and we are loosing members each day since now 2 months :(

Also we have two kinds of erros, the one posted by elbacha and this one error2

Videx 07-04-2008 12:21 AM

It certainly could be that your host has implemented some sort of new restrictions. I hope you've opened a trouble ticket with them?

elbacha 07-04-2008 06:23 AM

The forum will be moved next days to another server, but we want an urgent solution for this problem ( just for two weeks )

Marco van Herwaarden 07-04-2008 07:12 AM

As already stated you will need to raise the MySQL memory limit, you most likely will need to ask your host about this.

elbacha 07-04-2008 05:40 PM

I saw some where this
Quote:

PHP and MySQL Requirements

Please note that vBulletin 3.7.x requires at least PHP 4.3.3 and MySQL 4.0.16 or later.

However, we recommend that vBulletin 3.7.x is run on PHP 5.2.6 with APC (or a similar opcode cache) and MySQL 5.0.51 for best performance and stability
We have :
PHP 5.2.6
MySQL 5.0.45

Is the problem cosed by the PHP?

SEOvB 07-04-2008 05:58 PM

If you are using php version 2.11.2.1 you're horribly out of date and need to upgrade that.

How vBulletin is working some of the time is beyond me, and i dont even think php2 will work with mysql5 but who knows

elbacha 07-04-2008 06:27 PM

sorry I must update my post
PHP is :5.2.6
PHP Memory Limit 16.00 MB
MySQL Version 5.0.45
MySQL Packet Size 16.00 MB

Alfa1 07-04-2008 08:53 PM

Up your memory_limit to 40MB


All times are GMT. The time now is 10:11 PM.

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.01074 seconds
  • Memory Usage 1,733KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (11)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete