Thank You Like - Recount very slow

[lost puppy]

I tested it and all was well until the 5th query (creation of tyl_tnumtyls column) and the error given was:

Error
SQL query: Copy


PREPARE stmt FROM @query;
MySQL said: Documentation

#1044 - Access denied for user 'REDACTED'@'%' to database 'information_schema'

Do you also get an error when you run this (after replacing "YOURPREFIX" with your actual prefix)?

SHOW COLUMNS FROM `YOURPREFIX_threads` LIKE 'tyl_tnumtyls';

And is your threads table using the InnoDB engine? You can check by running (same replacement as previously):

SHOW CREATE TABLE `YOURPREFIX_threads`;

The last line of the output will include "ENGINE=[the engine type]".

No error on the first one ... second one runs and states:

 Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

And then states:

Your SQL query has been executed successfully.

After which it shows a small table?

Just ran the full set of queries again to check that I did it correctly and had the same error.

Edit to add:

Having a quick read and seeing this:

InnoDB is a storage engine for the database management system MySQL and MariaDB. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type.

All the tables in the db are MyISAM
But looking at the db structure it does say "innoDB is the default storage engine on this MySQL server"

   

But the server is running:
MyBB version: 1.8.35
PHP: 8.0.30
MySQLi: 10.6.12