Error in Community VIDEO Modern AAC

[airton]

IN http://localhost/index.php/video/main have one bug:

Error Number: 1054

Unknown column 'v.author' in 'on clause'

SELECT `v`.*, `p`.`name` as author FROM (`videos` v) JOIN `players` p ON `p`.`id` = `v`.`author` ORDER BY `views` desc

IN http://localhost/index.php/profile/community have other:

Error Number: 1054

Unknown column 'videos.title' in 'field list'

SELECT videos.title, videos.youtube, videos.time, videos.views, videos.id FROM videos ORDER BY id DESC LIMIT 5

please I am beginner, do not know much about mysql, send me the command to run me

Thanks.

 

[Gabriel Tibiano]

ALTER TABLE `videos` ADD `title` VARCHAR( 255 ) NOT NULL, 
ADD `author` VARCHAR( 32 ) NOT NULL;

 

[airton]

Thanks mate, but to no avail the error still persists! = (

 

[Gabriel Tibiano]

the same errors? lol can't be the same errors, post here