(2012-03-24, 01:48 PM)Nathan Malcolm Wrote: [ -> ]It's because mybb_posts is MyISAM and mybb_sessions is memory. The memory limit for tables is too low, so it only affects the sessions table.
Ok, however, can you explain me this as well.
I got this error on the administrator account with UID 1, but not on my test account? Why's that?
(2012-03-24, 02:26 PM)jard0n5 Wrote: [ -> ] (2012-03-24, 01:48 PM)Nathan Malcolm Wrote: [ -> ]It's because mybb_posts is MyISAM and mybb_sessions is memory. The memory limit for tables is too low, so it only affects the sessions table.
Ok, however, can you explain me this as well.
I got this error on the administrator account with UID 1, but not on my test account? Why's that?
That could be anything. But it's not an issue with MyBB, it's an issue with the configuration so that's irrelevant.
(2012-03-24, 02:48 PM)Nathan Malcolm Wrote: [ -> ] (2012-03-24, 02:26 PM)jard0n5 Wrote: [ -> ] (2012-03-24, 01:48 PM)Nathan Malcolm Wrote: [ -> ]It's because mybb_posts is MyISAM and mybb_sessions is memory. The memory limit for tables is too low, so it only affects the sessions table.
Ok, however, can you explain me this as well.
I got this error on the administrator account with UID 1, but not on my test account? Why's that?
That could be anything. But it's not an issue with MyBB, it's an issue with the configuration so that's irrelevant.
Alright, I guess there's nothing I can do in this case? No solutin?
(2012-03-24, 05:00 PM)Nathan Malcolm Wrote: [ -> ] (2012-03-24, 04:46 PM)jard0n5 Wrote: [ -> ] (2012-03-24, 02:48 PM)Nathan Malcolm Wrote: [ -> ] (2012-03-24, 02:26 PM)jard0n5 Wrote: [ -> ] (2012-03-24, 01:48 PM)Nathan Malcolm Wrote: [ -> ]It's because mybb_posts is MyISAM and mybb_sessions is memory. The memory limit for tables is too low, so it only affects the sessions table.
Ok, however, can you explain me this as well.
I got this error on the administrator account with UID 1, but not on my test account? Why's that?
That could be anything. But it's not an issue with MyBB, it's an issue with the configuration so that's irrelevant.
Alright, I guess there's nothing I can do in this case? No solutin?
http://community.mybb.com/thread-115528-...#pid836623
Oops, must've missed that post! How'd I edit the limit in there? Could you give me a mini-guide?
Thank you.
Edit my.cnf and find the line max_heap_table_size={var}M and change it to a higher value.
For example, change:
max_heap_table_size=20M
to:
max_heap_table_size=100M
There's only:
max_connections = 600
max_allowed_packet = 16M
max_connect_errors = 10
Try adding max_heap_table_size=100M then restarting mysqld. That should fix the issue completely.