Hello ... i just tryed to upgrade my vshare script to 2.7 an when i run upgrade script i get this error

Error at the line 43: ALTER TABLE `uservote` DROP `voted_date` ;
Query: ALTER TABLE `uservote` DROP `voted_date` ;
MySQL: Can't DROP 'voted_date'; check that column/key exists




and in the front page i get this error


ERROR: Unable to execute query

SELECT * FROM `videos` WHERE
`video_type`='public' AND
`video_active`='1' AND
`video_approve`='1' AND
`video_featured`='yes'
ORDER BY `video_add_time` DESCUnknown column 'video_type' in 'where clause'



any help please?