Error Creating New Session Is Back Again!


Subject: Error Creating New Session Is Back Again!
Critical Error

hi guys,

i keep geting this error about every 24 hrs.
i clear the error every time with
/forum/adm/erc.php

can suym one please tell me how fix this so does not happen again?

i am using Phoenix 1.3.0.53a with patch rc 2 (mabye)

with thanks



Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'bbxs5_sessions' is full

INSERT INTO bbxs5_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_user_agent, session_page, session_logged_in, session_admin) VALUES ('e1fca720975a65e105d49335b545f6cb', 2, 1284273265, 1284273265, '5228850d', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.2; Creative AutoUpdate v1.40.01)', 'index.php', 1, 0)

Line : 243
File : sessions.php

Profile PM  
Subject: Re: Error Creating New Session Is Back Again!
truncate the table.

Profile PM  
Subject: Re: Error Creating New Session Is Back Again!
hi Informpro

i take it i truncate the table. on my host under the sql database?
under the CPanel?

truncate the table.

Profile PM  
Subject: Re: Error Creating New Session Is Back Again!
Under phpMyAdmin, select the table and clic on the tab "truncate" ;).

Profile PM  
Subject: Re: Error Creating New Session Is Back Again!
Try one of these:

http://www.icyphoenix.com/viewtopic...&highlight=heap
http://www.icyphoenix.com/viewtopic.php?f=4&t=155&highlight=heap

You can also try to run this SQL:
Code: [Download] [Hide] [Select]
ALTER TABLE phpbb_sessions TYPE = MYISAM;


Make sure phpbb_ is your table prefix, or change it accordingly.


Other info can be found here:
http://www.dwhs.net/hostingforum/viewtopic.php?t=992


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0873s (PHP: 20% SQL: 80%)
SQL queries: 10 - Debug Off - GZIP Enabled