Receiving this 1054 error. What can I do to resolve this issue? I had other tables that I needed to create and was able to create all of the tables, but now, it seems that I need to create a missing column within a specific table. Any ideas?
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT prefix.prefixsetid, prefix.prefixid, forumprefixset.forumid FROM prefix AS prefix INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = prefix.prefixsetid)
INNER JOIN forumprefixset AS forumprefixset ON (forumprefixset.prefixsetid = prefixset.prefixsetid) ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Unknown column 'prefix.prefixsetid' in 'field list' Error Number : 1054