Thread Rating:
  • 2 Vote(s) - 2.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] Fix MYBB Error Sessions
#1
Not Solved
I am using wamp server and I tried uploading my 160mb database but I always getting this error:

Quote:#1114 - The table '342536892_sessions' is full

The storage engine is memory on sessions table.

And the php.ini configuration file is:

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

My backup format is name.sql, is there a way that I can get rid the session table? So I can upload the backup file of my database. Thank You!
#2
Not Solved
This user has been denied support. This user has been denied support.
Try to upload via bigdump?
#3
Not Solved
(2012-12-28, 07:23 AM)crazy4cs Wrote: Try to upload via bigdump?

[Image: YZ0xO.png]

[Image: syb02.png]

Just the same Sad
#4
Not Solved
This user has been denied support. This user has been denied support.
Try adding this to your mysql config file in wamp (my.cnf) and then restart the wamp server:

tmp_table_size=1G
max_heap_table_size=1G

If it still gives error, try to increase the value from 1G to something higher.
#5
Not Solved
(2012-12-28, 07:55 AM)crazy4cs Wrote: Try adding this to your mysql config file in wamp (my.cnf) and then restart the wamp server:

tmp_table_size=1G
max_heap_table_size=1G

If it still gives error, try to increase the value from 1G to something higher.

Same problem Sir. I've added that on my.ini Sad and tried increasing to a higher value..
#6
Not Solved
Convert your sessions table to InnoDB and upgrade MySQL to at least 5.5 branch.
#7
Not Solved
This user has been denied support. This user has been denied support.
Strange. There are quite few articles which maybe helpful, doing a quick search:

http://linuxadminzone.com/fix-mysql-memo...e-is-full/
https://www.google.com/search?q=The+tabl...00&bih=799
#8
Not Solved
And btw you don't need to restore the sessions table. You can truncate it.
#9
Not Solved
That will come in handy, thanks! Right now, session tables are in InnoDB and they are working just fine. +REP Both of you guys!


Forum Jump:


Users browsing this thread: 1 Guest(s)