Error upgrading

[marbles1704]

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?

[hostonnet]

Are you upgrading from vshare 2.6 ?

Mail me at [email protected] i can check your installation.

[marbles1704]

yes .. from 2.6

[ramesh]

I think upgrade is not completely done.

[gertiebeth]

I have this problem as well. Ran the install.php file twice too:

ERROR: Unable to execute query
SELECT * FROM `videos` WHERE
`video_view_time`<>'0000-00-00 00:00:00' AND
`video_type`='public' AND
`video_active`='1' AND
`video_approve`='1'
ORDER BY `video_view_time` DESC
LIMIT 0, 4Unknown column 'video_view_time' in 'where clause'

Upgrading from 2.6 to 2.7.

Any help?

[hostonnet]

gertiebeth, look like upgrade is not done properly. If you can't get it fixed, mail me at [email protected] i can fix it.