I tried to update my Ad Agency, as it was creating issues with my group pages on JomSocial, but I got this after attempting to install.
Duplicate entry '1' for key 'PRIMARY'
I attempted to delete the original Ad Agency and reinstall this newer version and received the same error. Then, it wouldn't let me reinstall the previous version either. I was hoping the group pages would begin working, but that didn't happen yet either.