[matipeacemaker]

Today we updated our vbulletin 3.7.3 to 3.8.7. During the installation some errors ocurred. This errors made reference to tables and columns that were created already.
ALTER TABLE pollvote ADD INDEX pollid (pollid, userid);

I've found this thread: https://www.vbulletin.com/forum/arch.../t-109385.html that fix the problem by erasing the pollid index.

I think that by mistake I've also erased the pollid column.

The update was succesful, but now the polls shows database error and this code:


Invalid SQL:

SELECT *
FROM poll
WHERE pollid = 521;

MySQL Error : Unknown column 'pollid' in 'where clause'
Error Number : 1054


I want to know if there's any query to insert the pollid column that was erased.

I have a database backup, but it's twelve hours old and the forum was opened so all the information that we created in these hours would be lost.


Thanks for your response.