UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Very weird error this morning.

We got the following error (see attached screenshot) this morning, and no pages of the forum were accessible. Whatever the problem was, it resolved on its own. Uncaught mysqli_sql_exception: the table 'sbf_ONLINE' is full. (We have debugging enabled at this time.)

No idea what could have caused this.

This is the table information at this time.

That is extremely strange, the first part of the altertable portion of the v8 upgrade utility was supposed to convert the two memory tables (ubbt_ONLINE and ubbt_TOPIC_VIEWS) to a standard MyISAM table from a MEMORY/HEAP table.

The initial fix in ~v7.1 was to make this high resource table exist only in MEMORY so that it wasn't constantly writing to the disk, but now adays this isn't needed as SSD disks are common and the speed improvement isn't really happening anymore. You can read more in the in a support page here.

You have two choices, either convert the table to a MyISAM table in PHPMyAdmin (I believe under operations) or empty the table and leave it as a MEMORY type.

convert to MySAIM or MyISAM?

MyISAM will be the only one of those to display in the "Storage Engine" dropdown, under Operations, in PHPMyAdmin

Thank you. I converted both tables to MyISAM.