phpBB version 3.3.1
My board (not the one in my sig) has been running since Nov 2002, and I've moved it many many times between hosts, and even between servers within hosts, since then. Extensions installed, extensions removed, etc.
Somewhere, I believe some database tables lost their indexes.
So my question: what's the best way to go through the tables ensuring the indexes are in the right places?
What I've tried: creating a backup from within ACP. Then I created a new database, installing a fresh/blank new phpBB 3.3.1, then importing the backup (data only) into it. Too many MySQL errors to work through with that approach,
Code: Select all
Unknown column 'forum_recent_topics' in 'field list' 
My thought now is to put two phpMyAdmin pages side-by-side, one with existing phpBB database and one with the new clean install, and going table by table to check indexes.