MyBB Community Forums

Well, you learn something new every day!

(2013-03-04, 02:04 PM)both4x060 Wrote: [ -> ]

(2013-03-04, 01:56 PM)Euan T. Wrote: [ -> ]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".

Well, there's the issue. Revert the table type back to MyISAM or ask your host to increase the memory limit for your database.

"Revert the table type back to MyISAM"

how can I do that?

Run this query in phpmyadmin:

ALTER TABLE mybb_sessions ENGINE=myisam;

You obviously modified the table type to memory yourself though in the past s all tables are MyISAM by default within MyBB.

(2013-03-04, 02:09 PM)Euan T. Wrote: [ -> ]Run this query in phpmyadmin:

ALTER TABLE mybb_sessions ENGINE=myisam;

You obviously modified the table type to memory yourself though in the past s all tables are MyISAM by default within MyBB.

Done, it doesnt work

Are you getting the same error or a different one?

Try this query:

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;

where tbl_name is the TABLE name of which you want to increase the size.

(2013-03-04, 02:22 PM)Euan T. Wrote: [ -> ]Are you getting the same error or a different one?

same

---

(2013-03-04, 02:33 PM)EGman Wrote: [ -> ]Try this query:

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;

where tbl_name is the TABLE name of which you want to increase the size.

the table is empty, is 0b
but same error SSSSSSSSSSSSSS

And the table type is definitely MyISAM now? Could you provide your URL?

Refer to here: http://dev.mysql.com/doc/refman/4.1/en/full-table.html

This might help you.