more than 1000 database errors daily

[elbacha]

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

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 ?

Thank you in advance.

[Michael Morris]

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]

Originally Posted by Michael Morris

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]

Originally Posted by Michael Morris

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]

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]

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]

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

[elbacha]

I saw some where this

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]

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]

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