Since the problem with the database and the forum/gallery upgrade, I've heard about and dealt with 3 main issues (in order of frequency):
1) problems playing the embedded videos.
2) repeatedly prompted to login when playing videos in firefox
3) can't access the site
The rest of the issues have been visual and we've worked on some and noted all of them.
Those of you reporting problems with the embedded videos seem to have gotten past this issue after the gallery was changed to launch videos outside the browser.
I've also not heard any more issues with the repeated firefox logon prompts in the gallery since I did a fix a couple weeks ago.
Lastly, we've had a few users who have had problems accessing portions of the site. From my research, the access problems are almost certainly related to the new version of the forum and can be solved by clearing one's cookies. Clearing cookies immediately worked for all of the users who reported back about this problem. If you're experiencing this problem, I can provide instructions on how to clear your cookies.
If anybody has been dealing with other issues or continues to struggle with the above, please send me a PM to let me know what's going on.