XF 2.1 An error occurred while the page was being generated. Please try again later.

[htsumer]

An error occurred while the page was being generated. Please try again later.
problem may cause

 

[htsumer]

MySQL query error [1114]: The table 'xf_session_activity' is full

 

[Ozzy47]

Use phpmyadmin and truncate then session table.

 

[htsumer]

I'm using VPS no cpanel

 

[Ozzy47]

You have some kind of control panel?

 

[htsumer]

No not. Getting backup with SSH

I downloaded the database.
I emptied it like that I can restore

LOCK TABLES xf_session_activity WRITE;
/ *! 40000 ALTER TABLE xf_session_activity DISABLE KEYS * /;
/ *! 40000 ALTER TABLE xf_session_activity ENABLE KEYS * /;
UNLOCK TABLES;