Thank You Like - Recount very slow

[Laird]

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]".