vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   i need a help ..The table 'session' is full ??? and more issues (https://vborg.vbsupport.ru/showthread.php?t=203194)

Y-ZOOM 01-26-2009 08:48 PM

i need a help ..The table 'session' is full ??? and more issues
 
Hello

After i transferred my forum to a dedicated server i faced some problems

This one

:::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::

Database error in vBulletin 3.7.4:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, invideocategory, invideo)
VALUES
('7248dff1742302f045aebca37e0e9366', 2, '82.114.184.107', '17a17e9d86870c3fb9dfb25f570ccfed', 1232994870, '/vb/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1', 0, 0, 0, 0);
MySQL Error : The table 'session' is full
Error Number : 1114
Request Date : Monday, January 26th 2009 @ 04:34:30 PM
Error Date : Monday, January 26th 2009 @ 04:34:30 PM
Script : http://y-zoom.com/vb/
Referrer :
IP Address : 82.114.184.107
Username : Y-zoom
Classname : vB_Database
MySQL Version : 5.0.67-community

:::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::


in my old hosting everything was okay .. is there any settings my server needs

and how can i optimize my server to solve this issue .. ??

i emptied the table but i need another solution to fix that !!


:::::::::

Also i need to make my forum faster .. is there any way to optimize my PHP and Sql to be faster ??

sorry im not good in English

thanks

Dismounted 01-27-2009 04:15 AM

1) Does it error happen often? If it has happened just once, leave it. (Although you may want to check how much free RAM you have on the server, as the session table is stored in memory.)

2) On the vBulletin.com Server Configuration forum you can get general PHP/MySQL optimisation suggestions by one of our Support Professionals.


All times are GMT. The time now is 12:40 AM.

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.03853 seconds
  • Memory Usage 1,713KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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