The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
database error 1114 please help
im getting hundreds of these errors. I cant into site or admin cp. any help?
here is one of the emails I got. Database error in vBulletin 4.2.2: Invalid SQL: INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('89a72c78d61e86d1dc0d5374109718f4', 0, '172.245.240.188', '163693b0749e3ff4787c0d7c2b37ff68', 1402975383, '/vb4/member.php?u=5656-WKLGY', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/28.0.1500.52 Chrome/28.0.1500.52 Safari/537.36', 0, 0, 0, ''); MySQL Error : The table 'session' is full Error Number : 1114 Request Date : Monday, June 16th 2014 @ 10:23:03 PM Error Date : Monday, June 16th 2014 @ 10:23:03 PM Script : http://www.rzrlife.com/vb4/member.php?u=5656-WKLGY Referrer : http://www.rzrlife.com/ IP Address : 172.245.240.188 Username : Unregistered Classname : vB_Database MySQL Version : |
#3
|
|||
|
|||
Read this thread, with advice from @Lynne:
http://www.vbulletin.com/forum/forum...-table-is-full |
#4
|
|||
|
|||
How and where do I do this? I ant access admin cp. Do I do this in the files on my server?
Can you walk me through this, anyone? I have never done this. thanks chris |
#5
|
|||
|
|||
First Backup your database!
Since you do not have access to the admincp. Use a MySql administration tool that you have access to and truncate the "session" table in your database. Ex: phpMyAdmin After you clear the table make sure you did not delete the cronimage from the footer template. |
Благодарность от: | ||
RichieBoy67 |
#6
|
||||
|
||||
This can happen if your session/cookie time is set to high.
You can do as tbworld said or even a simple mysql restart with ssh would work. Depends on your server but most common is /etc/init.d/mysqld restart - just log in using putty and use that. |
#7
|
|||
|
|||
Quote:
|
#8
|
|||
|
|||
The cronimage is located in the footer template, it's called {vb:raw cronimage}. Might want to check if it exists in the template.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|