Icy Phoenix

Old Support Topics - Error Creating New Session Is Back Again!

darkasylum [ Sun 12 Sep, 2010 09:22 ]
Post 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

Informpro [ Sun 12 Sep, 2010 18:41 ]
Post subject: Re: Error Creating New Session Is Back Again!

truncate the table.

darkasylum [ Wed 15 Sep, 2010 16:55 ]
Post 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.

Informpro [ Wed 15 Sep, 2010 17:04 ]
Post subject: 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 ]
Post 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: [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