After reading the upgrades to 3.8.1 horror stories (I upgraded one site from 3.6.8 to 3.8.1 and it went smoothly BUT noticed a immediate drag and time out errors... so I upped the ini on my server to 200) which seemed to fix the time out errors)..... but it obvious the newer vbulletin is using much more memory to run, which is not a good thing.
Anyway, I have another site which is my 'baby site' using 3.6.8pl2 board and I am petrified to attempt to upgrade not to mention the hack upogrades.... so I won't do it..... I am very stressed over this. I only have one problem which I need help with.
Every few weeks there is some type of corruption to the database which crashes the site.... I received help with told me to enter.....
DELECT FROM session;
which fixes it...... until the other day when the only thing that could fix it was.....
<!--
Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('275262210009a52c713efe395194bed0', 0, '174.xxx.xx.x', 'adb9f6a220fa9e3550b172ec989fb477', 1234645684, '/forum/main.php', 0, 0, 0, 0, 0, 0, 0, 'curl/7.15.3 (i686-pc-linux-gnu) libcurl/7.15.3 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6', 0, 0);
MySQL Error : The table 'session' is full
Error Number : 1114
Date : Saturday, February 14th 2009 @ 04:08:04 PM
Script : http://forumname/forum/main.php
Referrer :
IP Address : 174.xxx.xx.x
Username :
Classname : vB_Database
-->
The person helping said.......
I deleted all of the sessions that were in that table (32976), and this allowed the site to display.
+++++++++++++
How do I stop this from happening? Why is this happening? What causes it? Can someone lend some info. I know nothing about these things?
Anyway, I have another site which is my 'baby site' using 3.6.8pl2 board and I am petrified to attempt to upgrade not to mention the hack upogrades.... so I won't do it..... I am very stressed over this. I only have one problem which I need help with.
Every few weeks there is some type of corruption to the database which crashes the site.... I received help with told me to enter.....
DELECT FROM session;
which fixes it...... until the other day when the only thing that could fix it was.....
<!--
Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('275262210009a52c713efe395194bed0', 0, '174.xxx.xx.x', 'adb9f6a220fa9e3550b172ec989fb477', 1234645684, '/forum/main.php', 0, 0, 0, 0, 0, 0, 0, 'curl/7.15.3 (i686-pc-linux-gnu) libcurl/7.15.3 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6', 0, 0);
MySQL Error : The table 'session' is full
Error Number : 1114
Date : Saturday, February 14th 2009 @ 04:08:04 PM
Script : http://forumname/forum/main.php
Referrer :
IP Address : 174.xxx.xx.x
Username :
Classname : vB_Database
-->
The person helping said.......
I deleted all of the sessions that were in that table (32976), and this allowed the site to display.
+++++++++++++
How do I stop this from happening? Why is this happening? What causes it? Can someone lend some info. I know nothing about these things?
Comment