repair table xf_forum;
ALTER TABLE xf_forum ADD discussion_count INT UNSIGNED NOT NULL DEFAULT 0, last_post_username VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user', find_new TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Include posts from this forum when running /find-new/threads';
Oh no, Borbole, I don't have a backup. How does this even happen. Logged on this morning, logged off for 30 minutes and when I logged back in it was 'gone.'
Tried running the inquiry, Arty, but not sure I did it right. When I click on SQL there is a first line already type in. I tried running your query with that line in tact and get an error, I tried removing that first line and adding what you said and it gives me an error too.
View attachment 34268