Well the database is backed up and the sql errors suggested to me the above was correct so I tried it and it worked!

Thanks to all those that helped!!!!!!!!!!!!!!!