[Error Message] 1114 - The table 'mybb_sessions' is full

[both4x060]

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1114 - The table 'mybb_sessions' is full
Query:
INSERT INTO mybb_sessions (`sid`,`uid`,`ip`,`location`,`time`) VALUES ('exdroid__vlz4qlmiYUJzwfe','869','','stats.php','1362403694')

how to fix this strange problem?

I do not have a VPS, I'm using just one hosting space

Thanks in advance

[Euan T]

Via phpmyadmin, run this query:

TRUNCATE TABLE mybb_sessions;

Note this will remove all sessions and users will have to login again.

[StefanT]

users will have to login again.

No, that's not stored in that table.

[both4x060]

I run but it still the usual error

[Euan T]

Odd, I was sure that it was. I've never tried emptying the sessions in the past though.

[Euan T]

So you're still getting the same error after having ran the above query? If so, it may be worthwhile contacting your host.

[both4x060]

So you're still getting the same error after having ran the above query? If so, it may be worthwhile contacting your host.

there is no other solution? : (

[Euan T]

What table type are you using? By default it will be MyISAM. Have you modified it at all (eg: to InnoDB or Memory)?

[crazy4cs]

This user has been denied support.

Odd, I was sure that it was. I've never tried emptying the sessions in the past though.

Yup, login has to do with loginkey or so I believe in the users table. Truncating sessions won't logout users.

[both4x060]

What table type are you using? By default it will be MyISAM. Have you modified it at all (eg: to InnoDB or Memory)?

all tables use "MyISAM", only Mybb_Session is using "MEMORY".