I do not see any link to Upload Video or Photo on my Groups page
There are a few possibilities behind this issue.

1. Is your group actually allow Video and Photo upload? Check the Group's setting and verify that both are enabled.

1. You are using an old template override for your JomSocial template. Try to disable template override and see whether it helps. If you are not sure what a template override is, check the existence of /templates/{yourcurrenttemplate}/html/. If there is a 'com_community' folder in /html, then it is confirmed you are using template override. To disable this override, rename com_community to a different one, perhaps com_community_old.

Symptom
Creating Group gives DB Error 500
Problem is actually because the file /com_community/libraries/featured.php did not include the core file. If you are having similar problems, edit that file and place the following codes at around line 2,
require_once( JPATH_ROOT . DS . 'components' . DS . 'com_community' . DS . 'libraries' . DS . 'core.php' );