https://www.icyphoenix.com/viewtopic.php?f=35&t=7360
-----------------------------------
darkasylum
Sun 12 Sep, 2010 09:22

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


-----------------------------------
Informpro
Sun 12 Sep, 2010 18:41

Re: Error Creating New Session Is Back Again!
-----------------------------------
truncate the table.


-----------------------------------
darkasylum
Wed 15 Sep, 2010 16:55

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.


-----------------------------------
Informpro
Wed 15 Sep, 2010 17:04

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


-----------------------------------
Mighty Gorgon
Wed 15 Sep, 2010 23:17

Re: Error Creating New Session Is Back Again!
-----------------------------------
Try one of these:

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

You can also try to run this SQL:
[codeblock]ALTER TABLE phpbb_sessions TYPE = MYISAM;[/codeblock]

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


