Here is yet another post about deleting the Login Module. I created a login page and redirected the login link to this page and through sheer stupidity I deleted the login module. I tried John Mitchelles OpenSesame.aspx but it didn't work. After investigating further I see that (correct me if I am wrong) the LoginTabId is now found under vw_Portals. I attempted to updated the database. SQL is not my strong point. When I attempted to update the database I got this error:
ERROR: Cannot update the view or function "database.dbo.vw_Portals" because it contains aggregates or a DISTINCT clause.  After further investigation I guess I need to change "something" so that it does not contain aggregates or a DISTINCT clause. I have no idea how to do that of if that is even what I need to do.

This SQL solved the issue:
Update dbo.PortalLocalization  
Set   LoginTabId=NULL  
Where PortalId=0 

The LoginTabId had been moved to PortalLocalization
http://www.dotnetnuke.com/Community/F...

I recycled the application pool and then used 
the following link trick:
www.mysite.com/default.aspx?ctl=login
adding the ?ctl=login

Fixed!!!

Sorry for the double post I got an error on the first post ...posted again...and noticed later there was a double post.